Grouped/outlined data only graphs when visible

  • Thread starter Thread starter mickeykav
  • Start date Start date
M

mickeykav

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
 
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
 
Thanks - that's worked a treat.

Mickey


Andy said:
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
Click to expand...
 
Back
Top