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 <52615634-C3E0-4783-AB81-(E-Mail Removed)>,
(E-Mail Removed) 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?
>