Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

Souljas

macrumors regular
Original poster
Feb 4, 2004
127
0
Hello, could someone help me with this relatively easy MS excel question...

I am plotting a bar chart of heart rate but the heart rates in my chart only go from 60 to 140, but excel puts the Y-values from 0-150. Is there a way to make it instead start at 55 and go to 150?

Thanks
SouL
 
Hello, could someone help me with this relatively easy MS excel question...

I am plotting a bar chart of heart rate but the heart rates in my chart only go from 60 to 140, but excel puts the Y-values from 0-150. Is there a way to make it instead start at 55 and go to 150?

Thanks
SouL

Double click on the y-axis and you should see a dialog where you can change the min and max values.
 
Slightly different for different versions

Right-click on the y-axis choose format axis and then look for scale, then you can set the minimum.
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.