Chart dependent on column
 

I need to make a series of charts that depend on a column in my
datasheet. What I mean is this - I have data laid out per below, that
is logged by operators throughout the day:

Date Time Color Reading

What I want to do is to display a separate line chart for each color.
Each point is the date/time on the X axis and the Reading on the Y-
axis. My difficulty is that different colors are mixed all together
in the data, for example:
Date Time Color Reading
6/21 11:00 Blue 5.2
6/21 11:05 Yellow 3.1
6/22 8:19 Green 6.8
6/22 9:44 Yellow 3.8
6/22 10:52 Blue 10.1

How do I make a chart for "Blue" and a separate chart showing "Red"
without physically separating the data?

Thanks!

Chart dependent on column
 

On Fri, 22 Jun 2007, in microsoft.public.excel.charting,
Blaine said:
Date Time Color Reading
6/21 11:00 Blue 5.2
6/21 11:05 Yellow 3.1
6/22 8:19 Green 6.8
6/22 9:44 Yellow 3.8
6/22 10:52 Blue 10.1

How do I make a chart for "Blue" and a separate chart showing "Red"
without physically separating the data?

Why not make a Pivot Table or Pivot Chart using this information?

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.