Charting multi-dimensional data

This is a discussion on Charting multi-dimensional data within the Spreadsheets forums in Other Technologies category; 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/...

Go Back   Database Forum > Other Technologies > Spreadsheets

Database Forums

Register FAQ Calendar Search Today's Posts Mark Forums Read
  #1  
Old 02-19-2008, 08:06 PM
Default Charting multi-dimensional data

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

Reply With Quote
Reply


Thread Tools
Display Modes



All times are GMT -4. The time now is 04:34 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Integrated by bbpixel2008 :: jvbPlugin R1013.368.1

Search Engine Friendly URLs by vBSEO 3.1.0
vB Ad Management by =RedTyger=
In an effort to better serve ads to our visitors, cookies are used on Mydatabasesupport.com. For more information, check out our Privacy Policy.