If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
XY Scatter Charts, High/Low bars, Multiple Series
I am trying to chart the changes in a percentile distribution over a number
of years. There are five percentile ranges (99-90%,89-75%, etc.) which have a maximum and minimum value. For analysis it would be helpful to examine these ranges side by side. A chart similar to a stock chart would be able to show the "High and Low" of each range, but this is only good for one data set (in my case years), not 5 to 8 years, which is what I need. So we are probably looking at an XY scatter chart with some high/low (error) bars. Also, on an XY scatter, when just plotting the data, the points stack one on top of the other (because they technically have the same x value). Is there any way to stagger them horizontally so if I could add error bars that they wouldn't overlap each other? ANY help on this is apprecieated! |
#2
|
|||
|
|||
XY Scatter Charts, High/Low bars, Multiple Series
I think it might be better to use a stacked column chart, in a similar
manner to a box and whiskers chart: http://peltiertech.com/Excel/Charts/BoxWhiskerV.html Forget the whiskers and create the value ranges you need for your percentile ranges. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Kevin M." Kevin wrote in message ... I am trying to chart the changes in a percentile distribution over a number of years. There are five percentile ranges (99-90%,89-75%, etc.) which have a maximum and minimum value. For analysis it would be helpful to examine these ranges side by side. A chart similar to a stock chart would be able to show the "High and Low" of each range, but this is only good for one data set (in my case years), not 5 to 8 years, which is what I need. So we are probably looking at an XY scatter chart with some high/low (error) bars. Also, on an XY scatter, when just plotting the data, the points stack one on top of the other (because they technically have the same x value). Is there any way to stagger them horizontally so if I could add error bars that they wouldn't overlap each other? ANY help on this is apprecieated! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Odd behavior in reports with multiple charts | Tom | Setting Up & Running Reports | 0 | January 16th, 2005 02:55 AM |
Ineffective change of plot order in series formula | Jon Peltier | Charts and Charting | 3 | May 30th, 2004 02:15 AM |
Chart With One Series Bars and Two Series of Lines | Brian | Charts and Charting | 1 | January 30th, 2004 07:24 PM |
Multiple series with different x-values on one scatter plot | NKelly | Charts and Charting | 4 | October 2nd, 2003 05:31 PM |
Multiple Series Pie Charts | Chad BATES | Charts and Charting | 1 | September 30th, 2003 05:34 PM |