Q: 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.

Question Info

Views: 10,176 Last updated: July 3, 2018 Applies to: