I can confirm this bug.
Workaround:
Specify ranges on the same sheet for the error-bar values
Chart is OK
Now Cut and Paste the values to the other sheet
Seemed to work in a limited test I did.
Please give feedback on your experience
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"rookie6521" wrote in message
...
When choosing the option to add a custom error bar in Exel 2007 and trying
to
set the range to a worksheet that does not contain the chart I receive an
error in Excel that closes down Excel.

The steps I perform a 1. Click on a bar in my chart 2. Click Layout 3.
Click the drop down for error bars 4. Click more error bar options... 5.
Choose custom and click specify value. 6. Click to set the range where
this
is then displayed ={1}.

As soon as I change to the worksheet to set the range Excel errors out and
shuts down.

I have recreated this on more than one machine and the result is the same.
I
have also seen other posting this same problem with no resolution.

Thanks