Adding Vertical Line to the Excel charts

[booo]

I have been trying to add a Vertical line across my chart with no luck. This is the reference link I am using:

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

I am adding a sample excel document of my date and the chart I have so far. I need to draw a Vertical line across from the present month, which I am not able to do.

Any help on getting this done is highly appreciated.

Thanks,
booo

[jpr73]

Hi,
See attached file with vertical line applied according Jon Peltier method
I disable the Bulk serie
Adjust as desired the formula dates in the Today, Last Month and Next Month series
Hope this helps
Best regards