Forum Discussion
eeleenchoo
May 17, 2024Copper Contributor
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...
AshaKantaSharma
Aug 20, 2024Iron Contributor
Have you tried checking the settings of the secondary axis to ensure it remains visible regardless of slicer adjustments?
eeleenchoo
Aug 20, 2024Copper Contributor
Hi AshaKantaSharma,
Yes I have checked settings.
What are the reasons for settings to change when only filtering at slicer is done?