Custom Error Bar

Question

How can I create a custom error bar so that I can enter in standard deviation data?

Answer 1

Dear J. Hipp,

Good day! Thank you for posting to Microsoft Community. We are happy to help you.

As per your description, please don’t worry, we can work together to narrow down and resolve the situation.

 Select the data series>On the Chart Design tab of the Ribbon click the Add Chart Element Button>under Choose Error Bars >click More Error Bars Options>under Format Error Bars pane, click Custom, and then click Specify Value and type custom value in a Positive/ Negative Error **** Value boxes.

Your understanding and patience will be highly appreciated. I hope that you are keeping safe and well!

Sincerely, 

Waqas Muhammad

Answer 2

Hi

Here's more information about Standard Deviation and Error Bars:

https://support.office.com/en-us/f1/topic/e6d12c87-8533-4cd6-a3f5-864049a145f0?showContactUsNav=False&ns=MACEXCEL&version=90&ThemeId=0&IsSasFeedbackEnabled=True

Please pay special attention to which kinds of charts can have error bars with standard deviation.

Answer 3

Hi J. Hipp,

I'm writing a follow up this case, may I know have you checked above reply? Feel free to post back if you need further assistance. I will try my best to help you.

Sincerely, 

Waqas Muhammad