Excel pivot chart's secondary axis disappears after parameter in chart is filtered at slicer

Copper Contributor



A pivot chart on Sales (primary y axis) and Rate (secondary y axis) is plotted against time (X axis). Area parameter is part of the underlying dataset, but not plotted in same chart.


When Area or Rate is filtered at respective slicer, the secondary y axis disappears i.e. pivot chart resets to having only primary y axis 


How may I keep the secondary y axis after filtering?


Thank you.

0 Replies