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

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