Scatter Chart Data Point Highlighting

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

rvExcelNewTip wrote:
> 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 "works as
> designed"?
>
>

--

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