software

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

--

Andy Pope, Microsoft MVP - Excel
www.andypope.info