Remove Horizontal Error Bars in Excel (Easiest Way in 2025)

In this article, we will show you how to remove horizontal error bars in Excel. Simply follow the steps below.

How to Get Rid of Horizontal Error Bars in Excel

To get rid of horizontal error bars in Excel, simply follow the steps below.

1. Select Your Chart

Open your Excel file and locate the chart from which you want to remove the horizontal error bars. Click directly on the chart to select it. You should see a border appear around the chart which indicates that it is selected.

2. Access Chart Elements

With your chart selected, look at the Excel ribbon at the top of the screen and click on the Chart Design tab. This tab is part of the tools that appear when a chart is selected. Once in the ‘Chart Design’ tab, click on the ‘Add Chart Element‘ button in the Chart Layouts group. This will open a drop-down menu with various chart elements you can add or remove.

3. Disable Error Bars

Select ‘Error Bars’ from the drop down menu and then choose ‘None.’ 

4. Confirm Removal

After clicking the ‘None’ option, the error bars should no longer be visible on your chart.

We hope you now have a better understanding of how to remove horizontal error bars in Excel. If you enjoyed this article, you might also like our article on how to add horizontal error bars in Excel or our article on how to add vertical error bars in Excel.