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

Copper Contributor

Hi,

 

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