Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Charting 'stripes' of data from within a table?
Hi all,
I have data that looks like this: 1/1/2008 Red 3.325 5.668 5.461 5.598 5.608 5.598 5.688 1/1/2008 Yellow 12.658 14.09 13.413 13.129 14.09 13.65 13.303 1/1/2008 Blue 7.07 6.963 6.84 6.92 6.86 7.01 6.94 1/8/2008 Red 3.935 3.785 3.685 3.665 3.765 3.635 3.715 1/8/2008 Yellow 8.502 8.802 8.793 8.632 8.456 8.573 8.593 1/8/2008 Blue 4.777 4.626 5.278 4.557 4.757 4.706 4.597 1/15/2008 Red 3.445 3.295 5.518 5.448 5.548 5.588 3.415 1/15/2008 Yellow 13.129 12.999 13.052 8.212 8.252 8.242 8.272 1/15/2008 Blue 4.317 6.89 7.084 7.331 4.497 4.206 7.13 And I want to turn it into charts like this: Title: Red X-axis: Date Y-Axis: Lines for 10th, 50th & 90th percentiles ....with a 2nd and 3rd chart for Yellow and Blue. I know how to get the percentiles, but can't find a way to pull out just the Red rows for one chart, and just the Blue for another. How would you go about this? Thanks in advance! Jeff Fry |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Charting 'stripes' of data from within a table?
Sort by the second column, to group data by color.
- Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Jeff Fry" wrote in message ... Hi all, I have data that looks like this: 1/1/2008 Red 3.325 5.668 5.461 5.598 5.608 5.598 5.688 1/1/2008 Yellow 12.658 14.09 13.413 13.129 14.09 13.65 13.303 1/1/2008 Blue 7.07 6.963 6.84 6.92 6.86 7.01 6.94 1/8/2008 Red 3.935 3.785 3.685 3.665 3.765 3.635 3.715 1/8/2008 Yellow 8.502 8.802 8.793 8.632 8.456 8.573 8.593 1/8/2008 Blue 4.777 4.626 5.278 4.557 4.757 4.706 4.597 1/15/2008 Red 3.445 3.295 5.518 5.448 5.548 5.588 3.415 1/15/2008 Yellow 13.129 12.999 13.052 8.212 8.252 8.242 8.272 1/15/2008 Blue 4.317 6.89 7.084 7.331 4.497 4.206 7.13 And I want to turn it into charts like this: Title: Red X-axis: Date Y-Axis: Lines for 10th, 50th & 90th percentiles ...with a 2nd and 3rd chart for Yellow and Blue. I know how to get the percentiles, but can't find a way to pull out just the Red rows for one chart, and just the Blue for another. How would you go about this? Thanks in advance! Jeff Fry |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
showing the totals in a chart/table without charting them | Excel Worksheet Functions | |||
Including data in data table but not charting as a series or point | Charts and Charting in Excel | |||
Coloured horizontal stripes | Charts and Charting in Excel | |||
tip of the day should be relevant, not vacuous: stripes & plaids? | Excel Discussion (Misc queries) | |||
Problem with series when charting from a pivot table | Charts and Charting in Excel |