Share via

Need secondary axis in pivot chart with a slicer

Anonymous
2014-01-02T18:14:57+00:00

I have a pivot chart with a slicer (sample image attached).  I would like the "Net Sales" variable to automatically move to the secondary axis when selected from the slicer, however I'm not able to maintain this format when I toggle between other variables in the slicer.  Any help would be appreciated.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Ashish Mathur 101K Reputation points Volunteer Moderator
    2014-01-03T00:04:48+00:00

    Hi,

    This is a problem with a Pivot chart.  This issue can be resolved by editing the SERIES function of the chart.  Refer to the following worksheets at this link - http://www.ashishmathur.com/control-graphs-with-check-boxes-and-scroll-bars/

    1. Solution II - Nonpivot (Form A)
    2. Solution II - Nonpivot (Form B)

    In Solution II - Nonpivot (Form A) worksheet, you will observe that "No of customer" is plotted on the secondary Y-axis and toggling its visibility does not have any impact on the graph.

    Hope this helps.

    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest