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

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

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