| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hide the data label for a data table in a chart | Charts and Charting in Excel | |||
| Want to Hide columns in spreadsheet but NOT hide data in chart. | Charts and Charting in Excel | |||
| Trying to either hide data in a cell or reduce the data to zero | Excel Worksheet Functions | |||
| Hide/Show Sub data | Excel Discussion (Misc queries) | |||
| HOW DO I HIDE DATA AND SHOW A PLUS SIGN THAT I HAVE HIDDEN DATA H. | Excel Discussion (Misc queries) | |||
Hybrid Mode
