Secondary Axis Disappears in Pivot Table Chart

I'm using Excel 2010 and have a pivot chart based off of a PowerPivot table with multiple slicers. The X or secondary axis disappears randomly and the only way to get it to reappear is to go back into the chart property and re-assign the value to the secondary axis.

January 29th, 2014 5:50pm

I'm having a similar problem. Does anyone  have an answer to this question?
Free Windows Admin Tool Kit Click here and download it now
August 4th, 2014 4:27pm

I had the same problem. It happens when filtered results doesn't contain values for series i used in the secondary axes. When i toggle off filters and turn back to all results the pivot chart "forget" the secondary axis setting....

Anyone have find a solution?

December 2nd, 2014 6:08am

I had the exact same problem this week when I added a second axis to my pivot chart and slicers for the first time.  The second axis would disappear as soon as I selected a different filter on the secondary axis slicer.

After several tries, I found a solution that worked for me.  I believe what caused the secondary axis to disappear was that I created the secondary axis when the slicer was filtered.  I re-created the chart with no filtering, and then added a secondary axis with all data.  My secondary axis then worked with different slicer selections.

Free Windows Admin Tool Kit Click here and download it now
August 20th, 2015 3:28pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics