Hiding column does not hide chart series

HFLO · #1 10-06-2017, 05:45 PM

I have a clustered column chart against a pivot table with few rows and columns.
when I hide the column, the chart still show that series.
see attached picture, where I hide column C, but the chart still show it.
am I missing something?

thanks for help.

HFLO · #2 10-08-2017, 09:45 PM

I tested again on a normal table (not Pivot table), and it works fine. When I hide the column, the chart will also 'hide' the bar column.

does it mean this feature does not work with pivot table?

Debaser · #3 10-09-2017, 12:33 AM

Yes, pivot charts don't work quite the same way. If you want to hide it from the chart you have to filter it out of the pivot table.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel Chart Edit Series w/ VBA	KyBob2	Excel Programming	0	12-16-2015 12:16 PM
Generating a chart with dynamic series	Officer_Bierschnitt	Excel	3	10-15-2015 12:30 AM
chart data series information in slideshow	jonen	PowerPoint	0	09-24-2014 01:10 AM
MS Project 2013 Reports: ACWP in Timephased Line Chart does not match ACWP in Column Chart or Table	billcary	Project	3	09-22-2014 07:10 AM
Custom animating a line chart by series and category.	Gahzi	PowerPoint	0	05-19-2009 11:53 AM