Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart data from hidden rows (not columns)
I know Excel normally ignores chart data that is in hidden rows/columns, and
I know there's the option for it NOT to ignore it (i.e. have Excel built the chart even if the data is in a hidden row/column). I have a spreadsheet in which data which lies in the hidden columns is practically meaningless, but hidden rows contain numerical data which I'd like to create graphs from, but which I'd also like to remain out of sight. My question is, therefo is it possible for Excel to only ignore data in hidden *columns*, but take into account data from hidden *rows*? Anticipated thanks for your help. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart data from hidden rows (not columns)
All or nothing. Could you make the rows 1 pixel high, so they're not really
hidden? Alternatively, perhaps all the chart source data could reside on a backup worksheet, so you could show what you want and plot what you want, without one dictating the other. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "wildetudor" wrote in message ... I know Excel normally ignores chart data that is in hidden rows/columns, and I know there's the option for it NOT to ignore it (i.e. have Excel built the chart even if the data is in a hidden row/column). I have a spreadsheet in which data which lies in the hidden columns is practically meaningless, but hidden rows contain numerical data which I'd like to create graphs from, but which I'd also like to remain out of sight. My question is, therefo is it possible for Excel to only ignore data in hidden *columns*, but take into account data from hidden *rows*? Anticipated thanks for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hidden rows columns won't stay hidden | Excel Worksheet Functions | |||
Protect Hidden Columns and Rows | Excel Discussion (Misc queries) | |||
How do I avoid copying data from hidden rows/columns? | Excel Discussion (Misc queries) | |||
Display chart data contained in hidden columns | Charts and Charting in Excel | |||
hidden rows/columns | Excel Discussion (Misc queries) |