Can I know how to add error bars in Excel on Windows 10.

Asked By Martha J Clark 0 points N/A Posted on - 06/06/2020

Hi, I am considerably new to Microsoft Excel. I am working with charts, and I have trouble adding error bars to chart. I want my chart to show the margin of error as shown below-

How to add error bars in Excel so that I can achieve the desired structure? Thanks in advance!

• Status:
• Question Views: 36
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: Windows OS

Best Answer by

Go To Solution

Answered By Robin J Bonner 0 points N/A #330087

Can I know how to add error bars in Excel on Windows 10.

Hey! I went through this when I started off with excel too, and this is what I found. Here’s how to add error bars in Excel? Firstly, select the chart at a random point. Click on the “Chart elements” and choose the “error bar” box. If you want, you can change the error amount from the arrow icon adjacent to the “Error bar”.

From “More options,” set your customized amounts.

You are done!

About Robin J Bonner

Questions
2

Answers
6

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 06/06/2020
• Question Category: Windows OS