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

Question

Hi,&nbsp;A pivot chart on Sales (primary y axis) and Rate (secondary y axis)&nbsp;is plotted against time (X axis). Area parameter is part of the underlying dataset, but not plotted in same chart.&nbsp;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&nbsp;&nbsp;How may I keep the secondary y axis after filtering?&nbsp;Thank you.

ashakantasharma · Answer

Have you tried checking the settings of the secondary axis to ensure it remains visible regardless of slicer adjustments?

eeleenchoo · Answer

Hi&nbsp;AshaKantaSharma,&nbsp;Yes I have checked settings.What are the reasons for settings to change when only filtering at slicer is done?

sergeibaklan · Answer

eeleenchoo&nbsp;
Perhaps you could give bit more details on this or your sample file to illustrate how exactly data is structured

kevingodsave · Answer

eeleenchoo&nbsp;- I'm having the same issue. Did you find a fix?

Forum Discussion

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

Share

Resources