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