This might be a workaround for my problem in getting the last value in a bar chart to toggle between being displayed and not displayed. The bars on the x-axis represent the 4 previous quarterly averages, a 12 month average, and a summary average that is manually entered on the same datasheet. The manual entry bar is the one I want to "go away", not be hidden or set to zero. Moreover, my requester wants it to be toggled from a yes/no dropdown. I think it can be controlled by a small macro running off of the value of a checkbox. When unchecked,(Checkbox2.Value = true) the range is:
=Summary!$AH$16:$AM$16,Summary!$AH$20:$AM$20
My thought would be to change the values from $AM to $AL when it is checked (value=false).
I'd like help with this macro, or an alternative macro that is more... elegant?
Thanks!
=Summary!$AH$16:$AM$16,Summary!$AH$20:$AM$20
My thought would be to change the values from $AM to $AL when it is checked (value=false).
I'd like help with this macro, or an alternative macro that is more... elegant?
Thanks!
