 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / April 2007Charts generated by Data Analysis/Regression Add-in
I've tried this on three different Excel 2007 installations in both 2003 and 2007 file formats: When I run a regression model on a set of data, the charts generated by the Add-in cannot be moved, resized, etc. without the chart literally "falling apart". Specifically, the Residual Plots, Line Fit Plots, and Normal Probability Plots. When I click on a chart to resize or drag it, parts of the chart move properly while other parts are left behind... Are they real charts, or collections of shapes that look like charts, and what you're doing is dragging around a subset of these shapes? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ > I've tried this on three different Excel 2007 installations in both > 2003 and 2007 file formats: [quoted text clipped - 5 lines] > or drag it, parts of the chart move properly while other parts are > left behind... On Feb 13, 1:36 pm, "Jon Peltier" <jonxlmv...@SPAMpeltiertech.com> wrote: > Are they real charts, or collections of shapes that look like charts, and > what you're doing is dragging around a subset of these shapes? [quoted text clipped - 20 lines] > > - Show quoted text - They act more like an ungrouped set of objects than the charts produced by the Analysis Toolpak in Excel 2003. Also, all the charts I've created by hand work as expected. Thanks, Jay >On Feb 13, 1:36 pm, "Jon Peltier" <jonxlmv...@SPAMpeltiertech.com> >wrote: >> Are they real charts, or collections of shapes that look like charts, and >> what you're doing is dragging around a subset of these shapes? (snip) >> > I've tried this on three different Excel 2007 installations in both >> > 2003 and 2007 file formats: [quoted text clipped - 11 lines] >produced by the Analysis Toolpak in Excel 2003. Also, all the charts >I've created by hand work as expected. Can you perhaps select all the objects and group them somehow ? That might fix the problem. On Feb 13, 7:16 pm, bruce.sincl...@NOSPAMORELSEagresearch.NOTco.NOTnz > In article <1171400789.271059.137...@m58g2000cwm.googlegroups.com>, pokor...@gmail.com wrote: > >On Feb 13, 1:36 pm, "Jon Peltier" <jonxlmv...@SPAMpeltiertech.com> [quoted text clipped - 22 lines] > > - Show quoted text - No luck there either. I can grab and move what seems to be a "layer" containing the data points and some parts of the graphs, but lables, legend, axis data, border...all left behind. Interesting - when I move what I can and start clicking about the graph, parts start to reappear. Other bugs with the Regression utility: Though I select line fit plot, I don't get one. The Normal Probability Plot is shown as a bar chart, not a scatter plot. I wonder if the Analysis Toolkit was simply not updated to work with Excel 2007...although everything else seems to have changed, this and Solver both look identical to 2003. Jay Jay pokorski - I observe the same behavior in the Regression tool of Excel 2007 Trial. After I move (click and drag) a chart, observe that only parts have moved, click somewhere on the moved chart so that the other parts reappear, and save the chart, all seems well. Before saving, the ghosts of some of the unmoved parts stay in their original locations. The "Line Fit Plot" appears originally as a Column chart type, but when I change it to an XY (Scatter) chart type, it's the same as the 2003-and-prior versions. The Residual Plot does appear originally as an XY (Scatter) chart type. The Normal Probability Plot has never been implemented properly in any version of Excel, and it continues to be of no use. I use the Regression tool extensively when I teach undergraduate, MBA, and Exec MBA students. I already have some students who have bought a new computer with Windows Vista and Office 2007. I am hoping that "service release 1" for Office 2007 appears soon, so I can avoid providing a lot of additional instructions and problem solving. - Mike http://www.mikemiddleton.com > I've tried this on three different Excel 2007 installations in both > 2003 and 2007 file formats: [quoted text clipped - 5 lines] > or drag it, parts of the chart move properly while other parts are > left behind... I am experiencing the same problem when running regression in excel 2007. Does anyone know if there is a way to get around this problem? Is it possible to create a scatter plot & line of best fit graph manually given the outputs that excel provides after running the regression? I am in required to have a scatter plot with a line of best fit as outputs for the regressions I am running for a school assignment and prefer not to have to use an earlier version of excel to complete what I have already started in 2007. Any input is much appreciated. Thanks, Lorne Lorne - Here are some workarounds for the Excel 2007 original release Regression charts. In the Regression dialog box, check the boxes for Residual Plots and Line Fit Plots. After Excel creates the output, click just inside the outer border of a chart to select it and then drag it to a new location. Then click and drag one of the eight resizing handles on the outer border of the chart. Any resizing will redraw the chart correctly. The Residual Plot chart is an appropriate XY (Scatter) chart type. The Line Fit Plot is originally created as a Column chart type. To change it, click just inside its outer border to select the chart. Choose Chart Tools | Design | Change Chart Type | XY (Scatter) with only Markers | OK. Click a data point on the chart to select the Predicted Y data series, or with any chart object selected, choose Chart Tools | Layout or Format. In the Current Selection area, verify that Series "Predicted Y" is selected from the drop-down list. Choose Format Selection | Line Color | Automatic | Close. Optionally, also choose Market Options to use a smaller marker instead of size 7 or to use None. Please let me know whether these workarounds are satisfactory for you. - Mike http://www.mikemiddleton.com >I am experiencing the same problem when running regression in excel > 2007. [quoted text clipped - 14 lines] > > Lorne
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.