X Y Plots by point

R

rcpatterson

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
 
J

Jon Peltier

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/
_______
 
R

rcpatterson

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

rcpatterson
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top