making a complicated bar graph

[Guest]

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]

Hi,

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

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

Cheers
Andy