| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Grouped/outlined data only graphs when visible
hi
When i group data, it has to be visible to appear on a graph. I also want it to displaye when the grouping is collapsed. I am charting data over a year. On the summary slide, i want to only see the total of all the months, however on the accompanying graph, i want to see how the data compiled over time (even when the grouping is not displayed). Can anyone help? Thanks mickey |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Grouped/outlined data only graphs when visible
Hi,
Sounds like you have the option to 'plot visible cells only' on. Select the chart and the via the menus Tools Options Chart uncheck plot visible only. Cheers Andy wrote: hi When i group data, it has to be visible to appear on a graph. I also want it to displaye when the grouping is collapsed. I am charting data over a year. On the summary slide, i want to only see the total of all the months, however on the accompanying graph, i want to see how the data compiled over time (even when the grouping is not displayed). Can anyone help? Thanks mickey -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Grouped/outlined data only graphs when visible
Thanks - that's worked a treat.
Mickey Andy Pope wrote: Hi, Sounds like you have the option to 'plot visible cells only' on. Select the chart and the via the menus Tools Options Chart uncheck plot visible only. Cheers Andy wrote: hi When i group data, it has to be visible to appear on a graph. I also want it to displaye when the grouping is collapsed. I am charting data over a year. On the summary slide, i want to only see the total of all the months, however on the accompanying graph, i want to see how the data compiled over time (even when the grouping is not displayed). Can anyone help? Thanks mickey -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Importing Data | Excel Worksheet Functions | |||
| Printing only Rows with Visible Data | Excel Discussion (Misc queries) | |||
| Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
| Excel changing number formatting and source data in graphs on it's own!!! | Excel Discussion (Misc queries) | |||
| Inserting Filtered RC cell information into other worksheets | Excel Discussion (Misc queries) | |||
Linear Mode
