axis data range

[JanAdam]

How to specify the range of y-axis in xy plot in Excel 2003? I need to plot
three functions, say y1(x), y2(x) and y3=y1-y2.
y1 and y2 have large values for small x, but the difference is relatively
small. for larger x, all three function converge to zero. I would like to
display y values from, say, -10 to +10, although some values for y1 and y2
are outside this range. How can I specify maximum and minimum y (and/or x)
values to be displayed?
I have tried all key words I could think of in searching the knowledge base
and this community without finding the answer. It is likely I simply do not
know the right key word for it.

 

[Mike Middleton]

JanAdam -

Excel plots values in worksheet cells. For an XY(Scatter) chart type,
arrange X values in a column on the left and corresponding Y values in an
adjacent column on the right. Select the data, and create the chart (Insert
Chart, or the Chart Wizard icon).

To format an axis max and min, select the axis (a single click in that part
of the chart), and choose Format Selected Axis. On the Scale tab, uncheck
Auto and specify max and min values, and click OK.

- Mike

http://www.MikeMiddleton.com

 

[JanAdam]

Thank you Mike,

It is exactly what I was after and it solves the problem. Many thanks,