| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why does Regression tool in '07 not display Line Fit Plots correct
Hi,
I noticed that if you run the Regression tool in the Analysis Toolpak in Excel 2007 and check "Line Fit Plots" checkbox, that you get a column chart as a result...However, if you do the same thing in Excel 2003 you do get the correct Line chart. Is there a flaw in Excel 2007 for this output? Any insight? Thank you!! Craig |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Why does Regression tool in '07 not display Line Fit Plots correct
Craig -
Yes, it's a reproducible bug in Excel 2007 SP1. To fix the line fit plot, select the chart, choose Chart Tools | Design | Change Chart Type, and select one of the XY (Scatter) chart types. - Mike Middleton http://www.DecisionToolworks.com Decision Analysis Add-ins for Excel "Craig" wrote in message ... Hi, I noticed that if you run the Regression tool in the Analysis Toolpak in Excel 2007 and check "Line Fit Plots" checkbox, that you get a column chart as a result...However, if you do the same thing in Excel 2003 you do get the correct Line chart. Is there a flaw in Excel 2007 for this output? Any insight? Thank you!! Craig |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dual Y Axis in Line Plots | Excel Discussion (Misc queries) | |||
| Problem with Regression function in 2007, Analysis Tool Pak | Excel Discussion (Misc queries) | |||
| The multiple regression tool - linear or non-linear regression? | Excel Discussion (Misc queries) | |||
| Regression Residual Plots | Excel Discussion (Misc queries) | |||
| Excel gives me line plots - I want scatter plots | Charts and Charting in Excel | |||
Linear Mode
