Need to Make A Chart

  • Thread starter Thread starter NorthStar
  • Start date Start date
N

NorthStar

I need to make a chart in Excel that plots two numbers onto a graph. The X
and Y zero points will intersect in the middle and all points on the graph
will be plotted either to the left/right and up/down of the center point.

Example:
X Value: -4.0
Y Value: 2.5

The point will be plotted 4 ticks to the left and 2.5 ticks above the zero
intersection point.

How do I do this?

--
NorthStar

Always do right. This will gratify some people and astonish the rest.

Spam protected -- Remove _NadaSpam_ to e-mail
 
Hi,
In A1 type X; in B1 type Y
Let's say you have 6 points; enter them in A2:B7 (one pair to a row)
Select A1:B7, click on the Chart Wizard in the Toolbar
Select a XY (Scatter) chart
Work thru the 3 steps.
If the result is more or less what you want; get an intro Excel book and
learn how to format the chart to make it 'prettier'
Bernard
 
Put your X values in a column, and your Y values in the next column to
the right. Select the range of data and start the chart wizard. Choose
an XY Scatter type in step 1, make sure step 2 uses Series in Columns,
and go through the rest of the chart wizard. To format a part of the
chart, try double clicking or right clicking on it.

- Jon
 
I get two points for each person instead of the single point for each
person. How do I get Excel to recognize that each pair of numbers
constitutes the chart address for a single point?

--
NorthStar

Always do right. This will gratify some people and astonish the rest.

Spam protected -- Remove _NadaSpam_ to e-mail
 
I get two points for each person instead of the single point for each
person. How do I get Excel to recognize that each pair of numbers
constitutes the chart address for a single point?
Click to expand...

Each row in the data set is treated as an individual pair, assuming you
use an XY scatter chart (*not* a line chart). You need to do nothing
special.
 
Oops! I'm sorry about the size of the JPG... I didn't realize it came out
as large as it did. My apologies to the group.

--
NorthStar

Always do right. This will gratify some people and astonish the rest.

Spam protected -- Remove _NadaSpam_ to e-mail

NorthStar said:
I'm just not getting it. After trying to stubborn my way thru this, it's
still not giving me what I want. I've attached a picture of what I'm trying
to get Excel to do.


Horizontal Vertical
^DL^ -2.38 -3.64
3rdUp 1.50 3.23
NorthStar -4.50 0.56


As you can see from looking at the graphic, DL's point would be 2.38 left
and 3.64 down from the intersection of the zero lines. 3rdUp is 1.50 up and
3.23 right of zero, and I'm 4.50 left and .56 up.

Is this type of chart beyond Excel's capabilities, or am I just not
understanding a fairly simple subject (and trust me, it wouldn't be the
first time I was outsmarted by the computer <g>).

--
NorthStar

Always do right. This will gratify some people and astonish the rest.

Spam protected -- Remove _NadaSpam_ to e-mail
Click to expand...
 
So arrange your data like this:

X Y
^DL^ -2.38 -3.64
3rdUp 1.50 3.23
NorthStar -4.50 0.56

Select the two column wide, four row high range that contains the X and
Y values and the header row. Run the chart wizard and create an XY
Scatter chart. Not a Line chart.

You can double click on an axis to adjust the scale parameters (min,
max, etc), and you can right click on the chart and choose Chart Options
to add vertical gridlines to go with the default horizontal ones.

To use the labels in the first column as labels on the data points,
download Rob Bovey's Chart Labeler (free at http://appspro.com), install
it, and use the Chart Labels command that's added to the bottom of the
Tools menu.

- Jon
 
Back
Top