How to Draw a Horizontal Line in Excel Graph (2 Easy Ways)

Excel is the most widely used tool for dealing with massive datasets. We can perform myriads of tasks of multiple dimensions in Excel. Sometimes, we use graphs and charts in Excel. We can easily draw a horizontal line in Excel graph when we need to. In this article, I will show 2 methods of how to draw a horizontal line in an Excel graph.


Download Practice Workbook

Download this workbook and practice while going through the article.


2 Suitable Ways to Draw a Horizontal Line in Excel Graph

This is the dataset for today’s article. I have the sales amount for each month and the forecasted sales. I will draw a horizontal line using the forecasted sales.

how to draw a horizontal line in excel graph


1. Draw a Horizontal Line Using Recommended Charts Option in Excel

In this section, we will see how to draw a horizontal line with an Excel graph simultaneously. I will be using recommended charts for this method.

Steps:

  • Select the range B4:D11. Then, go to the Insert tab >> select Recommended Charts.

  • Insert Chart box will appear. Go to All Charts >> select Combo.

how to draw a horizontal line in excel graph

  • Excel will see the options available for charts. Since we are going to draw the horizontal line with forecasted sales, we will keep the Chart Type for Forecasted Sales as the Line. Then, click OK.

  • Excel will draw a horizontal line.

how to draw a horizontal line in excel graph

Read More: How to Make a Single Line Graph in Excel (A Short Way)


2. Add a Horizontal Line to an Existing Excel Graph

Here, I will discuss a slightly different method. This time I am going to add a horizontal line to an existing Excel Graph.

Look at the image below. Here, I have a graph of actual sales and the corresponding months. In this existing graph, I will add a horizontal line with the forecasted sales.

Steps:

  • Select the chart. Then right-click your mouse to bring the menu. After that, select Select Data.

how to draw a horizontal line in excel graph

  • Select Data Source box will appear. Select Add.

  • Edit Series box will pop up. Give the new series a name and put the values. In my case, the name is Forecasted Sales and the values are D5:D11. Then click OK.

how to draw a horizontal line in excel graph

  • Excel will add a new series. Click OK.

  • You will see that a new cluster of columns is visible. These columns represent the forecasted sales. Now our task is to convert these columns to a horizontal line.

how to draw a horizontal line in excel graph

  • To do so, select the new columns. Then right-click your mouse to bring the menu. After that, select Change Series Chart Type.

  • Change Chart Type window will appear. Now select the type of Forecasted Sales as Line from the drop-down Then click OK.

how to draw a horizontal line in excel graph

  • Excel will convert the columns into a horizontal line.

Read More: Draw Target Line in Excel Graph (with Easy Steps)


Things to Remember

  • You can add horizontal lines to other types of graphs and charts too.

Conclusion

In this article, I have demonstrated 2 easy ways to draw a horizontal line in an Excel graph. I hope it helps everyone. If you have any suggestions, ideas, or feedback, please feel free to comment below.


Related Articles

Akib

Akib

Hi, this is MD Akib Bin Rashid. I completed my BSc in Engineering back in 2019. After that, I did an MBA. Then, I joined as an Excel and VBA Content Developer at SOFTEKO Digital. Being passionate about data analytics and finance, I will try to assist you with Excel

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo