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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Totals in the data table but not in the graph / chart 1
Graph Line Width ? 1
Combining a 2-D column graph and a 2-D line graph on the same char 3
Remove Bar Graph Axis Values 0
Creating a Line Graph with Selectable Data 1
Why is the graph invisible when I move it to a "new sheet"? 1
Combination bar/stacked charts 1
Display Info in Data Table That is Not Charted? 1

Back
Top