If it's a chart sheet, you can use
Charts("sheet name").Visible = True/False
If it's an embedded chart, you can use
ActiveSheet.ChartObjects(x).Visible = True/False
where x is either the number of the chart object or the name of the chart.
To learn about chart names, see:
http://peltiertech.com/Excel/ChartsH...ameAChart.html
The simplest macro would be:
Sub ToggleChartVisibility()
Charts("sheet name").Visible = Not Charts("sheet name").Visible
End Sub
To learn about assigning macros to buttons:
http://peltiertech.com/WordPress/200...tton-or-shape/
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -
http://PeltierTech.com
_______
"bhowell" wrote in message
...
I have a bar chart that I would like to hide so I can possibly assign it to
a
macro and have it unhide and hide at the push of a button. Does anybody
know
if this is possible or any other ways to do it? Thanks.