Adjust scale on y-axis (scatter point)

juster21

Well-known Member
Joined
Jun 3, 2005
Messages
867
I have a scatter point chart with a maximum of 40 but I want it to be 35. Can't seem to get it to change. Any ideas?
 

Some videos you may like

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

Sharkie21

Active Member
Joined
Nov 2, 2005
Messages
319
On your chart can't you click on the y-axis then format axis. Uncheck auto and set the max scale you want it to be (35).
 

juster21

Well-known Member
Joined
Jun 3, 2005
Messages
867
Thanks.

Is there a way to put a median line on the chart as well. I want to see the median so then I can look at who is meeting a requirement and who isn't. Thanks again!
 

Watch MrExcel Video

Forum statistics

Threads
1,118,032
Messages
5,569,764
Members
412,291
Latest member
marypolitan
Top