Forum Discussion
Excel pivot chart's secondary axis disappears after parameter in chart is filtered at slicer
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.
- Have you tried checking the settings of the secondary axis to ensure it remains visible regardless of slicer adjustments?
Hi AshaKantaSharma,
Yes I have checked settings.
What are the reasons for settings to change when only filtering at slicer is done?
Perhaps you could give bit more details on this or your sample file to illustrate how exactly data is structured
eeleenchoo - I'm having the same issue. Did you find a fix?
