Drawing two para

Dear All,

I want a parallel to x-axis a bold line (automatic) in my bar attached chart at 10% (Target) and at 20%(Threshold).

Any Assistance.

Rgds,

Ahk

Have you tried just drawing the line on the chart by selecting INSERT/SHAPE/LINE and then formatting the line to whatever thickness and colour you want?

I can do from the line.But i want automatic in chart.

Quote:

---

Originally Posted by offthelip

Have you tried just drawing the line on the chart by selecting INSERT/SHAPE/LINE and then formatting the line to whatever thickness and colour you want?

---

Quote:

---

Originally Posted by aligahk06

I can do from the line.But i want automatic in chart.

---

Then try the macro recorder to write an initial set of code, using INSERT/SHAPE/LINE with the required formatting and then post back with a sample workbook.