How to create a scatters chart
 

How to create a scatters chart? It is simple with 2 coluums as below. I
tried the wizard but I don't have the x axis with name such as ew, re
ytr....Need your help. Daniel

name value
ew 32
re 43
ytr 23
tre 25
hf 54
gd 52
ht 43
gfd 12
jk 43

How to create a scatters chart
 

Daniel wrote on Thu, 28 Jun 2007 14:32:03 -0700:


D How to create a scatters chart? It is simple with 2 coluums
D as below. I tried the wizard but I don't have the x axis
D with name such as ew, re ytr....Need your help. Daniel

D name value
D ew 32
D re 43
D ytr 23
D tre 25
D hf 54
D gd 52
D ht 43
D gfd 12
D jk 43

Unless you have numerical values in both columns you can't
create a real graph (scatter chart). Presumably a line graph
would work.


James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.verizon.not

How to create a scatters chart
 

An XY (scatter) chart required numerical data for both X and Y. Absent this,
Excel uses the counting numbers 1, 2, 3, etc. as the X values.

If the text labels are to be treated as non-numeric labels, create a Line
chart, then format the series to remove the lines between the markers.

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


"Daniel" wrote in message
...

How to create a scatters chart? It is simple with 2 coluums as below. I
tried the wizard but I don't have the x axis with name such as ew, re
ytr....Need your help. Daniel

name value
ew 32
re 43
ytr 23
tre 25
hf 54
gd 52
ht 43
gfd 12
jk 43