Today, we will discuss step-by-step procedures to add horizontal error bars in Excel. Generally, error bars indicate the errors in results and show the variability in Excel. In most cases, you will find vertical error bars in Excel. We can add horizontal error bars only to bar charts, X-Y scatter plots, or bubble charts. So, without further delay, let’s start the discussion.
Download Practice Book
Download the practice book here.
Error Bars in Excel
Error bars in Excel indicate the deviation or variability of a data point. It shows how much the real result can deviate from the measured result. This is an essential feature for data analysis. The below picture shows vertical error bars. Here, each error bar shows how much or less the sales amount can be.
There are different kinds of error bars in Excel. They are Standard Error, Percentage, Standard Deviation, Fixed Value, and Custom Error bars. These error bars are used for different purposes. Now, let’s follow the steps below to add horizontal error bars in Excel.
Step-by-Step Procedures to Add Horizontal Error Bars in Excel
To explain the steps, we will use a dataset that contains information about the sales and profit of a shop. Here, we will plot this information in a graph first. Then, we will add horizontal error bars.
STEP 1: Plot Graph to Add Horizontal Error Bars in Excel
- First of all, we need to plot the data.
- To do so, select the cells that you want to plot. Here, we have selected Cell B6 to C9.
- After that, go to the Insert tab and select Insert Column or Bar Chart icon. A drop-down menu will appear.
- Select the Clustered Bar icon from the drop-down menu.
- Instantly, you will see a bar graph like the picture below.
STEP 2: Add Horizontal Error Bars in Excel Using Plus Icon
- In the second step, we will add horizontal error bars.
- For that purpose, click on the plus (+) icon. It will open the Chart Elements option.
- Select Error Bars from there.
- As a result, you will see horizontal error bars like those below.
STEP 3: Change Settings of Horizontal Error Bars
- In the third step, we will show how to change the settings of horizontal error bars.
- To change settings, click on the plus (+) icon.
- After that, put the cursor on the Error Bars. An arrow sign will appear.
- Click on the arrow sign to open a drop-down menu.
- Select More Options from there.
- After that, the Format Error Bars options will occur on the right side of the screen. You can change the Direction, End Style, and Error Amount of the Horizontal Error Bar.
- From the settings, we can see Standard Error is currently applied.
STEP 4: Use Excel Scatter Chart to Add Horizontal Error Bars
Previously, we used bar charts to add horizontal error bars. But you can also use the scatter chart to do so. The process is slightly different.
- In the first place, select cells from your dataset like in STEP-1.
- Then, go to the Insert tab and select the Insert Scatter icon.
- After that, click on the Scatter icon.
- Instantly, you will see a graph like a picture below.
- Now, click on the plus (+) icon and select Error Bars. A menu will occur.
- Select More Options from the menu.
- In the following step, select Error Bar Options in the Format Error Bars section.
- Next, select Series “Sales” X Error Bars to add horizontal error bars.
- Finally, there will be error bars in your graph.
How to Add Error Bars in Excel 2010 or Earlier Versions
The process of adding error bars in Excel 2010 or earlier versions is different from the above steps. To add error bars in the earlier versions, pay attention to the steps below.
- Firstly, click on the chart to activate the Chart Tools option on the ribbon.
- After that, go to the Layout tab.
- Then, select Error Bars in the Analysis section.
- A drop-down menu will occur. You can select different types of Error Bars from there.
How to Format Error Bars in Excel
Formatting error bars is important to make the graph more understandable. In Excel, we can do that very quickly. Just follow the steps below to see how it’s done.
- In the first place, select an error bar and right-click on it. It will open the Context Menu.
- Select Format Error Bars from there.
- After that, click on the Fill & Line icon to change the color and line of the error bars.
- Also, you can use the Effects section to edit more.
- Finally, after formatting, our error bars look like the picture below.
How to Delete Error Bars
Deleting error bars is one of the easiest tasks. The steps are given below.
- In the beginning, select an error bar and then, right-click on it. A Context Menu will appear.
- Select Delete from there.
- Alternatively, you press the Delete key on the keyboard.
In this tutorial, we have demonstrated step-by-step guidelines to ‘Add Horizontal Error Bars in Excel‘. Moreover, this discussion will help you to add all types of error bars. Furthermore, the practice book is also added at the beginning of the article. You can also download the practice book to exercise more. Last of all, if you have any queries or suggestions, feel free to ask in the comment section below.