R
re
My data is in the arnge of 150-250. How do I start my chart at 150, instead
of zero? I'm cahrting data values against dates(months).
of zero? I'm cahrting data values against dates(months).
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Max
Right-click on the vertical axis > Format axis > Scale tab
Uncheck the Auto-Min box, key in your start value > OK
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik
Uncheck the Auto-Min box, key in your start value > OK
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik
M
Meebers
From within the chart use the "scale" option. set minimum to 150?? or what
ever you want instead of auto.
ever you want instead of auto.
P
Paul Wilson
Hi,
If you have let Excel do most of the work in setting up the chart, then hold
the mouse pointer over the axis you want to change and right-click. Choose
the option Format Axis. In the dialog box which appears select the second
page headed Scale. First remove the ticks in the auto boxes particularly
for Minimum and Maximum values. Put in the max and min values you want and
click ok. Play around with the other values if you wish too.
Regards
Paul
If you have let Excel do most of the work in setting up the chart, then hold
the mouse pointer over the axis you want to change and right-click. Choose
the option Format Axis. In the dialog box which appears select the second
page headed Scale. First remove the ticks in the auto boxes particularly
for Minimum and Maximum values. Put in the max and min values you want and
click ok. Play around with the other values if you wish too.
Regards
Paul
R
Ron Rosenfeld
My data is in the arnge of 150-250. How do I start my chart at 150, instead
of zero? I'm cahrting data values against dates(months).
Right-click the axis; select Format Axis; then set your minimum amount manually
instead of "automatic".
--ron