PDA

View Full Version : Drawing two para



aligahk06
11-01-2017, 04:53 AM
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

offthelip
11-01-2017, 08:51 AM
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?

aligahk06
11-02-2017, 05:42 AM
I can do from the line.But i want automatic in chart.


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?

Aussiebear
11-05-2017, 02:10 PM
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.