Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Needed: Chart that combines clustered column and stacked column types | Charts and Charting in Excel | |||
Stacked Column Chart / Normal Column Chart | Charts and Charting in Excel | |||
How can I add a line chart in a stacked column chart style? | Excel Discussion (Misc queries) | |||
How do I sum a column dependent on another columns text value? | Excel Worksheet Functions | |||
How do I change column into lines on a Line-Column chart? | Charts and Charting in Excel |