Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I make multiple pie charts at the same time? | Charts and Charting in Excel | |||
How can you add the same data series to all charts in a workbook | Charts and Charting in Excel | |||
Chart -- Source Data... -- Series dialog window | Charts and Charting in Excel | |||
Disappearing scales on bar charts with multiple series | Charts and Charting in Excel | |||
How do I change a data series from bars to lines in an Excel char. | Charts and Charting in Excel |