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