Count series in chart
Hello
Can anyone tell me how to count (in vba) the series in a chart? |
Count series in chart
"SeriesCollection" object in help covers that. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "kaiser" wrote in message Hello Can anyone tell me how to count (in vba) the series in a chart? |
Count series in chart
On Jul 3, 9:57 pm, "Jim Cone" wrote:
"SeriesCollection" object in help covers that. -- Jim Cone San Francisco, USAhttp://www.realezsites.com/bus/primitivesoftware wrote in message Hello Can anyone tell me how tocount(in vba) theseriesin achart? I saw that but I am having troubles getting it to work. i = Worksheets("Data").ChartObjects("Chart 3").SeriesCollection.Count should work as far as I understand but it doesnt. note that the chart is imbedded in a sheet and not in its own sheet. Any thoughts? I get "Unable to get ChartsObject property of the Worksheet Class" Thanks |
Count series in chart
Hi,
You are missing a level in the object reference. i = Worksheets("Data").ChartObjects("Chart 3").CHART.SeriesCollection.Count Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "kaiser" wrote in message ups.com... On Jul 3, 9:57 pm, "Jim Cone" wrote: "SeriesCollection" object in help covers that. -- Jim Cone San Francisco, USAhttp://www.realezsites.com/bus/primitivesoftware wrote in message Hello Can anyone tell me how tocount(in vba) theseriesin achart? I saw that but I am having troubles getting it to work. i = Worksheets("Data").ChartObjects("Chart 3").SeriesCollection.Count should work as far as I understand but it doesnt. note that the chart is imbedded in a sheet and not in its own sheet. Any thoughts? I get "Unable to get ChartsObject property of the Worksheet Class" Thanks |
Count series in chart
On Jul 3, 10:36 pm, "Andy Pope" wrote:
Hi, You are missing a level in the object reference. i = Worksheets("Data").ChartObjects("Chart3").CHART.Se riesCollection.Count Cheers Andy -- Andy Pope, Microsoft MVP - Excelhttp://www.andypope.info"kaiser" wrote in message ups.com... On Jul 3, 9:57 pm, "Jim Cone" wrote: "SeriesCollection" object in help covers that. -- Jim Cone San Francisco, USAhttp://www.realezsites.com/bus/primitivesoftware wrote in message Hello Can anyone tell me how tocount(in vba) theseriesin achart? I saw that but I am having troubles getting it to work. i = Worksheets("Data").ChartObjects("Chart3").SeriesCo llection.Count should work as far as I understand but it doesnt. note that thechart is imbedded in a sheet and not in its own sheet. Any thoughts? I get "Unable to get ChartsObject property of the Worksheet Class" Thanks- Hide quoted text - - Show quoted text - Thanks - works |
All times are GMT +1. The time now is 07:17 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com