Adding Error Bars Excel 2007

[Lars B]

I have not been able to trace how to add error bars in a column graph (2D) in
Excel 2007. Error bars appear and can be edited if a graph made in Excel 2003
is opened in Excel 2007 - but how can you make new graphs with error bars??

 

[Jon Peltier]

Select the series, choose the Chart Tools > Layout tab, and in the Analysis
group, click on Error Bars.

- Jon

 

[Lars B]

Many thanks, Jon,
And when that was solved a new, but related problem appeared: consistently
when I try to assign a value to the error bar by clicking on a specific cell
Excel closes down due to a serious problem, and then restarts (error message
sent to Microsoft).
I use XP and Office/Excel 2007, Swedish versions.

"Jon Peltier" skrev:

 

[Jon Peltier]

I haven't encountered this problem. Hopefully they will read the error
message.

- Jon

 

[Jon Peltier]

Is it just your computer, or also other computers you've tried?

- Jon

 

[Bedullah]

Hi,

I have encountered this problem with all computers that I have tried that
have excel 2007 installed.

It occurs when you use cells located in another worksheet than the graph.
This never works and allways results to serious error. This is a very serious
bug and it is amazing that it still hasn't been repaired!

Br,
Bedullah

 

[Christina Cooper]

Thank you for your response, Bedullah. It is very frustrating that the values
must be in the same page. I hope that this bug is fixed very soon.

-Christina

 

[Tim M]

Thank you for your response, Bedullah. It is very frustrating that the values
must be in the same page. I hope that this bug is fixed very soon.

-Christina

 

[Hildur]

I completely agree - we're now in 2009 and it's still not working. Goes to
show that excel is not designed for the scientific community at all, even
though it is widely used there.

However, there is a way around it - you simply write up the reference
yourself under "custom error bars," using the format

=sheet1!$A$1:$A$10 [substitute as needed]

for both + and -

This is a rather bothersom way to do it though, and I wish it could be fixed.