| Register | FAQ | Calendar | Search | Today's Posts | Mark Forums Read |
|
#1
|
| 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 |
![]() |
| Thread Tools | |
| Display Modes | |