LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default 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!

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Needed: Chart that combines clustered column and stacked column types Gerry Charts and Charting in Excel 3 February 14th 07 02:53 AM
Stacked Column Chart / Normal Column Chart Rowan Drummond Charts and Charting in Excel 1 August 8th 06 04:56 AM
How can I add a line chart in a stacked column chart style? Guilherme Loretti Excel Discussion (Misc queries) 0 August 3rd 06 01:46 AM
How do I sum a column dependent on another columns text value? dj479794 Excel Worksheet Functions 1 March 15th 06 06:59 PM
How do I change column into lines on a Line-Column chart? Ken Charts and Charting in Excel 1 March 17th 05 02:29 PM


All times are GMT +1. The time now is 10:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"