Grouped/outlined data only graphs when visible

[email protected] · 06-23-2006, 07:10 AM

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 · 06-23-2006, 07:25 AM

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

[email protected] 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

[email protected] · 06-23-2006, 10:00 AM

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
>
> [email protected] 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

**tuncerman** · 12-30-2010, 08:06 AM

Originally Posted by Andy Pope

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

[email protected] 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

... does anyone know how to do this also on Excel 2007? many thanks, Tunc

**Andy Pope** · 12-30-2010, 10:03 AM

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.

The option is now on the Select Data dialog.