I know this is probably something very easy to do but I cannot figure
out how to do it in Excel. All I want to do is have Excel plot a
series of points on an x, y graph using one axis. I know how to do it
on two. For example I have the following coordinates (1, 5), (6,10),
(8,100). I want Excel to simple plot these points on a graph with x
from 0 to 100 and y from 0 to 100. How do I tell it to give the right
coordinate system and how do I tell it to plot these points on that
coordinate system?

Thanks for the help in advance.

rcpatterson


--
rcpatterson
------------------------------------------------------------------------
rcpatterson's Profile: http://www.excelforum.com/member.php...o&userid=23832
View this thread: http://www.excelforum.com/showthread...hreadid=374861

I think you do want to use two axes, an X and a Y.

Start with the data. This is an appropriate arrangement in two worksheet
columns:

X Y
1 5
6 10
8 100

Select the data, run the Chart Wizard, choose an XY Scatter chart in
step 1, and OK your way through the rest of the Wizard. Double click on
the X axis, and on the Scale tab, enter 0 for min and 100 for max.
Select the Y axis and press the shortcut F4 function key to repeat this,
or repeat it manually.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


rcpatterson wrote:

I know this is probably something very easy to do but I cannot figure
out how to do it in Excel. All I want to do is have Excel plot a
series of points on an x, y graph using one axis. I know how to do it
on two. For example I have the following coordinates (1, 5), (6,10),
(8,100). I want Excel to simple plot these points on a graph with x
from 0 to 100 and y from 0 to 100. How do I tell it to give the right
coordinate system and how do I tell it to plot these points on that
coordinate system?

Thanks for the help in advance.

rcpatterson

Thanks, Jon, it worked. I appreciate the help. Have a good weekend.

rcpatterson


--
rcpatterson
------------------------------------------------------------------------
rcpatterson's Profile: http://www.excelforum.com/member.php...o&userid=23832
View this thread: http://www.excelforum.com/showthread...hreadid=374861