Shopping Podder - the Best of Computer Postings! :: View topic - Charting multi-dimensional data

jfry · Guest

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 (using Excel) 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.

Can any of you suggest a way to do this?

Thanks in advance!
Jeff Fry


www.ShoppingPodder.com Leading Computer Shopping, News and information	Part of the Identityscape.com network... getxfactor.com jmoodmusic.com smartbusinesschoices.com mintdepot.com lowfaresalways.com evangelicalview.com shoppingpodder.com soproudlywehail.com webnews.ws currenthumor.com

Shopping Podder - the Best of Computer Postings! Forum Index -> Computer Applications - Spreadsheets
Page 1 of 1