How to Add a Horizontal Line in a Chart in Excel [Steps by Step]

While creating a chart in Excel, you can use a horizontal line as a target line or an average line.

It can you to compare achievement with the target.

Just look at the below chart.

how to add horizontal line to excel chart using best practices

You like it, right?

Say "Yes" in the comment section if you like it.

OK so listen:

Let’s say you have an average value which you want to maintain in your sales throughout the year.

Or, a constant target which you want to show in a chart for all the months.

In this case, you can insert a straight horizontal line to present that value.

Here’s the thing:

This horizontal line can be a dynamic one which will change its value or a line with a fixed value.

And in today’s post, I’m going to show you exactly how you can insert a horizontal line to a chart.

So in this post, I'm gonna share with you:

  1. How to Insert AVERAGE Line in a Chart
  2. How to Insert TARGET Line in a Chart

1. Add an Average [Horizontal] Line to a Chart

An average line plays an important role whenever you have to study some trend lines and impact of different factors on trend.

Steps to Add an Average Line

Use Data Table To Add Horizontal Line To Excel Chart
Insert A To Add Horizontal Line To Excel Chart
  • Next step is to change that average bars into a horizontal line.
  • For this, select the average column bar and Go to → Design → Type → Change Chart Type.
Go To Design Tab Add Horizontal Line To Excel Chart
  • Once you click on change chart type option, you’ll get a dialog box for formatting.
  • Change the chart type of average from “Column Chart” to “Line Chart With Marker”.
Change Chart Type To Add Horizontal Line To Excel Chart
  • Click OK.

Here is your ready to rock column chart with a average line. Download this sample file from here learn more.

How To Add Horizontal Line To Excel Chart Using Best Practices

One of my colleagues uses this same method to add a median line.

You can also use this method to add an average line in a line chart.

Steps are totally same, you just have to insert a line chart instead of a column chart.

And, you will get something like this.

Add Horizontal Line To Excel Chart In A Line Chart

Add a Horizontal Target Line in Column Chart

This is one more method which I often use in my charts is adding a target line.

There are several other ways to create a Target Vs. Achievement chart, but target line method is simple & effective.

#Steps to Add a Target Line

First of all, let me show you the data which I am using to create a target line in the chart.

add horizontal line to excel chart to present a horizontal line

I have used above table to get the target and actual figures from the month wise tables. Download sample file from here to follow along.

Now let’s start with the steps.

  • Select the dynamic table which I have mentioned above.
  • Insert a column chart. Go To Insert → Charts → Column Charts → 2D Clustered Column Chart.
  • You’ll get a chart like below.
Add Horizontal Line To Excel Chart To Insert A Target Line
  • Now, you have to change the chart type of target bar from Column Chart to Line Chart With Markers. To change the chart type please use same steps which I have used in the previous method.
  • After changing chart type your chart will look something like this.
Add Horizontal Line To Excel Chart In Target Line In Line Chart
  • Now, we have to make some changes in this line chart.
  • After that, make a double click on the line to open formatting option. Once you do that, you’ll get a formatting option dialog box.
  • Make following changes in formatting.
    1. Go to → Fill & Line → Line.
    2. Change line style to “No Line”.
Change Line Type In Line Chart To Add Horizontal Line To Excel Chart
  • Now, go to marker section and make following changes.
    1. Change marker type to Built-In, a horizontal bar, and size 25.
    2. Marker fill to solid fill.
    3. Use white color as the fill color.
    4. Make border style to a solid color.
    5. And, black color for borders.
Make Changes Add Horizontal Line To Excel Chart
  • Once you make all the changes to the line you’ll get a chart like I have below.
Add Horizontal Line To Excel Chart With Target Line

Congratulations! your chart is ready.

Sample File


So that’s the whole story about a horizontal line.

And, now if someone asks you “how do I add a horizontal line to an excel chart?” you can show them two different methods and also help them to understand why it’s important.

I'm sure this technique will help you to get better at charting.


Now tell me one thing. Have you ever added a horizontal line in a chart? Or, do you have an alternate method for this? Please share with me in the comment section, I would love to hear from you.

And, please don’t forget to share this tip with your friends.

About the Author

Puneet Gogia

He is using Excel since his college days. He helped thousands of people to understand the power of the spreadsheets and learn Microsoft Excel. You can find him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.

LinkedIn - YouTube

Content Protection by

10 thoughts

Leave a Comment

Your email address will not be published.

  1. I have a horizontal line of averages for my FitBit steps per day.
    I now have thousands of days and it takes a long time to calculate the average for all days.
    Is there a way of just calculating the first point and last point and plotting a straight line?