Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 762
Default 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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do i graph a regression analysis? Brad Excel Discussion (Misc queries) 1 September 29th 07 12:01 AM
Charts generated by Data Analysis/Regression Add-in [email protected] Charts and Charting in Excel 7 April 3rd 07 11:29 PM
Using Regression Analysis? ccpalm2 New Users to Excel 1 February 21st 07 10:03 AM
Recalculating a Regression Output in Data Analysis karin Excel Worksheet Functions 1 August 23rd 05 03:40 AM


All times are GMT +1. The time now is 12:20 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"