Y-Bars for Columns in a series

#1 03-11-2005, 10:06 AM

I have a chart (Column graph) that displays 4 means, 2 means (y-values) in
each of two series. I want to display a separate y-bar for each mean (with
1.96 times the standard error of the mean for each group in the series), but
Excel seems to designate a y-bar for the entire series only. When I set the
value for the y-bar. Is there any way to keep the chart displaying two series
with two means each and have y-bars that pull values separately for each bar?

I tried creating 4 separate series, but I lose the chance to label the two
groups on the x-axis.
Any ideas?

#2 03-12-2005, 01:06 AM

Dan -

You can put the values for the error bars in the sheet. In the error bar dialog,
click in the Custom + box, and select the range with custom values, then click in
the Custom - box and again select the range (you can actually specify different
values for + and - if desired).

Scroll about halfway down on this page to see it in action:

http://peltiertech.com/Excel/ChartsHowTo/ErrorBars.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

CajunDan wrote:

> I have a chart (Column graph) that displays 4 means, 2 means (y-values) in
> each of two series. I want to display a separate y-bar for each mean (with
> 1.96 times the standard error of the mean for each group in the series), but
> Excel seems to designate a y-bar for the entire series only. When I set the
> value for the y-bar. Is there any way to keep the chart displaying two series
> with two means each and have y-bars that pull values separately for each bar?
>
> I tried creating 4 separate series, but I lose the chance to label the two
> groups on the x-axis.
> Any ideas?

#3 03-12-2005, 11:06 PM

Jon,
How simple and elegant. I will use this feature from now on. Y-bars are
critical in my area of research. I appreciate the help.
Dan-

"Jon Peltier" wrote:

> Dan -
>
> You can put the values for the error bars in the sheet. In the error bar dialog,
> click in the Custom + box, and select the range with custom values, then click in
> the Custom - box and again select the range (you can actually specify different
> values for + and - if desired).
>
> Scroll about halfway down on this page to see it in action:
>
> http://peltiertech.com/Excel/ChartsHowTo/ErrorBars.html
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Peltier Technical Services
> Tutorials and Custom Solutions
> http://PeltierTech.com/
> _______
>
> CajunDan wrote:
>
> > I have a chart (Column graph) that displays 4 means, 2 means (y-values) in
> > each of two series. I want to display a separate y-bar for each mean (with
> > 1.96 times the standard error of the mean for each group in the series), but
> > Excel seems to designate a y-bar for the entire series only. When I set the
> > value for the y-bar. Is there any way to keep the chart displaying two series
> > with two means each and have y-bars that pull values separately for each bar?
> >
> > I tried creating 4 separate series, but I lose the chance to label the two
> > groups on the x-axis.
> > Any ideas?
>
>

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)