If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 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 |
#2
|
|||
|
|||
Custom Error Bars in Excel 2007
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 |
#3
|
|||
|
|||
specify error value causes excel to terminate
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 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 EggHeadCafe - Software Developer Portal of Choice WCF Workflow Services Using External Data Exchange http://www.eggheadcafe.com/tutorials...vices-usi.aspx |
Thread Tools | |
Display Modes | |
|
|