draw vertical line to mark today in diagram
 

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

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