<div>
What version of excel are you using?
</div>


<div>
Sorry, using Excel 2002, SP3
</div>


<div>
Worked perfectly! &nbsp;Thanks for your help!
</div>


Worked perfectly!  Thanks for your help!

<div>
<div class="content wysiwyg-content">
I have a simple Excel spreadsheet with a date column and a column for recording historical data, for days past, and projected data for future dates. &nbsp;Each day the actual data is entered in the cell for that day replacing the projection formula. &nbsp;I chart this information on a line graph in the same spreadsheet and I'd like to have a marker to indicate the current day's point on the line and have it update dynamically each day. &nbsp;Any suggestions?
</div>
</div>


I have a simple Excel spreadsheet with a date column and a column for recording historical data, for days past, and projected data for future dates.  Each day the actual data is entered in the cell for that day replacing the projection formula.  I chart this information on a line graph in the same spreadsheet and I'd like to have a marker to indicate the current day's point on the line and have it update dynamically each day.  Any suggestions?

Single point marker to indicate Today in an Excel line graph

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.