Results 1 to 13 of 13
  1. #1
    Lounger
    Join Date
    Jan 2003
    Posts
    38
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Charts, Pictures, and CPU Usage (XL2k)

    In the samples workbook I've got two sheets, sheet1 has a table, sheet2 has a chart. I need to insert a picture of the table in sheet1 onto the chart in sheet2. When I initially set it up everything looks ok. After I close it and reopen it Excel will use 100% of CPU resources. Rarely I have to change a value in the pictured table to set this off.

    This happens on different machines with different OSs and processors, regardless of the patch level of Excel.

    Any ideas on why the heck this is happening?

    Thanks,

    Dan
    Attached Files Attached Files

  2. #2
    5 Star Lounger
    Join Date
    Jul 2002
    Location
    Toronto, Ontario, Canada
    Posts
    1,139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Charts, Pictures, and CPU Usage (XL2k)

    Dan,

    From what I can tell (XL2K on WIn2K) the chart or picture is continually refreshed / redrawn because of the picture inserted into the chart.

    If paste the image ON TOP (select a cell, A1 for example, and paste the image, then move the image on top of the chart) of the chart instead of IN then chart then the CPU utilization drops to a more normal level.
    --
    Bryan Carbonnell - Toronto <img src=/S/flags/Ontario.gif border=0 alt=Ontario width=30 height=18> <img src=/S/flags/Canada.gif border=0 alt=Canada width=30 height=18>
    Unfortunately common sense isn't so common!!
    Visit my website for useful Word, Excel and Access code, templates and Add-Ins

  3. #3
    Lounger
    Join Date
    Jan 2003
    Posts
    38
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Charts, Pictures, and CPU Usage (XL2k)

    Hi, Bryan,

    True, this problem is only happening when the picture is inserted in the char, but, sadly, that's what I need to do. I'm infering that you're seeing the abnormal cpu utilization, too.

    Is anyone else seeing this?
    I can't believe that this is the way it's supposed to work.

    Thanks,

    Dan

  4. #4
    5 Star Lounger
    Join Date
    Jul 2002
    Location
    Toronto, Ontario, Canada
    Posts
    1,139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Charts, Pictures, and CPU Usage (XL2k)

    Yes, I am seeing the high CPU utilization 97-99% usage.

    Why do you need to place the image IN the chart? Why not just put it on top of the chart?

    Maybe if you can let us know why, we may be able to give you some work arounds.
    --
    Bryan Carbonnell - Toronto <img src=/S/flags/Ontario.gif border=0 alt=Ontario width=30 height=18> <img src=/S/flags/Canada.gif border=0 alt=Canada width=30 height=18>
    Unfortunately common sense isn't so common!!
    Visit my website for useful Word, Excel and Access code, templates and Add-Ins

  5. #5
    Lounger
    Join Date
    Jan 2003
    Posts
    38
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Charts, Pictures, and CPU Usage (XL2k)

    I'm putting it in the chart so it will print when I print the chart separate from the sheet. And so that it will move with the chart, etc.

    Thanks,

    Dan

  6. #6
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Charts, Pictures, and CPU Usage (XL2k)

    Why don't you place the chart on a Chart sheet?
    Right click on chart - location - new sheet

    Steve

  7. #7
    Lounger
    Join Date
    Jan 2003
    Posts
    38
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Charts, Pictures, and CPU Usage (XL2k)

    Hey! How come no one ever told me aobut this Chart Sheet stuff before? !! !!

    This is much better.

    Thanks, Bryon.
    Thanks, Steve.

    Dan

  8. #8
    Lounger
    Join Date
    Jan 2003
    Posts
    38
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Charts, Pictures, and CPU Usage (XL2k)

    Darn, I spoke too soon. The problem occurs evan in a chart sheet.

    Sorry, any more ideas, anyone?

    Thanks,

    Dan

  9. #9
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Charts, Pictures, and CPU Usage (XL2k)

    Works fine on a chart sheet for me, no "flickering".

    Try rebuilding the chart from scratch.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  10. #10
    Lounger
    Join Date
    Jan 2003
    Posts
    38
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Charts, Pictures, and CPU Usage (XL2k)

    Jan,

    I've recreated this stuff several times. It seems to become a problem after I save and reopen the workbook and if I have multiple charts on the same chart sheet.

    Dan

  11. #11
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Charts, Pictures, and CPU Usage (XL2k)

    Oh well, it was worth the try.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  12. #12
    5 Star Lounger
    Join Date
    Jul 2002
    Location
    Toronto, Ontario, Canada
    Posts
    1,139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Charts, Pictures, and CPU Usage (XL2k)

    Dan,

    I just tried placing the Chart on a chart sheet and the CPU usage for me dropped right back down to normal.

    Here is how I did it:

    Cut the image from the chart. Placed the chart on a new chart sheet (Right Click on the Chart, Select Location, Select As New Sheet called Chart1). Then I did an Edit|Paste to paste the image onto the chart.

    Right now I have the Worksheet reopened after saving it, and when Excel is the App in the foreground it is using only 2% of the CPU cycles.

    This is Excel 2K SP-1 running on Win2K SP2.

    I'm not sure why you are still seeing such high CPU usage.

    Sorry I can't be of more help.
    --
    Bryan Carbonnell - Toronto <img src=/S/flags/Ontario.gif border=0 alt=Ontario width=30 height=18> <img src=/S/flags/Canada.gif border=0 alt=Canada width=30 height=18>
    Unfortunately common sense isn't so common!!
    Visit my website for useful Word, Excel and Access code, templates and Add-Ins

  13. #13
    Lounger
    Join Date
    Jan 2003
    Posts
    38
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Charts, Pictures, and CPU Usage (XL2k)

    I'm not sure but it seems that if the picture is inserted in the chart it caused the usage problem. If it just resides in the same chart sheet with the chart there is no problem.

    Thanks for the help, one and all.

    Dan

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •