For an interactive solution see
Interactive Chart
http://www.tushar-
mehta.com/excel/software/interactive_chart_display/index.html

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <52615634-C3E0-4783-AB81-CB2D53255E96@microsoft.com>,
Lynn@discussions.microsoft.com says...
> I want to draw lines from the y axis over to the data line and down to the x
> axis. I also need to show the value on the x axis. Please can someone help?
>