how to extend horizontal line on column graph

Hi
I have the chart below. I am trying to extend the horizontal line so that it spans the whole of the x-axis
How can this be done? I have attached the excel file.

Hi Bos1234,

Welcome to the forums.

1) You need to move your line to the second axis.
2) Then you need to show the secondary horizontal axis
3) Then you need to change the Position Axis option on the secondary horizontal axis to On Tick Marks
4) Then change the secondary axis Major Tick Mark Type to None and the Axis Labels to None
5) Then delete the secondary VERTICAL Axis

If you want to see this in action with a step-by-step and video tutorial here:

How-to Create Sales Quota Threshold Horizontal Lines in an Excel Column Chart

Here is your file with the line stretched across the axis: Extend Line across entire Axis.xlsx

Please let me know if this helps.

Steve=True

thank you sir
worked perefectly

That is so awesome!

Thanks for the feedback.

Glad it worked perfectly for you.

Steve=True

Steve=True

Just used this with clustered column and two lines and it worked for mr also. Thanks.