Bug Report - chart redraw disintegrates - regression analysis outp

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.




0
Andyroo (6)
2/5/2008 3:22:01 AM
excel.charting 18370 articles. 0 followers. Follow

5 Replies
566 Views

Similar Articles

[PageSpeed] 21

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

-- 

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Andyroo" <Andyroo@discussions.microsoft.com> wrote in message 
news:90977544-C3B3-463A-9710-9CCED4CF35E5@microsoft.com...
>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.
>
>
>
> 

0
andy9699 (3616)
2/5/2008 9:42:00 AM
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
_______


"Andy Pope" <andy@andypope.info> wrote in message 
news:B18629EA-A09D-4154-B299-E4283C872B3A@microsoft.com...
> 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
>
> -- 
>
> Andy Pope, Microsoft MVP - Excel
> http://www.andypope.info
> "Andyroo" <Andyroo@discussions.microsoft.com> wrote in message 
> news:90977544-C3B3-463A-9710-9CCED4CF35E5@microsoft.com...
>>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.
>>
>>
>>
>>
> 


0
jonxlmvpNO (4558)
2/5/2008 12:19:23 PM
Have you installed SP1?

Bob

"Andyroo" <Andyroo@discussions.microsoft.com> wrote in message 
news:90977544-C3B3-463A-9710-9CCED4CF35E5@microsoft.com...
>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.
>
>
>
> 


0
nospam2791 (369)
2/6/2008 3:12:54 AM
Doesn't matter.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Bob Flanagan" <nospam@nospam.net> wrote in message 
news:bJ6dnVW02O9YuDTanZ2dnUVZ_qKgnZ2d@comcast.com...
> Have you installed SP1?
>
> Bob
>
> "Andyroo" <Andyroo@discussions.microsoft.com> wrote in message 
> news:90977544-C3B3-463A-9710-9CCED4CF35E5@microsoft.com...
>>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.
>>
>>
>>
>>
>
> 


0
jonxlmvpNO (4558)
2/6/2008 1:10:32 PM
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.

"Andyroo" wrote:

> 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.
> 
> 
> 
> 
0
Andyroo (6)
4/17/2008 11:56:00 PM
Reply:

Similar Artilces:

SSRS upload new report getting error: Microsoft.Crm.CrmException
What is the deal with CRM 3.0 and adding new reports through CRM 3.0? I dont have a shared Data Source. I have set full permissions for <domain>/crm and nt service. Has anyone figured out why this is like this? Thanks, Jeff Below is the error from the trace log: AppReportsMenu.BuildReportsMenu at AppReportsMenu.BuildReportsMenu(Menu reportsMenu, ReportVisibility visibility, String clientId, Int32 objectTypeId) at AppFormMenuBar.BuildToolbar() at AppFormMenuBar.Execute(PrivilegeCheck privilegeCheck, String formName) at AppFormMenuBar.Execute(PrivilegeCheck privilegeCheck) at Oppor...

Change the width of a single column in a column chart
Greetings, Is there a way to change the width of a single column in a column chart? Even better, is there a way that I can make the width of that column correspond to the data in a column of my worksheet? Thanks, -Dave http://andypope.info/charts/colwidth.htm may help. "Dave" <nospam@yahoo.com> wrote in message news:e29rLbU4EHA.1452@TK2MSFTNGP11.phx.gbl... > Greetings, > > Is there a way to change the width of a single column in a column chart? > > Even better, is there a way that I can make the width of that column > correspond to the data in a colu...

No "Chart Option" feature in the Formatting Palette or when double click on Chart
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) I have read a discussion board concerning this issue but it was from 2008 and no solution was offered yet. The problem is as follows: one creates a graph but cannot add a title or format the axis etc. <br><br>When I open a new spreadsheet and enter the data, I can create the graph. However, I cannot select the &quot;Chart Option&quot; to change any specific features. On the formatting palette I only get the "Page Setup" options but nothing relating to the chart and when I double click on the graph t...

Problem with line Chart
I have the following data: Date Value 1/07 700 3/07 550 9/07 600 10/07 550 7/08 500 9/08 700 2/09 750 8/09 600 I would like to create a simple line chart connecting the Value points. Note that the points correspond to random dates (not evenly spaced). How can I create a line chart that has time on the x-axis, (say shown in months) with a line connecting the Value points, which are shown at various locations in time. Soun...

FRx Report Date won't change
We have a customer that has a GP Fiscal Year of 9073. Apparently, an AP transaction had accidentally been posted with a document date of 9073. So, in order to void that transaction, they created the fiscal year of 9073. Now, in FRx when they try to change the Report Date to December 2008, FRx changes the report date to December 9072. We've tried deleting the .g32 file and rebuilding the FRx GL Index. We've also tried deleting the SY40100 and SY40101 tables, rebuilding the Fiscal Periods in GP then rebuilding the FRx GL index but we still can use the 12/2008 date in FRx. Any...

chart frustrations
Good morning all. I'm trying to help my wife make a chart for a class she's taking, and it appears that it's been far too long since I did one. I'm using Excel 2007. I have a 3 point data set. There is a time element-- I want that set along the bottom, across the horizontal. There is a compound concentration element-- I want the concentration values in the vertical, at left. Then, my graph lines, should be the concetrations per time measure. Presently, my data on my excel sheet is organized as follows. Time 0 5 10 15 20 Conc.'s sample1 ...

Verticle line in an XY scatter chart
I am using Excel 2000 and creating an XY scatter chart. I can create a horizontal line easily enough, how can I place a verticle line or series in the chart in an exact location? I'm wanting to represent a verticle line at 4.5 points but of course creating a typical series produces horizontal data. Is there another way to represent this line vertically on my chart adding another series or otherwise? TIA George Hi George maybe the following link will help you http://peltiertech.com/Excel/Charts/AddLineVertSeries.html Though it describes vertical lines for column and line charts on...

Adding Lines And Boxes, etc. To A Chart ?
Hello, Will blame it on my age. Using Excel 2007 (or, at least trying to) and XP. When I have a chart page opened up, how do I get it to show the bar on the bottom (that the real old versions had) that allows one to click on one of its icons shown to "draw" lines, arrowed lines, boxes, add text with a box, etc on the chart itself ? Thanks, Bob Hi, With the chart selected you can use the Insert tab > Illustrations > Shapes. To add shapes to the chart. Textbox is in the Text group of the Insert tab. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypo...

My Report List Read Only
When I click on the properties of the home page for reports, when the list comes up of reports it tells me it is read-only. I am trying to add a smartlist to My Report. How do I get it to not be Read-Only so I can add Smartlists to My Reports? This is GP 10 SP3. Rich, What you need to do is this. On the Home Page, On your left hand side, You'd see Reports Shortcuts, expand it, you'll see My Reports. Right click it, then click Add, Select Smartlist and then add the report whatever you want to add by giving it a name you'd like to. That's it. -- Thanks Janakiram M.P. MCP...

Combination chart? Stacked cylinders and scatter
Hi, I want to make a stacked bar chart that also shows another data point as a single point along the stacked bar. Here is what I have so far '[img=http://img304.imageshack.us/img304/5372/chart7ur.th.jpg]' (http://img304.imageshack.us/my.php?image=chart7ur.jpg) Here is what I want to accomplish: - don't show Sections where Length is zero -- right now the zero sections show with label and value on the right side of the cylinders - show another data point (from another cell in my sheet) as a single point along the stacked bar - show a final data point as the total of the bar len...

Chart Type HELP!
Hi, I still need help on the Chart Type thread that I posted a couple of hours ago under "Chart Type". It is URGENT--for a presentation for which I am already late!! Anybody?? Tx, Sat Hi Sat - Take a look at what I just posted and see if it helps. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL2K & XLXP ---------------------------------------------------------------------------- Attitude - A little thing that makes a BIG difference ----------------------------------------------------------------------...

resize a chart using keyboard after pasting
Blind person needs to resize chart after copy and paste into another sheet. ...

Problems with Crystal Reports
Hi everyone We are currently encountering a problem with Crystal Reports on MSCRM. Launching one takes about 10-15 seconds before data is displayed (even if only 1 record is retrieved). The standard Accounts reports are worse, we get a Timed Out error everytime. We are deploying MSCRM on 2 servers - CRM Server has dual procs and 1GB RAM. Any suggestions are very much appreciated. Thanks in advance. Regards. Hon Having Crystal reports in CRM 1.0 timeout is a known bug. (Happens after you try to retrieve more than about 10K records.) There is a private hotfix. It will also be fi...

Store Manager Label Wizard has a bug
When we reprint labels using the Label Wizard, it does not print all the fields. Item Details 1, 2 and 3 are missing. If labels are printed from the Items...Find...Labels route, everthing prints correctly. Is there a patch for this? ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in th...

(?) Free credit report and monitoring from Experian?
How do I get the free "credit report and monitoring from Experian" offered with Money Deluxe 2004? When I click, I'm sent to https://msmoney.creditexpert.com/CE_site/MCCLogin_C.aspx , but I see no-where to create a new account. Queries to customerservice@creditexpert.com have not been answered. Thanks, -stephen Do a little search at the Consumer Reports site and you will find the addresses and email addresses of the 3 credit reporting agencies. I believe they are required to send you a free report once per-year. You can research the referenced CR reports at your local libra...

Charting Data That can grow
i have a graph that uses data generated by access, but the problem i have is that the graph is setup using a XLT. i am capturing data by week, so each week that my graph is generated it will included more data how do i set it up so that the graph is adjusted accordingly. i was pointed to the following page but really dont understand it. http://tinyurl.com/2bqhk i have had a look and aint got a clue, what that meant..... my sheet containing the data is claaed: DATA and my sheet layout is as follows: [image: http://members.lycos.co.uk/redtilefc/1.jpg] i have looked at the calculation...

Rounding Averages on my Report
I created a summary report using the report wizard and grouped by date and selected avg. The report works fine except I would the numbers to be rounded. For example: The average for January shows 19.5, however I would like it displayed as 20. If February is 23.1678993, I would like it displayed as 23. Can someone help me with this? Thx Try... = Format([YourAvg], "#") 19.5 should display as 20 (rounding up from .5 or greater) 23.1678993 should display as 23 (rounding down from .5 or less) or... if you need numeric... ...

Report only prints 6 pages
I find I am unable to create a report that will print more than 6 pages. AND, if I shorten the detail area (bring the footer up close to the detail), it will print even fewer pages. I have created a new, empty database. I have created one table, with a first and last name as columns. I have entered 11 rows in that table. I have made a report with a record source that selects all of the rows in that table - no criteria - nothing fancy. If I put the first_name and last_name in the page in the Page Header section, the report will print from 2 to 6 of the rows, depending on how much spac...

Adding a line to the line/column chart?
Is there anyway I can add a second line to the line/column chart? Basically I have 3 sets of data that I want to plot vs. time on the same graph. 1 using the column format, the other 2 being lines connected by data points. Create the chart using all the data, right click on the one you want to change to a line and select chart type from the dialogue box and choose the type you want. There are a few restrictions on the mix you can have though. -- John MOS Master Instructor Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "Steven"...

Help with assignment of values to controls on report
I am trying to assign value on a txtbox control from a form to a txtbox control on a report. Form txtbox control:txtBeginDateRange Report txtbox control:txtStartDate reportName = "Report by DR and Vendor" I am have a problem with this line of code Reports![reportName]!txtStartDate = Me.txtBeginDateRange DoCmd.OpenReport reportName, acViewPreview Any help will be appreciated. Thank you. Ayo. You cannot assign a value to a text box on a report like that. Instead, set the Control Source of the text box on the report so it reads from the form, e.g.: =Forms!Form1!txtBegin...

Avoiding empty cells showing as zero in line chart without na()
I'm using a line graph to show trends in a multi-question questionnaire. Like many else (I've done a lot of searching but haven't found a suitable solution) my line graph jumps to zero for the empty cells (currently defined as ""). I understand I could just change this to na() instead but then my average() calculation stops working. I have a lot of data so making two separate data-series is not feasible. Can anyone help me with a suggestion here? Thanks! It's not feasible to have parallel data ranges? It's more feasible to spend lots of time trying to workarou...

How do I create a stacked column/line chart combination?
I am trying to format a line/stacked column combination chart. I want to show the delay on each of several machines as a stacked column, and then I want to show a line representing the goal for the down time, the goal being a set value, so the line will be straight across. Simples way is to plot all the data, stacked columns plus one series for the horizontal line, as a stacked column chart. Select the series that should be the line, choose Chart Type on the Chart menu, and pick out a line chart style. A bit more involved is to add a line using an XY series of two points, or an XY s...

Printing charts on multiple pages
Hi there, I've just made my first chart. There is a lot of data in it and as a result it is very long. When I do a print preview it is all on one page and I need it to be over 4 pages for it to be readable. I've tried making it into 4 individual charts but them you have to chose each one and print them individually. I've also tried pasting it into a "Chart Worksheet" but it still will only print on one page. I've also tried to play around with the page layout. Is there any way to set this up so that it will print over a number of pages? Thanks in advance for...

Using VBA to manipulate Reporting
Hello, I have a handful of reports that I am trying to manipulate using VBA. Depending on whatever they choose in a "currency" dropdown will determine what data the report will be showing. This is my question. Is there a way through VBA, depending on the value chosen in the pull down on the main form, to bring up a report but manipulate it so it looks at a certain query, changes its grouping levels, etc based on that choice in the dropdown? This would save me a TON of work, so I don't have to create new reports looking at different queries and have to put grouping lev...

Chart: Point & Figures
Hi, I want to automate the drawing of Point & Figures Charts based on a simple pricelist that contains 2 rows; Date and price. Does anyyone know of any useful functionality in Excel, Add-Ins, shareware or anything else that I can use for this purpose? Thanks in advance. Hi, I have a page here that may help. http://www.andypope.info/ngs/ng8.htm Cheers Andy johannes wrote: > Hi, > > I want to automate the drawing of Point & Figures Charts > based on a simple pricelist that contains 2 rows; Date and > price. Does anyyone know of any useful functionality in...