error bars don't display consistently in excel

[Amy]

Hi,
I am plotting lots of similar graphs in Excel. To make a new graph, I just
copy and paste the previous one and then change the source data to the new
data series that I want to plot. But when I change the source data for the
error bars (I am using custom data to say what size the error bars should
be), their display sometimes changes, so that the error bars are just
vertical lines without a horizontal cap on the end. Why do they change
sometimes but not always, and how do I set the default error bar format? I
know how to change them back to the display I want, it's just annoying doing
it every time.
Thanks.

 

[Amy]

I'm using Excel 2003 by the way.

 

[Jon Peltier]

Amy -

I don't know how to prevent this annoyance. I just automatically change the
data by double clicking on the existing error bars, then click on the
Patterns tab and click on the icon with the end caps.

- Jon