Error bars

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Caitlin - 30 Aug 2004 12:41 GMT

Hi,

In a clustered column chart, how do you apply a different error bar for the
standard deviation of each data set? At the moment I can only apply an error
bar of the same value to each set of data.

Thank you

Reply to this Message

Andy Pope - 30 Aug 2004 12:56 GMT

Hi Caitlin,

On the error bar dialog is a section to specify the error amount.
Here you can specify Custom +/- values inorder to enter an array or link
to cells.

Cheers
Andy

> Hi,
>
[quoted text clipped - 3 lines]
>
> Thank you

Signature

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

Reply to this Message

Caitlin - 31 Aug 2004 08:03 GMT

Thank you :)

> Hi Caitlin,
>
[quoted text clipped - 12 lines]
> >
> > Thank you

Reply to this Message