How do I put error bars in front of markers in an excel chart?

S

srshah

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.
 
A

Andy Pope

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top