error bars don't display consistently in excel
 

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.

error bars don't display consistently in excel
 

I'm using Excel 2003 by the way.

"Amy" wrote:

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.

error bars don't display consistently in excel
 

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Amy" wrote in message
...
I'm using Excel 2003 by the way.

"Amy" wrote:

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.