regression charts in data analysis

K

kourtney

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.
 
M

Mike Middleton

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Bug Report - chart redraw disintegrates - regression analysis outp 5
Regression - trend line vs. data points?? 1
Linking Excel charts in Powerpoint 0
Force charts to refresh? 2
One Chart, Same Data ranges, different source sheets 4
Cannot combine stock charts with other chart types in Excel 2007 1
Print Specific Charts 5
washed out charts 3

Top