I have a line chart with various lines of data spanning past and future months, but I'd like to put a vertical black line on the chart showing the current day for reference. I'm creating the chart from a Macro which is working great, but I can't find any way to add just a line for the current date. I really thought this might be a common problem, but I've yet to find any questions or answers related to it. Also I know it's possible as I've seen it done in other Excel spreadsheets, but I don't have access to any of them to see how they did it.
Update: I've created a sample Excel spreadsheet with the logic I'm using to create the charts in the Macro, but nothing I've tried has come even close to creating a vertical line on the current date to show the current date on the chart. If someone knows how to do this and can demo it on this spreadsheet along with any other notes I'd appreciate the feedback.
Update 2: I found this showing how to add a line for current date - http://peltiertech.com/Excel/Charts/...ertSeries.html - but given I'm using Excel 2010 I'm not sure how to transpose this from the earlier version. The steps it points out don't seem to apply anymore.
Take care --
Sam
Bookmarks