Hide a chart

  • Thread starter Thread starter E Gray R&A
  • Start date Start date
E

E Gray R&A

My Boss is working with Excel 97 and I'm in 2007...he hid a chart in his
version and I cannot unhide it...have looked everywhere and tried all sorts
of commands with no result...anyone else having this problem?
 
Hi,

Assuming he hid the sheet - choose Home, Format, Hide & Unhide, Unhide Sheet.

If the chart has been hidden using the 2003 Objects, Hide command - choose
Office Button, Excel Options, Advanced, Display options for this workbook,
For objects, show: All.
 
Does he know what he did (oh yeah, the boss, probably not). He may have
deleted the rows or columns under the chart. This doesn't delete the chart,
it merely makes its height or width equal to zero. You could try a macro
like this:

Sub FattenUpCharts()
Dim ChOb As ChartObject
For Each ChOb In ActiveSheet.ChartObjects
If ChOb.Height < 1 then ChOb.Height = 200
If ChOb.Width < 1 then ChOb.Width= 300
Next
End Sub

If in fact the chart has been made invisible, you could try this:

Sub ShowTheCharts()
Dim ChOb As ChartObject
For Each ChOb In ActiveSheet.ChartObjects
ChOb.Visible = True
Next
End Sub

In 2007, you can go to Find and Select (far right of the Home tab), and
choose Selection Pane. This lists all shapes on the active sheet, visible or
hidden, and you can check the box to make each one visible.

- Jon
 
Back
Top