Charting 'stripes' of data from within a table?

  • Thread starter Thread starter Jeff Fry
  • Start date Start date
J

Jeff Fry

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
 
Back
Top