View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
septimus septimus is offline
external usenet poster
 
Posts: 20
Default Vertical line on Excel chart

I have a bar chart in Excel. I want to add a series of vertical dotted
lines at certain points on the x axis.

I can do this manually using Insert - Shapes - Line, but I want to
do it programatically.

I am able to put dotted vertical BARS (not lines) at the desired
points. And I can put a dotted line that runs across the bottom at
zero and then goes up at tne desired point, but neither are really
acceptable solutions.

There must be a way to do this?

Thanks!