Chart dependent on column

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!
 
D

Del Cotter

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top