Custom error bar in excel 2008

How do you create custom error bars in Excel 2008?  I can right click on the data series, format data series and see y error bars, but the only options present are for a fixed value or a fixed percentage.  This is no good for scientific purposes and I need to illustrate standard deviation values that are unique to each data point in a particular series of data.


Ask your student if they've updated their Office 2008 applications to the latest version.

Both Excel 2008 and Excel 2011 operate exactly the way I described above, i.e., they HAVE the Standard Deviation, Standard Error and Custom options.

There are many reasons not to upgrade to Office 2008 (i.e., skip right to Office 2011), but custom error bars isn't one of them...

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.


Question Info

Last updated March 24, 2020 Views 10,276 Applies to: