View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
xyfix xyfix is offline
external usenet poster
 
Posts: 10
Default Excel size increase through charts

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.