Are you sure your code deletes old charts. Eg, deleting rows/cols they are
contained in doesn't delete them, just makes them miniscule to the extent of
making them invisible.

Charts excluding their data don't occupy much file size, just the properties
of the chart.

If I look at the properties of
the new charts, the chart number doesn't start with number 1 as I
expect it to do.

That's normal and of it's own would not impact on file size, the object
counter is only reset if all objects of any kind are removed from the sheet
then save - close - re-open.

Regards,
Peter T


"xyfix" wrote in message
oups.com...
I have a excel sheet on which I place 5 charts, through vb code. Every
time a button is pressed, the code removes all charts on the sheet and
creates new ones with new data. Although the number of charts stay the
same and nothing is added extra to the sheet, it increases everytime I
press the button. It looks to me like the charts are not removed, but
stuck on the background ( not visible). If I look at the properties of
the new charts, the chart number doesn't start with number 1 as I
expect it to do.