How to do error bars Excel for Mac 2016

Question

I havent been able to find any way of adding Error bars with excel fro mac. Anyone know how I can fix this?

Answer 1

Once you a chart inserted. In the Chart Design tab click on Add Chart Element. You can find Error Bars here.

Answer 2

I can add chart elements on the windows version but there doesnt seem to be the option to do this in the mac version. For me at least. Is it in a different area?

Answer 3

Finally found it! Thanks so much!

Answer 4

I havent been able to find any way of adding Error bars with excel fro mac. Anyone know how I can fix this?

Wrong values are attached! How to select error bar values?

Answer 5

1. Select the data series
2. On the Chart Design tab of the Ribbon click the Add Chart Element Button
3. Choose Error Bars > and then choose the type of error bar you want

For details on the various error chart options see this:

https://support.office.com/en-us/article/Add-error-bars-or-up-down-bars-to-a-chart-93452C4A-442E-4EE6-B4EC-FF32BFCA8D7F