View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default How do I put error bars in front of markers in an excel chart?

Hi,

The markers are displayed above the error bar.
One way to make the error bar appear over the markers is to use a duplicate
data series on the secondary axis.
Format the series on the secondary axis to have no line or marker, only the
error bars.
Format the series on the primary axis to have line and marker formatting as
you require.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"srshah" wrote in message
...
How can I move my error bars so that they are in front of the data markers
in
an excel chart? If the error bars are smaller than the marker they will
still be visible that way.