Thread: Why won't data hide?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
  
Posts: 2,489
Default 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
Reply With QuoteReply With Quote