We have already explained the possibility of adding a vertical line to the Excel Bar Chart. However, there is also a possibility of going in a different direction- adding a **horizontal line to an Excel chart**.

We will show how to do it in the example below.

## Add Horizontal Line to Clustered Column

To show the addition of the horizontal line, we will use **Clustered Column chart**, as this chart is one of the most widely used ones.

We will create it based on the data of **NBA players and their points** in one night of basketball:

After doing that, we will resort to creating a simple **Clustered Column chart**, by selecting our range (**A1:B11**) and then going to **Insert tab >> Charts** and finding and choosing **Clustered Column chart** that is located under **2-D Columns**:

It is noticeable that we get the preview of our chart, and when we choose it, it will be the same, as shown in the picture below:

Now we need to create an additional table with **x and y values** (**horizontal and vertical ones**). We want to present the average values horizontally, so our **x values** will be equal to the **averages of all the points** (two values), while the **y values will be values 0 and 10** (the number of players in our table):

We will then copy this data (**range D2:E3**), click on our chart, and go to the **Home tab**, where we will find **Paste special option**:

In a window that appears when we click on **Paste Special**, we will choose **New series **under **Add cells as an **option, **Columns **in **Values (Y)**, and click on **Categories (X Labels) in First Column**:

When we **click OK**, we will have the chart presented as follows:

To make these **two orange lines horizontal**, we need to change the type of our chart. We will do so by clicking on it, and then choosing the **Change Chart Type **option:

On the window that appears, we need to choose **Combo chart** at the end of it, and then choose **Scatter with Straight Lines** as a **chart for Series2**:

We can still see that the average line is not where it should be. For the full effect, we need to **uncheck** the **Secondary Axis button** for **Series2**:

As seen in the preview, we will have our data presented in the way we want. We will click **OK** and have our chart set:

As seen, we lost the title of our chart along the way. To add it again, we will simply click on the chart, then on the **plus sign on the upper right side**, and choose **Chart Title**:

Then we can insert whatever we want- **Points** in our case.