drawing lines in Excel 2007

[truenorth]

OK. I understand change. Change is good.

But how does one draw a simple straight line and retain control over it? I
can draw it using line from shapes and the shift key to constrain it to
vertical. The second I try to move it, it goes off vertical never to return.
Moreover, I can't move it horizontally beyond the middle section of the
chart area. It hits some invisible shield. I simply want to be able to
highlight individual data points on a line graph by a vertical line from the
x axis to the top of the chart.

 

[Jon Peltier]

Change is fine if it brings about improvements. Change for the sake of
change is a PITA, especially when it results in more busted features than
improvements. But enough flaming.

Instead of using drawing objects, which even in Excel 2003 were not
completely reliable in a chart, use a single point xy series with a vertical
error bar:

http://peltiertech.com/Excel/Charts/AddLineVertErrBar.html

- Jon