Hi,

Unfortunately adding both sets of error bars is how xl2007 currently works.
Once you have the error bars displayed you will need to select the
horizontal error bars and delete them.

Cheers
Andy

trueblu wrote:
when using excel 2007, in scatter charts. I can't seem to specify only
y-axis (vertical) error bars. The dialogue box states vertical error bars,
but horizontal ones are also added? Any hints?

--

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