Colour coding scatter points from third column

T

Turnipboy

I have data of frequencies and amplitudes in corresponding coloumns.
want to plot frequency vs amplitude which is straightforward. Howeve
there is a third column that indicates which gauge took the reading. A
there is an issue with malfunctioning gauges I would like my scatte
graph of frequency vs amplitude to be colour coded accorded to whic
gauge took the reading (e.g guage 1 points are red, gauge 2 are gree
etc). How can I do this most easily, there is a lot of data and quite
few gauges
 
J

JE McGimpsey

I would think the easiest way to do it would be to do a scatter plot of
each gauge's readings in a separate column, e.g.,

A B C D E F
1 Point Freq Amp Gauge Gauge 1 Gauge 2 ...
2 1 x y 1

where

E2: =IF($D2=1, $C2,NA())
F2: =IF($D2=2, $C2,NA())

etc.

then plot column B against E:z
 
T

Turnipboy

Thanks, that is what I have beeen trying. There is an added
complication. Once the graph is plotted I need to delete certain lines
on the table (because the data looks wrong) and also reorder the table
at times so it is in ascending order of frequency, or amplitude, or
gauge number - I do not want the reordering to affect the table,
however when I delete a line on the table it shoulbd be reflected in
the graph. When I try doing this I get errors when I delete a lot of
rows in the table and also when I reorder the table, say from ascending
gauge number to ascending frequency it messes the colours up on the
graph. I have tried taking the $ signs out in in the source data line
but they just seem to reappear - not sure if that would work anyway.
 
J

JE McGimpsey

Deleting rows or sorting shouldn't affect an XY scatter plot (except to
delete the points in the rows that were deleted). Nor should it affect
the series colors.

What errors are you getting?
 
Top