Scatter Chart Data Point Highlighting

  • Thread starter Thread starter rvExcelNewTip
  • Start date Start date
R

rvExcelNewTip

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

By hovering over the chart you can pop up the data values but I wan
(if possible) the parrallel lines to better visualize the position o
the selected point on the axes
 
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
 
I tried the error bar approach because it looked the simplest and mos
straightforward :). But I'm now stuck with the following snag: Th
Y-axis has a logarithmic scale and whatever I try, I cannot get a
error bar DOWN from the data point to the X-axis!

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

I'm working with Excel 2003. Is this a bug or does it "works a
designed"? ;
 
Hi,

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
 
That's cool Andy!

But do you have any eplanation for Excel's native behaviour?
 
Back
Top