Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Hide a chart
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? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Hide a chart
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. -- Cheers, Shane Devenshire "E Gray R&A" wrote: 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? |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Hide a chart
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 ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "E Gray R&A" <E Gray wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide the tab with the data associated with a chart | Charts and Charting in Excel | |||
Hide one month in a chart | Charts and Charting in Excel | |||
Hide Chart Formulas | Charts and Charting in Excel | |||
Hide items w/a 0 value in a chart? | Excel Discussion (Misc queries) | |||
Chart help Hide Months | Charts and Charting in Excel |