How To Add Excel Chart With Error Bars And Standard Deviation In Excel 2013?

Asked By Louise J Bahena 30 points N/A Posted on - 10/21/2017

Hello experts,

I want to add charts to my Excel sheet. Please provide me the steps to add Excel chart with error bars and standard deviation in Excel 2013.

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

• Answer Accepted: No
• Question Category: MS Excel
• Question Tags: error bars | Excel

Answered By Mike Atherton 10 points N/A #304730

How To Add Excel Chart With Error Bars And Standard Deviation In Excel 2013?

To add error bars and standard deviation to Excel chart, you need to generate graph first.

To add a graph to the sheet use insert option.

In the charts pane uses the required graph you need.

When the plan appears on the sheet, right-click on the chart and choose error bars option.

Error bars will bring a new side option pane with more choices, select standard deviation.

You can also insert the standard deviation to the sheet by using add chart element option.

About Mike Atherton

Questions
36

Answers
3

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 10/21/2017
• Question Category: MS Excel