error bars don't display consistently in excel

A

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

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
 

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