Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Count charts on Worksheet
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Count charts on Worksheet
cntChtObjs = Activesheet.Chartobjects.Count
Regards, Peter T wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Count charts on Worksheet
On Aug 7, 3:36 pm, "Peter T" <peter_t@discussions wrote:
cntChtObjs = Activesheet.Chartobjects.Count Regards, Peter T wrote in message ... 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 Peter T Thanks it works. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can you tile 8 charts on a worksheet? | Charts and Charting in Excel | |||
How do I place two or more charts on a worksheet? | Charts and Charting in Excel | |||
Count of Worksheet rows and recording this count | Excel Programming | |||
TIP: Worksheets vs. Sheets (w/Charts) Count | Excel Programming | |||
Printing charts from one worksheet | Excel Discussion (Misc queries) |