add special lines in VBA chart

[bertjeiv]

I have written a macro which works really well but now I want to add vertical lines for certain X values.
On the X-axis i have dates and on the Y axis I have #events. Now I want to mark some dates with a vertical line, these dates are when someone made an intervention. that way I can see clearly if there are less events after an intervention. I have tried to look for solutions but cannot find anything.
Is this possible? if so how?

thanks

 

[GlennUK]

Have you tried adding a new series for the line?

 

[bertjeiv]

yes when i add a new series it adds the points but I dont know how to force it to draw vertical lines through those points from top to bottom of the chart

 

[bertjeiv]

I'm trying to do it with error bars now but then I get strange triangles.
experimenting with it now...

 

[pgc01]

Hi

Jon Peltier explains here how to add a vertical line using a series, like Glenn suggested:

http://peltiertech.com/Excel/Charts/AddLineVertSeries.html