To get an automatic scaling axis:
1. Right-click the axis you wish to edit and select "Edit Axis..." (figure 1)
2. In the Edit Axis window, select the "Automatic" value from the list. (figure 2)
Let me know if that helps!
that is kind of what I want, but I would still like to control the bottom...
e.g., I changed to automatic
Y axis went from 100% to 0%
my values ranged from 100% to 97&
Could you link a copy of your Workbook so i can get a better visual idea of the goal?
let's say I only want the Y Axis to expand and contract from 100% to 90% (just to start with - min and a max)...?