how to make the axis of charts to start at my lowest value(data)?

[Guest]

actually, i am making a chart with values starting at 40 to 85.

when i plot the chart, it is located somewhere in the middle upto the end
because excel tries to plot 0 to 40 on my x axis which i do not want.

what i want is that the x-axis of my chart should start at 40 then probably
by interval of five upto 85. also my y-axis to start at 140 upto ~180.

here is my data.
x y
72 160
54 149
78 152
84 171
62 153
57 158
49 142
68 164
75 166
56 150
60 160
50 141
80 166
45 136
52 129
55 159

pls help. thanks.

 

[Guest]

Hi,

Rightclick on the X-axis --> "Format Axis" --> click on the "Scale" Tab -->
set "Minimum" to 40 --> "Maximum" to 85 --> "Major Unit" to 5 --> "OK"
Follow a similar procedure to format the Y-axis.

Regards,
B. R. Ramachandran

 

[Guest]

wow thank u sir. just what i need.. ^_^

Hi,

Rightclick on the X-axis --> "Format Axis" --> click on the "Scale" Tab -->
set "Minimum" to 40 --> "Maximum" to 85 --> "Major Unit" to 5 --> "OK"
Follow a similar procedure to format the Y-axis.

Regards,
B. R. Ramachandran