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??

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Lars B" <Lars wrote in message
...
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??

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:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Lars B" <Lars wrote in message
...
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??

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Lars B" wrote in message
...
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:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Lars B" <Lars wrote in message
...
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??

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Lars B" wrote in message
...
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:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Lars B" <Lars wrote in message
...
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??

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



"Jon Peltier" wrote:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Lars B" wrote in message
...
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:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Lars B" <Lars wrote in message
...
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??

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

"Bedullah" wrote:

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



"Jon Peltier" wrote:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Lars B" wrote in message
...
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:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Lars B" <Lars wrote in message
...
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??

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.

"Bedullah" wrote:

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



"Jon Peltier" wrote:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Lars B" wrote in message
...
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:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Lars B" <Lars wrote in message
...
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??