Forum Discussion

eeleenchoo's avatar
eeleenchoo
Copper Contributor
May 16, 2024

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.

6 Replies

  • Have you tried checking the settings of the secondary axis to ensure it remains visible regardless of slicer adjustments?
    • eeleenchoo's avatar
      eeleenchoo
      Copper Contributor

      Hi AshaKantaSharma,

       

      Yes I have checked settings.

      What are the reasons for settings to change when only filtering at slicer is done?

      • bradbeliveau's avatar
        bradbeliveau
        Brass Contributor

        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