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.
5 Replies
eeleenchoo - I'm having the same issue. Did you find a fix?
Perhaps you could give bit more details on this or your sample file to illustrate how exactly data is structured
- 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?
this happens because excel by default deletes the secondary axis if data is filtered to null (blanks)
to fix, you need to edit underlying data to contain no blanks or edit power pivot measure to always return 0 if blank
