X Y Plots by point

rcpatterson · #1 05-28-2005, 10:23 PM

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

#2 05-29-2005, 01:05 PM

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
>
>

rcpatterson · #3 05-29-2005, 04:39 PM

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

rcpatterson

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)