Custom Error Bars in Excel 2007

[rookie6521]

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 are: 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

 

[Bernard Liengme]

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

 

[Mark]

You are required to be a member to post replies. After logging in or becoming a member, you will be redirected back to this page.



Posted as a reply to:

Custom Error Bars in Excel 2007

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 are: 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

EggHeadCafe - Software Developer Portal of Choice
WCF Workflow Services Using External Data Exchange
http://www.eggheadcafe.com/tutorial...a-6dafb17b6d74/wcf-workflow-services-usi.aspx