Add vertical line to line chart

[pagrender]

Hello,

I have a line chart where the X-axis has the values 2000-01 to 2015-16 (these are fiscal years). I would like to add a vertical line to represent this fiscal year, which is 2010-11. Is there a way to do that?

Thanks,
Pete

 

[VoG]

Hi. Try this http://peltiertech.com/Excel/Charts/AddLine.html

 

[mitchv3]

So what if I have a chart that is already using the secondary axis to plot a 2nd set of data?

Forexample, if I plot Sales and Theft on two different Y-axis with dates on the X-axis, can I also add a vertical line(s) for specific event dates?

Mitch