Re: Memory Leak when copying Excel Charts to another worksheet

From: Jon Peltier (DOjonNOTxlmvp_at_SPAMpeltiertechME.com)
Date: 08/17/04 

Date: Tue, 17 Aug 2004 19:29:52 -0400

Claus -

That's a lot of charts. Is it possible to show your data with fewer
charts? Perhaps a dynamic chart that you can control with a drop down or
other worksheet control. Or dividing it into multiple workbooks.

Here are a few examples of charting with worksheet controls to specify
what's charted:

   http://peltiertech.com/Excel/Charts/ChartByControl.html
   http://peltiertech.com/Excel/Charts/ChartTypeDropDown.html

In effect, the control is used to easily redefine a dynamic range on the
fly, so it displays the selected subset of the data.

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

Claus Zimmermann wrote:

> Hi
>
> I have a BAD memory leak when I copy a chart... even a blank chart to
> another worksheet. It eventually causes excel to crash.
>
> In my example, the sequence to crash excel was as follows:
> - Copy Chart 5000 times (loop) - less times would work too, and you'd
> see the increase in private bytes as you go along
> - Copy method of range class failed
> - Clicked End button on debug message box
> - Closed Excel
> - Message: The picture is too large and will be truncated
> - Excel.exe - Application error. The instruction at "0x300dc756"
> referenced memory at "0x000000008". The memory could not be read.
>
> I'm using Excel 2000 sp3
>
> To test memory I'm using perfmon, and am testing private bytes in Excel.
>
> Any suggestions or a workaround?
>
> Sample macro available illustrating this on request.
>
> Claus
>
>
>
>
>

Relevant Pages

  • Re: ActiveX control with chart
    ... Last year I installed a third party ActiveX chart control, ... Interestingly, as soon as I ran something from the VB Editor, Excel ...
    (microsoft.public.excel.charting)
  • Re: ActiveX control with chart
    ... they behave similar to Excel charts. ... The strange thing I found is that chart objects have a method ... > Last year I installed a third party ActiveX chart control, ... > Interestingly, as soon as I ran something from the VB Editor, Excel ...
    (microsoft.public.excel.charting)
  • Re: Excel 2007Chart updating problem
    ... Indeed odd in Excel 2003 that for you the chart updates with the Forms ... control but not for me. ... while the mouse button without releasing the mouse. ...
    (microsoft.public.excel.programming)
  • Re: pasting excel chart into word
    ... In Excel, don't just click the chart so you see little squares around it. ... Instead, hold down control and click it, so you see little circles. ... Downloads | Office-Update and let the system tell you whether your Office ...
    (microsoft.public.word.docmanagement)
  • Re: Can you dynamically expand the time range to the series data added
    ... is ignored by the chart engine. ... You could use conditional formatting to ... A dynamic chart ... search with Create an Excel List ...
    (microsoft.public.excel.charting)