Prev: Moving locations of major, secondary gridlines
Next: Finding second data point on primary axis of two axis chart
From: Margie on 9 Dec 2009 12:45
Why does hidden data still appear when a chart is generated from a pivot
table? How can I make a series disappear when I hide the column in the pivot
chart?
From: Luke M on 10 Dec 2009 07:58
PivotCharts do not work the same as regular charts. If you want the data to
be "hidden" use the Pivot dropdowns to de-select the info.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Margie" wrote:

> Why does hidden data still appear when a chart is generated from a pivot
> table? How can I make a series disappear when I hide the column in the pivot
> chart?
From: Margie on 10 Dec 2009 14:51
If I deselect the data, the calculated values change. So you can't hide it,
and you can't deselect it without changing the results displayed in the
chart. Is there any way to tackle this problem with a pivot chart?

"Luke M" wrote:

> PivotCharts do not work the same as regular charts. If you want the data to
> be "hidden" use the Pivot dropdowns to de-select the info.
> --
> Best Regards,
>
> Luke M
> *Remember to click "yes" if this post helped you!*
>
>
> "Margie" wrote:
>
> > Why does hidden data still appear when a chart is generated from a pivot
> > table? How can I make a series disappear when I hide the column in the pivot
> > chart?
 | 
Pages: 1
Prev: Moving locations of major, secondary gridlines
Next: Finding second data point on primary axis of two axis chart