If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
axis data range
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. -- JanAdam |
#2
|
|||
|
|||
axis data range
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" wrote in message ... 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. -- JanAdam |
#3
|
|||
|
|||
axis data range
Thank you Mike,
It is exactly what I was after and it solves the problem. Many thanks, -- JanAdam "Mike Middleton" wrote: 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" wrote in message ... 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. -- JanAdam |
Thread Tools | |
Display Modes | |
|
|