Chart dependent on column

  • Thread starter Thread starter Blaine
  • Start date Start date
B

Blaine

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!
 
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?
Click to expand...

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