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!
Bookmarks