If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
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? |
Thread Tools | |
Display Modes | |
|
|