Hi
Book3.xlsx
Please see attachment! Assuming that today is Nov 22:
| Black solid line is the actual months
| blue dotted line is the forecast months
| black marker denotes the current month
When it eventually becomes Dec 22, I would like the black solid line to extend to Dec, and the black marker to move to the Dec column.
Is there a way to do this without manually going into Select Data > Updating range?
Thanks so much guys!
Bookmarks