today line on graph

F

Fluke

Hi

I have a graph with dates along the bottom up to about July this year.
Along the 'y' axis is a set of figures up to around 9000 ish.

There's 2 sets of lines on the graph for two data sets.

I'd like to have a vertical line at the point of today's date if possible.

TIA
 
D

David Biddulph

On your data sheet, generate a series with 2 points. Both points have X
values of =TODAY(). One point has a Y value of zero, and the other has a Y
value of Ymax from the rest of your data (9000 ish in your case).
Add that data series as a new series on your graph.
 

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

Graphs: 2 Lines on secondary Y-axis? 1
Line graph help!!! 1
Combining a 2-D column graph and a 2-D line graph on the same char 3
Graph with stepped increases or decreases 4
Vertical Highlighting on line graph??? 1
Labeling The Right Hand Side Of A Graph With Axis Values ? 1
Data Range Is Backward on Graph 2
Constant % on X axis 2

Top