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
|