How to create a scatters chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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