How To Create Custom Error Bars In Excel 2016

In this article, we will learn where to find and how to add and customize Error bars in Excel 2016.

Error bars are used in charts to show errors as custom values. Error bars in charts are used to show data variability.

All of the above might be confusing for some people, so let’s gear up & start learning Error bars in Excel 2016 with the example.

Here we have sales values corresponding to the months of the year.
First, we need to make a chart out of it.
So, for that select the data and Go to Insert > Charts
You can select any chart from the chart option. But here for an explanation, we will consider 2-D Column chart
Select your style and colour of your chart following the steps shown in the snapshot below.
Now We need to add error bars. To add error bars move your mouse pointer on the +symbol on the top right of your chart.
Select the standard Error option and customize it using the Format Error bar option.
Select the desired option and it will display error bars on your chart.

Customize Error bar of the chart by Double click on any of the error bar will open Format Error Bars on right side of your sheet.

Note: Double click on the chart will open Format Chart on right side of your sheet.

Select the type of customization and Error Amount method.

Here we will select the percentage of 10% for both plus and minus. So it will show that on your chart.
The chart shows the 10% variability in the Sales of the Months.

Hope you understood how to insert error bars and customize it in Excel 2016. Find more articles on Charts and Graphs. Please share your query below in the comment box. We will assist you.

Related Articles:

4 Creative Target Vs Achievement Charts in Excel

Excel Sparklines : The Tiny Charts in Cell

Best Charts in Excel and How To Use Them

How to Use Excel Stock / High-Low Charts

Popular Articles:

50 Excel Shortcuts to Increase Your Productivity

How to use the VLOOKUP Function in Excel

How to use the COUNTIF function in Excel

How to use the SUMIF Function in Excel


Leave a Reply

Your email address will not be published. Required fields are marked *

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.