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.
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?
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.
- Proposed as answer by josiahschlender 12 hours 4 minutes ago