making a complicated bar graph

i'm using excel 2003.
1a) let's say I have 2 categories: company A and company B; I want them on
the x axis. Within each category, I have 2 measures: let's say mean employee
weight and mean employee height; I want them on the y axis. But when I add a
secondary y-axis for mean height, weight and height are no longer separate
bars but become stacked. How do I get around this?

1b) let's say I want to add error bars (the standard error) to mean height
and mean weight. company A's standard error is different from company B's.
How do I tell Excel what the standard errors are and then how do I add them
as error bars?

Hi,

The trick to this is data layout.
Check Jon's page for links to various explanations.
http://peltiertech.com/Excel/ChartsH...sterStack.html

For the error bar problem you could use the Custom +/- values on the
error bar dialog.

Cheers
Andy

harrygorilla wrote:
> i'm using excel 2003.
> 1a) let's say I have 2 categories: company A and company B; I want them on
> the x axis. Within each category, I have 2 measures: let's say mean employee
> weight and mean employee height; I want them on the y axis. But when I add a
> secondary y-axis for mean height, weight and height are no longer separate
> bars but become stacked. How do I get around this?
>
> 1b) let's say I want to add error bars (the standard error) to mean height
> and mean weight. company A's standard error is different from company B's.
> How do I tell Excel what the standard errors are and then how do I add them
> as error bars?

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info