How do I Apply the Microsoft Excel 2007 Analysis Toolpack Regression
Chart Bug Workaround?
There is a known issue in the Analysis ToolPak of Microsoft Excel 2007. The Regression tool in the Analysis
ToolPak in Excel 2007 does not display residual and line fit plots correctly. For more information on this problem
please see: http://itinfo.mit.edu/article.php?id=8494
This issue has been documented to Microsoft and a hotfix is currently being developed for release by the end of
September 2007. In the meantime, a work around has been implemented for users who need to use the
Regression Tool.
Step
Procedure
1
Once a regression analysis is run, users will only see one residual plot for the first column of data. Any additional
residual plots and all line fit plots will be missing (this is the bug; see picture below).
The workaround involves an Excel Add-In that has been installed on all Haas Terminal Servers. The workaround
installs a button called Fix Regression Charts which is located under the Data Analysis button on the Excel
2007 menu.
Computing Services
Haas School of Business
Page 1
Last Updated: 9/12/2007
University of California Berkeley
Created by MC
How Do I Apply the Microsoft Excel 2007 Analysis Toolpack Regression Chart Bug Workaround? (Continued)
Step
Procedure
Before running the workaround, you must save your workbook
Step
Procedure
3
Once you have saved your workbook, click the Fix Regression Charts button on the toolbar
Step
Procedure
4
The workaround will need to re-save your workbook in order to complete the fix. Click YES to save and continue.
If you click no to save, you will need to save your workbook manually, close the workbook, and reopen it in Excel
in order to complete the fix.
Computing Services
Haas School of Business
Page 2
Last Updated: 9/12/2007
University of California Berkeley
Created by MC
hael Chung
How Do I Apply the Microsoft Excel 2007 Analysis Toolpack Regression Chart Bug Workaround? (Continued)
Step
Procedure
5
The workbook now correctly shows all charts (see picture below).
Computing Services
Haas School of Business
Page 3
Last Updated: 9/12/2007
University of California Berkeley
Created by MC
hael Chung
