Is there any way to get excel scatterplots to recognize a third column (or
row) as a series for a scatterplot? FOr example I have data as:
Sequence Long Lat
1 49.12 28.05
2 49.17 28.34
3 49.5 28.48
4 49.17 28.36

I would like to plot Long(itude) as X axis and Lat(itude) as Y on
scatterplot (which I can do). But I would also like to identify the sequence
number fopr each point. I thought I could do that by getting the Sequence
numbers to represent a series, but can't sseem to get that in a scatterplot.

Is there any other chart besides scatterplot that may be better?

Use something like Rob Bovey's XY Chartlabeler (www.appspro.com)
or John Walkenbach's Chart Tools (www.j-walk.com).
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Fred Zack" wrote in message
...
Is there any way to get excel scatterplots to recognize a third column (or
row) as a series for a scatterplot? FOr example I have data as:
Sequence Long Lat
1 49.12 28.05
2 49.17 28.34
3 49.5 28.48
4 49.17 28.36

I would like to plot Long(itude) as X axis and Lat(itude) as Y on
scatterplot (which I can do). But I would also like to identify the
sequence
number fopr each point. I thought I could do that by getting the Sequence
numbers to represent a series, but can't sseem to get that in a
scatterplot.

Is there any other chart besides scatterplot that may be better?

"Bernard Liengme" wrote:

Use something like Rob Bovey's XY Chartlabeler (www.appspro.com)
or John Walkenbach's Chart Tools (www.j-walk.com).
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Fred Zack" wrote in message
...
Is there any way to get excel scatterplots to recognize a third column (or
row) as a series for a scatterplot? FOr example I have data as:
Sequence Long Lat
1 49.12 28.05
2 49.17 28.34
3 49.5 28.48
4 49.17 28.36

I would like to plot Long(itude) as X axis and Lat(itude) as Y on
scatterplot (which I can do). But I would also like to identify the
sequence
number fopr each point. I thought I could do that by getting the Sequence
numbers to represent a series, but can't sseem to get that in a
scatterplot.

Is there any other chart besides scatterplot that may be better?


Thanks, I used appspro and that worked fine. May check out other one next.