# How to Create a Bar Chart with Standard Deviation in Excel: 4 Methods

### Method 1 – Making Data Set with Proper Parameters

• Create a data set first.

### Method 2 – Finding Standard Deviation and Mean

• Select cell C12.
• Enter the following formula.
=AVERAGE(C5:C10)

• Hit Enter and drag down the Fill Handle icon to see the results.

• Select cell C13.
• Enter the following formula.
=STDEV(C5:C10)

• Ht Enter and drag down the Fill Handle icon to see the results.

### Method 3 – Utilizing Charts Group

• Go to the Insert tab after selecting the data range from the given data set.
• Choose the Insert Column or Bar Chart from the Charts group.
• Select the Clustered Column option from the 2-D Column group.

• Our bar chart with the mean value. Organize this bar chart with standard deviation.
• Choose the Error Bars option from the Chart Element group.
• Select More Options.

• A Format Error Bars panel will appear to you.
• Tick the Custom option and click on the Specify Value.

• See the Custom Error Bars dialog box in the below image.
• Select the Standard Deviation value from the data set and then click OK.

### Method 4 – Showing Excel Bar Chart with Standard Deviation

• See a bar chart with standard deviation in the below image.

You may download the following Excel workbook for better understanding and practice it by yourself.

.

## Related Articles

<< Go Back to Excel Bar Chart |Â Excel ChartsÂ |Â Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Bishawajit Chakraborty

Bishawajit Chakraborty, a Rajshahi University of Engineering & Technology graduate with a B.Sc. in Mechanical Engineering, has been associated with ExcelDemy since 2022. Presently, he is a content developer, specializing in Excel Power Query, Data Analysis and VBA. It is worth mentioning that he has authored more than 90 articles on VBA content development. His profound interest lies in the fields of data analytics and data science. He possesses expertise in VBA, Power BI, machine learning, and Python... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF