Chart question

[Matt]

Hi,

I have two charts and would like only one of them to be
visible at anuy one time. They occupy the same area of
the screen and would like to add a button or two to
toggle them on or off. I have run a macro which selects
one of the charts and then use Send to Back. However when
attaching the code from this macro to the button I get an
error. Can anyone help?

Thanks,
Matt

 

[Don Guillett]

This will toggle hiding/unhiding a chart
Sub hideunhidechart()
Sheets("Sheet5").ChartObjects("Chart 1").Visible = _
Not Sheets("Sheet5").ChartObjects("Chart 1").Visible
End Sub

 

[Jon Peltier]

Matt -

On this page I show how to select which chart to show based on a
selection from a combo box or list box (the second example):

http://www.geocities.com/jonpeltier/Excel/Charts/ChartTypeDropDown.html

- Jon