draw vertical line to mark today in diagram

F

Florian Demmer

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
 
D

David Biddulph

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Is there a way to draw a vertical line from a point on the chart line to the bottom of the chart 7
Can I combine points in a scatter diagram without drawing by hand 0
Macro to graph (or draw) a vertical line on the chart 7
How to draw a graph with the X axis as a time line of date. 4
Plotting a current Date Vertical Line 2
Venn diagram macro in VBA. 1
How do I draw a line from top to bottom on my chart? 0
vertical line in graph 1

Top