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!

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 [email protected]> wrote in message
news:[email protected]...
>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!
>