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?

Hi,

Create an XY-Scatter Plot, rather than a line plot.
Right click on any data point --- "Format Data Series" --- "X-Error Bars"
tab --- select the "Minus" box, check "Percentage" radio button and enter
100 for % --- repeat this in the "Y-Error Bars" tab --- then go to "Data
Labels" tab and check "X Value"
With a Line Plot, you can get the Data Labels, and only the Y-Error Bars.
In both plots, you can drag the data labels and place them wherever you want.

Regards,
B. R. Ramachandran

"Lynn" wrote:

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?

Many thanks. Thats great

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 ,
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?