I am not able to draw a line on a XL2007 chart in the 1st place.
I have the chart as a sheet. When I am view that chart sheet, the
illustrations menu (which contains shapes) is grayed out. What am I missing?

"Bernard Liengme" wrote:

Not sure what you mean by 'snap to'
Holding SHIFT while drawing the line will keep it horizontal but I cannot
recall in Excel2003 that you were able to fix a line that you had already
drawn - my PC will XL2003 is out of commission today so I cannot confirm
this.

I have just experimented with XL2007 : holding SHIFT does indeed keep the
line horizontal
Try again on a new worksheet and let us know the result
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"ExcelGeek75" wrote in message
...
Help! I need to draw a line on a chart that is horizontal - - in old
Excel,
the SHIFT key could be used to "snap to" the horizontal, but in Excel
2007,
it does not work and it is driving me crazy!

.