ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   regression charts in data analysis (https://www.excelbanter.com/charts-charting-excel/176748-regression-charts-data-analysis.html)

kourtney

regression charts in data analysis
 

I am new to excel 2007. I have installed the add in for
data analysis. I want to do a regression output with
charts based on the dependent variable(y) and the independent variable(x).
I have clicked on all the right boxes I need.
The problem is I am only able to do 1 chart and I have 3 variable so I should
have 3 charts. I am able to do this in 2003 and can't do it in 2007.
I need help in doing these charts. Please help.

Mike Middleton

regression charts in data analysis
 
kourtney -

I observe similar behavior in Excel 2007 SP1.

The numerical results of the Regression tool seem to be OK.

So, as a workaround, you could create the charts yourself, using the data
ranges that the Regression tool provides.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel



"kourtney" wrote in message
...

I am new to excel 2007. I have installed the add in for
data analysis. I want to do a regression output with
charts based on the dependent variable(y) and the independent variable(x).
I have clicked on all the right boxes I need.
The problem is I am only able to do 1 chart and I have 3 variable so I
should
have 3 charts. I am able to do this in 2003 and can't do it in 2007.
I need help in doing these charts. Please help.





All times are GMT +1. The time now is 12:44 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com