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.

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

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


"Amy" <Amy@discussions.microsoft.com> wrote in message
news:9BAAB61B-5577-43DF-93A2-8451034AE2CF@microsoft.com...
> 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.