Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
graphing data of different frequencies | Charts and Charting in Excel | |||
Plot order of lines and points in XY scatterplots | Charts and Charting in Excel |