How to do error bars Excel for Mac 2016

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

Question Info


Last updated October 15, 2018 Views 14,176 Applies to:
Once you a chart inserted. In the Chart Design tab click on Add Chart Element. You can find Error Bars here.

46 people were helped by this reply

·

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.

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?

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.

Finally found it! Thanks so much!

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.

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?

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.

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

I am an unpaid volunteer and do not work for Microsoft. "Independent Advisors" work for contractors hired by Microsoft. "Microsoft Agents" work for Microsoft Support.

4 people were helped by this reply

·

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.