software

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.--
rvExcelNewTip
------------------------------------------------------------------------
rvExcelNewTip's Profile: www.excelforum.com/member.php...oamp;userid=15668
View this thread: www.excelforum.com/showthread...hreadid=498625Hi,

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:
gt; I have a scatter chart with smooted lines and no data markers that
gt; represents a (one) mathematical function. Is it possible to highlight
gt; (mark) one data point and from that point draw parallel (dashed) lines
gt; to the x and y axes?
gt;
gt; By hovering over the chart you can pop up the data values but I want
gt; (if possible) the parrallel lines to better visualize the position of
gt; the selected point on the axes.
gt;
gt;

--

Andy Pope, Microsoft MVP - Excel
www.andypope.info

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

Andy Pope wrote:
gt; Hi,
gt;
gt; Add an extra series to the chart. This only needs a single x and y
gt; value. Change the series to plot a data marker with no line. Use the X
gt; and Y error bars of the new series to make connecting lines from the
gt; point to the axes.
gt;
gt; Cheers
gt; Andy
gt;
gt; rvExcelNewTip wrote:
gt;
gt;gt; I have a scatter chart with smooted lines and no data markers that
gt;gt; represents a (one) mathematical function. Is it possible to highlight
gt;gt; (mark) one data point and from that point draw parallel (dashed) lines
gt;gt; to the x and y axes?
gt;gt;
gt;gt; By hovering over the chart you can pop up the data values but I want
gt;gt; (if possible) the parrallel lines to better visualize the position of
gt;gt; the selected point on the axes.
gt;gt;
gt;gt;
gt;

--

Andy Pope, Microsoft MVP - Excel
www.andypope.info

In addition to Andy's suggestions, you may also want to look at

Hover Chart Label
www.tushar-mehta.com/excel/so...bel/index.html

and

Interactive Chart
www.tushar-
mehta.com/excel/software/interactive_chart_display/index.html

Neither is exactly what you want but...

--
Regards,

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

In article lt;rvExcelNewTip.217g0z_1136537100.9843@excelforum-
nospam.comgt;,
says...
gt;
gt; I have a scatter chart with smooted lines and no data markers that
gt; represents a (one) mathematical function. Is it possible to highlight
gt; (mark) one data point and from that point draw parallel (dashed) lines
gt; to the x and y axes?
gt;
gt; By hovering over the chart you can pop up the data values but I want
gt; (if possible) the parrallel lines to better visualize the position of
gt; the selected point on the axes.
gt;
gt;
gt; --
gt; rvExcelNewTip
gt; ------------------------------------------------------------------------
gt; rvExcelNewTip's Profile: www.excelforum.com/member.php...oamp;userid=15668
gt; View this thread: www.excelforum.com/showthread...hreadid=498625
gt;
gt;


I tried the error bar approach because it looked the simplest and most
straightforward . But I'm now stuck with the following snag: The
Y-axis has a logarithmic scale and whatever I try, I cannot get an
error bar DOWN from the data point to the X-axis!

I specified a value of 100% for the error, or alternatively I tried to
Customize with the Negative Y-value (workshell location of Y value) but
to no avail. If I selected Both (to have the error bar extended on both
sides of the data point) only the upper part showed up!

I'm working with Excel 2003. Is this a bug or does it quot;works as
designedquot;? --
rvExcelNewTip
------------------------------------------------------------------------
rvExcelNewTip's Profile: www.excelforum.com/member.php...oamp;userid=15668
View this thread: www.excelforum.com/showthread...hreadid=498625Hi,

Try adding another single point that is the correct X value, Y value is
the same as where the x-axis crosses the Y axes. And use the custom
error bar value linked to the Y value.
So the error bar is now connecting the axis to the point rather than the
point to the axis.

Cheers
Andy

rvExcelNewTip wrote:
gt; I tried the error bar approach because it looked the simplest and most
gt; straightforward . But I'm now stuck with the following snag: The
gt; Y-axis has a logarithmic scale and whatever I try, I cannot get an
gt; error bar DOWN from the data point to the X-axis!
gt;
gt; I specified a value of 100% for the error, or alternatively I tried to
gt; Customize with the Negative Y-value (workshell location of Y value) but
gt; to no avail. If I selected Both (to have the error bar extended on both
gt; sides of the data point) only the upper part showed up!
gt;
gt; I'm working with Excel 2003. Is this a bug or does it quot;works as
gt; designedquot;?
gt;
gt;

--

Andy Pope, Microsoft MVP - Excel
www.andypope.info


That's cool Andy!

But do you have any eplanation for Excel's native behaviour?--
rvExcelNewTip
------------------------------------------------------------------------
rvExcelNewTip's Profile: www.excelforum.com/member.php...oamp;userid=15668
View this thread: www.excelforum.com/showthread...hreadid=498625