Why won't data hide?
 

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?

Why won't data hide?
 

Hi,

If you hide the column manually it will still be displayed in the chart.
Because the chart is liked to the pivot table.
If you hide the column via the field filter the information should
disappear from the chart.

Cheers
Andy

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?

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Why won't data hide?
 

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?

Why won't data hide?
 

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?