|
Posted to microsoft.public.excel.charting
|
|
|
Data Lables, series and Scatterplots
"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.
|