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.
1
First, we need to make a chart out of it.
So, for that select the data and Go to Insert > Charts
2
You can select any chart from the chart option. But here for an explanation, we will consider 2-D Column chart
3
Select your style and colour of your chart following the steps shown in the snapshot below.
4
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.
5
Select the desired option and it will display error bars on your chart.
6

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.

7
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.
8
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.

Leave a Reply

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

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.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube