drawing lines in Excel 2007
 

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.
--
Perplexed in Trana

drawing lines in Excel 2007
 

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/...ertErrBar.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"truenorth" wrote in message
...
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.
--
Perplexed in Trana