ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   error bars (https://www.excelbanter.com/charts-charting-excel/159395-error-bars.html)

W Chamberlain

error bars
 
I am generating a 3d bar graph in excel 2007 comparing two series and I want
to insert error bars. I go to "current selection" in the tool bar under the
"Format" tab after selecting my graph, select my series, then go to the
Layout tab to set error bars. The "analyis" box is is not active. I see it
but none of the options, including "error bars" will allow me to do
anything. Is there something wrong with the way I set up my chart? or
formatted my data. Why can't I generate error bars?

Andy Pope

error bars
 
Hi,

Error bars are not, and never have been, supported in 3d charts.
Use 2d chart style.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"W Chamberlain" <W wrote in message
...
I am generating a 3d bar graph in excel 2007 comparing two series and I
want
to insert error bars. I go to "current selection" in the tool bar under
the
"Format" tab after selecting my graph, select my series, then go to the
Layout tab to set error bars. The "analyis" box is is not active. I see
it
but none of the options, including "error bars" will allow me to do
anything. Is there something wrong with the way I set up my chart? or
formatted my data. Why can't I generate error bars?




All times are GMT +1. The time now is 12:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com