View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default draw vertical line to mark today in diagram

I would suggest that you generate a new series with 2 data points with the
following coordinates:
=TODAY() and Ymin
=TODAY() and Ymax

Add that series as a new series in your chart.
--
David Biddulph

"Florian Demmer" wrote in message
...
Hi experts,

I have a x/y diagram displaying several curves over time. The timespan
is from a few months back with real values on y to a few months into
the future with predicted values on y. I would like to have a vertical
line at the x position of today to make the separation between
predicted and real values more visual... is that possible dynamically?

(office 03)

thanks in advance!
Florian