How to add individual error bars in google sheets

Occasionally you may want to add custom error bars to a chart in Excel.

This tutorial provides a step-by-step example of how to create the following chart with custom error bars in Excel:

Let’s jump in!

Step 1: Enter the Data

First, let’s create the following dataset that shows how various sports analysts ranked a particular basketball player in their first five years of being in the league:

Step 2: Calculate the Average & Standard Deviation

Next, type the following formulas into cells B6 and B7 to calculate the average and standard deviation of values for each year:

• B6: =AVERAGE(B2:B5)
• B7: =STDEV(B2:B5)

We can then click and drag each of these formulas to the right to calculate the average and standard deviation of values for each year:

Step 3: Insert Scatter Plot

Next, highlight the cell range B6:F6, then click the Insert tab along the top ribbon, then click the icon called Scatter within the Charts group.

The following scatter plot will be created that shows the average player ranking during each of the fiv

how to add error bars in excel line graph

how to add error bars in excel for each point