How to insert a line into a column/bar chart in Excel

Hi all, previously I have some trouble inserting a target line into a column/bar chart in Microsoft Excel

It took me couple of hours to figure things out, and here you will learn how to do it in just a few minutes

lets say you would like to create a column chart which shows the exam results of the students in class 1.

First, you need to create the column chart from the data (exam results) you have

1. Highlight the data 
2. Choose Insert tab  
3. Click on Columnoption
4. Select Clustered Column from the dropdown menu

Now you have a column chart in blue colour

Lets move on to insert a target line in the bar chart, say the passing mark is 60. You want to draw a horizontal straight line at this point.

1. Create another table with the passing score (60 in this case) for all the students
   
2. Right click on the column chart, choose Select Data
3. At the Legend Entries box, select Add
4. Simply give it a name (we name it as pass) & series values remain unchanged (will change them later)
5. Click OK
6. The chart now has an additional set of data in red column
7. Now select the red column and right click, choose Change Series Chart Type
8. Click X Y Scatter on the left and select Scatter with Straight Lines (the red column will disappear)
9. Right click on the column chart again, click Select Data
10. Choose pass and hit Edit button
11. Enter Series X values & Series Y values by highlighting the data in the new table, then click OK (refer snapshot)
12. The result should be similar to this 
    

Thanks for your time, hope you like this tutorial