Hi all,
On a graph showing dates on the x axis, is it possible to have some kind of marker indicating today's date that changes in real time as the date changes?
Ideally I would like a red line bissecting the x axis, labelled with "today", or the date.
yes. add a dummy series that is based on a cell using the NOW() function.
http://www.andypope.info/ngs/ng25.htm
For something of an intermediate excel user, could you explain in a little more detail?
which part exactly do you need more detail on?
Can you post your workbook so I can explain in context to your data
It's ok I just saw the link to your workbook, I'll take it from there. Thanks for the help.
Remember to update the dates in the example as it is quite old and todays data is beyond the example data set
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks