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

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.

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

Sure, I can help you with that! Here are the steps to move your error bars in front of the data markers in an Excel chart:

1. First, select your chart by clicking on it.
2. Next, click on the "Format" tab in the ribbon at the top of the screen.
3. In the "Current Selection" group, click on the drop-down menu and select "Error Bars" (or whichever element you want to move in front of the markers).
4. Right-click on the error bars and select "Format Error Bars" from the drop-down menu.
5. In the "Format Error Bars" pane that appears on the right side of the screen, click on the "Marker Options" tab.
6. Under "Marker Options," select the radio button for "Built-in" and choose a marker type from the drop-down menu.
7. Next, click on the "Marker Fill" option and select "No Fill" so that the markers are transparent.
8. Finally, click on the "Close" button to apply the changes.

Your error bars should now be in front of the data markers in your Excel chart. If the error bars are smaller than the markers, they will still be visible.

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.