That doesn't do one chart, it does all of the charts and shapes on the
sheet. It might do what the OP wanted, but not what I interpreted that he
wanted.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -
http://PeltierTech.com
_______
"ShaneDevenshire" wrote in
message ...
Hi,
take a look at the command Tools, Options, View tab, Show Placeholders or
Hide All. You can record a macro to toggle this on and off.
Sub ToggleCharts()
If ActiveWorkbook.DisplayDrawingObjects = xlHide Then
ActiveWorkbook.DisplayDrawingObjects = xlDisplayShapes
Else
ActiveWorkbook.DisplayDrawingObjects = xlHide
End If
End Sub
--
Thanks,
Shane Devenshire
"bhowell" wrote:
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.