Why won't data hide?

  • Thread starter Thread starter Margie
  • Start date Start date
M

Margie

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?
 
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
 
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.
 
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?
 
Back
Top