How to Add Error Bars to a Line Chart in Microsoft Excel

In this article, you will learn how to add error bars. Error bars is a great feature in Excel that provides flexibility to the user to show detail to a chart. We can use error bars to show variability in the KPI’s which are plotted in the chart.

Let us take an example to understand:

We have Sales Report that contains Month, Forecast Sales & Actual Sales.

img1

Click on any cell in the above table of data.

Click on Insert tab

From Charts group, click on Line Charts

img2

Select Line with Markers option

img3

Assign name to the Chart (Sales Chart)

img4

Click on the Forecast Sales Line (Blue Line)& click on Chart Elements on the upper right hand corner (plus sign)

Select Error Bars, you will find three options to select

Standard Error, Percentage, Standard Deviation & More options

img5

If we click on Standard error then, the Chart will look like this:

img6

If you click on More Options, you will find the following Error bar options

img7

In Vertical Error bar, we can show the error bar by Minus, Plus & both as well.
There are various Error Amount available for selection like Fixed value, Percentage, Standard deviation, Standard error, Custom, etc.

img8

With Custom option, you can show custom error value that you want it to appear.
There are lots of different options available like Line color, transparency, width, etc.

img9

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