Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide Graph of Data Outside X-Axis Range | Charts and Charting in Excel | |||
y-axis auto range based on data limits | Charts and Charting in Excel | |||
Graph with large data range (hash marks on axis) | Excel Discussion (Misc queries) | |||
Minimize range on vertical axis with large data gaps | Charts and Charting in Excel | |||
Newbie Questions - X Axis and Data Range | Charts and Charting in Excel |