View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Fred Zack Fred Zack is offline
external usenet poster
 
Posts: 11
Default Data Lables, series and Scatterplots

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?