Hi,

Add an extra series to the chart. This only needs a single x and y
value. Change the series to plot a data marker with no line. Use the X
and Y error bars of the new series to make connecting lines from the
point to the axes.

Cheers
Andy

rvExcelNewTip wrote:
I have a scatter chart with smooted lines and no data markers that
represents a (one) mathematical function. Is it possible to highlight
(mark) one data point and from that point draw parallel (dashed) lines
to the x and y axes?

By hovering over the chart you can pop up the data values but I want
(if possible) the parrallel lines to better visualize the position of
the selected point on the axes.



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

See Ed Ferrero's Intercept Vertical Lines example.
http://www.edferrero.com/Charting.aspx

Andy Pope wrote:
Hi,

Add an extra series to the chart. This only needs a single x and y
value. Change the series to plot a data marker with no line. Use the X
and Y error bars of the new series to make connecting lines from the
point to the axes.

Cheers
Andy

rvExcelNewTip wrote:

I have a scatter chart with smooted lines and no data markers that
represents a (one) mathematical function. Is it possible to highlight
(mark) one data point and from that point draw parallel (dashed) lines
to the x and y axes?

By hovering over the chart you can pop up the data values but I want
(if possible) the parrallel lines to better visualize the position of
the selected point on the axes.




--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info