Thread: Macro to graph (or draw) a vertical line on the chart
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Andy Pope Andy Pope is offline
external usenet poster
  
Posts: 2,489
Default Macro to graph (or draw) a vertical line on the chart
Hi,

Like this?
http://www.andypope.info/ngs/ng25.htm

Cheers
Andy

Brenner wrote:
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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
Reply With QuoteReply With Quote