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

Cannot see and gantt charts or other displays 0
Doughnut Chart linked with the slicer in the pivot table 0
Move Chart with Text 0
Changing defauls in 2019 0
Regression - trend line vs. data points?? 1
Bug Report - chart redraw disintegrates - regression analysis outp 5
Creating a Search using a combo box and then creating a report. 4
Regression Analysis on Excel 2

Top