Why won't data hide?

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?
 
A

Andy Pope

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
 
L

Luke M

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.
 
M

Margie

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filtered view of Visio Chart 0
Doughnut Chart linked with the slicer in the pivot table 0
Dates In Excel 5
Creating Network Diagram using a Chart SW integration 0
Create a chart from a table in word thats dynamic 0
Dealing with a Pivot Table (when I don't want to) 0
Bar Chart with Data Elements 1
Power Pivot. Yikes. 0

Top