[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 555
  • Last Modified:

Single point marker to indicate Today in an Excel line graph

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?
0
jppuckett
Asked:
jppuckett
  • 2
1 Solution
 
Ken ButtersCommented:
What version of excel are you using?
0
 
jppuckettAuthor Commented:
Sorry, using Excel 2002, SP3
0
 
wittysloganCommented:
it's not very elegant, but lets say your date column is A and your data is in B.
In C2 put =IF(A2=TODAY(),B2,0) and copy that down to the bottom of you data set.
This should then show the value at todays date and everything is zero.

On your graph add a series for C.

Finsih the graph and then format series and you should be able to get a point showing just today.
0
 
jppuckettAuthor Commented:
Worked perfectly!  Thanks for your help!
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now