Count charts on Worksheet

H

harm.charles

Hi,

I'm now having another problem with charts.
What is happening now is that when I copy a chart to another location
in the same worksheet the chart count goes up.
So if I copied the same chart 10 times the ChartObjects("Chart 10").
Now when I "Right click" the chart and select "Clear" this removes the
chart. I do this for all charts except for the original. I have my
program set to count the charts, which the sheet only has the
original but the code will count all charts that were created and
cleared.
Is there a way to count the actual number of charts in the worksheet
and not the ones that were cleared?

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I need to give index number to charts 3
Multiple selected charts 1
chart to email 3
paste 2 charts on the same image on a userform 2
Copying embedded charts 1
ChartObjects.Count is incorrect 10
Print problems w/ charts excel 2003/2007 3
to make column letter dynamic in charts 2

Top