Error Bars changes my scatter graph

Question

I'm trying to add custom error bars in excel but it messes up the graph significantly from the first one to the second one. The uncertanity values were 0.3, 0.225, 0.1, 0.075, 0.03.

Thanks.

Answer 1

Hi Muggo Bruh,

 

May I know if you need further help?

If so, please feel free to contact me. And I will further assist  you.

 

Best Regards,

May

Hi May,

I was told that I am no longer required to include error bars because the error bars are just too large compared to the values that I'm plotting on the graph which is why it basically just zooms out my graph really far out.

Thanks for the reply, Muggo

Answer 2

Hi Muggo Bruh,

May I know if you need further help?

If so, please feel free to contact me. And I will further assist  you.

Best Regards,

May

Answer 3

Hi Muggo Bruh,

Thank you for posting in this community.

According to my tests, you may try to select the vertical Axis > right click and choose Format Axis to change the units value.

In this case, you may change the value for the Major units to 0.02 to see the result. Like shown below:

 

If the issue persists, may I confirm the following information for a better understanding of your situation?

1. May I know if the issue happens to specific files or all files? To check this, please create a new file to see the result.
2. The build and version information of your Excel? (File>Account.) Could you please share a screenshot on the Product information page and help mask your email address to protect your privacy? Like shown below:

3. The build and version information of your Windows? (Click the Start menu > Type “winver” > and hit Enter.)

Best Regards,

May