| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hidden Columns and charts
I have a a chart with the data on the same sheet. When I hide the columns
that contain the data, the chart goes blank. Is this normal? Rob |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hidden Columns and charts
Sorry all,
I found the answer myself.....I needed to apply Show data in hidden rows and columns. Rob "RobN" wrote in message ... I have a a chart with the data on the same sheet. When I hide the columns that contain the data, the chart goes blank. Is this normal? Rob |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hidden Columns and charts
Yes. Same if the chart is on another sheet. Hide some of the rows or some
of the columns, and the relevant data points are hidden from the chart. -- David Biddulph "RobN" wrote in message ... I have a a chart with the data on the same sheet. When I hide the columns that contain the data, the chart goes blank. Is this normal? Rob |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hidden Columns No Longer Hidden after Copying Worksheet? | Excel Discussion (Misc queries) | |||
| Need to sum columns, excluding hidden columns. | Excel Discussion (Misc queries) | |||
| hidden columns | Excel Worksheet Functions | |||
| How to keep hidden columns hidden using protection | Excel Discussion (Misc queries) | |||
| Hidden columns | Excel Discussion (Misc queries) | |||
![RobN[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
