I just installed Office 2007Ultimate. Was working on regression analysis and
the first time I tried generating regression analysis I got weird problems
with the autogenerated charts. I can duplicate with the following actions:
1. open excel/new worksheet.
2. enter 1-10 in column A, rows 1-10
3. enter a formula like =a1*2 in cell b1 and drag to b10
4 Data/Data Analysis/Regression
Y range = $A$1:$A$10
X range = $B$1:$B$10
-new worksheet ply (selected by default on mine)
-check every checkbox for residuals and probability
click <OK>
5. move a chart on the new worksheet ply (drag the normal probability chart
down)
On my installation, every time I do this, the text "stays" where the chart
was, while the box and the bar graph move to where I drag the chart. but the
"text" that stayed is not selectable, and the chart redrawing becomes
sporadic and unpredictable, and the text appears on the newly moved chart if
I click on where it should be. sometimes. Basically the whole screen
redrawing feature falls apart until I save and reopen the file. Then the
chart behaves normally.
Andy Pope - 05 Feb 2008 09:42 GMT
Hi,
Just confirming I can reproduce the problem.
How many charts do you see on the new sheet? Can you see the '1 Line Fit
Plot'?
Cheers
Andy

Signature
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
>I just installed Office 2007Ultimate. Was working on regression analysis
>and
[quoted text clipped - 23 lines]
> redrawing feature falls apart until I save and reopen the file. Then the
> chart behaves normally.
Jon Peltier - 05 Feb 2008 12:19 GMT
I also duplicated it. Noteworthy might be the two warnings I got that said
"Can't empty clipboard". When I saved the workbook, (save as) the text
elements and chart area frame caught up with the chart, but they were still
decoupled. Subsequent saves did nothing, but save as again temporarily
caught up the stray elements to the chart. When I close the workbook I got
two warnings that I had no printers installed.
This is bizarre, I haven't seen stuff like this since well before the
release.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______
> Hi,
>
[quoted text clipped - 35 lines]
>> redrawing feature falls apart until I save and reopen the file. Then the
>> chart behaves normally.
Bob Flanagan - 06 Feb 2008 03:12 GMT
Have you installed SP1?
Bob
>I just installed Office 2007Ultimate. Was working on regression analysis
>and
[quoted text clipped - 23 lines]
> redrawing feature falls apart until I save and reopen the file. Then the
> chart behaves normally.
Jon Peltier - 06 Feb 2008 13:10 GMT
Doesn't matter.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______
> Have you installed SP1?
>
[quoted text clipped - 30 lines]
>> redrawing feature falls apart until I save and reopen the file. Then the
>> chart behaves normally.
Andyroo - 18 Apr 2008 00:56 GMT
I reduced the frequency and severity of chart redrawing problems by running a
repair installation:
Office Button/Excel Options/Resources/Diagnose
After the diagnosis I got a notification that repairs were made (sorry I
don't remember exact message) and chart drawing, while still not super
reliable, is improved. I am disappointed with the reduced efficiency in
changing chart settings.
> I just installed Office 2007Ultimate. Was working on regression analysis and
> the first time I tried generating regression analysis I got weird problems
[quoted text clipped - 19 lines]
> redrawing feature falls apart until I save and reopen the file. Then the
> chart behaves normally.