Using drop lines with XY scatter chart
 

I want to use the drop lines with a XY scatter chart, but unfortunately that
option is not available under 'Format Data Series'----'Options'.
I know that this drop line option is available with other chart types like
'Line', problem is I can't use the Line chart type since it can't correcty
represent my data set.
I want a workable solution.

Using drop lines with XY scatter chart
 

XY charts don't have drop lines, but you can substitute an error bar. Double
click on the series, click on either Error Bar tab, and select a negative
error bar, select the Percentage option, and enter 100%. If the axes still
intersect at (0,0), 100% is the distance from each point to the axis.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

"SMACS03" wrote in message
...
I want to use the drop lines with a XY scatter chart, but unfortunately
that
option is not available under 'Format Data Series'----'Options'.
I know that this drop line option is available with other chart types like
'Line', problem is I can't use the Line chart type since it can't correcty
represent my data set.
I want a workable solution.