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

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

--
Don Guillett
SalesAid Software

"Matt" wrote in message
...
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

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/...eDropDown.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

Matt wrote:

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