View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Brenner Brenner is offline
external usenet poster
 
Posts: 17
Default Macro to graph (or draw) a vertical line on the chart

Each of my charts has about 60 days along the Y axis, and I would like the
senior manager to be able to see a dotted line that goes from the Y axis
(always from today's date) to the data point that represents today's value.

Is it possible to add a vertical series? Or to graph or draw a vertical line
that will "walk" along the Y axis?

Thanks!
John