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...
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