Hi all,

I have a tracker that I update every week. It tracks 2 variables, and one is significantly smaller than the other.

The tracker split out information by Area Manager and Field Rep, and I have a Pivot Chart set up with Slicers above that allows the people to click on their name and see their sales & opportunities on one chart.

However, the sales number is in the hundreds or thousands, and the opportunity number is often a single digit or a zero.

I can put the opportunity number on the secondary axis manually, but as soon as I click away onto a new Sales Rep the chart resets.

Is there either a way to lock in the changes (so I can just change the chart once) or to tell Excel in some way to always plot that value onto the secondary axis?

Many thanks in advance for your help!