| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Series
How can I count the number of data series in an individual chart using VBA? Thanks
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Data Series
Bill
ActiveChart.SeriesCollection.Count You can replace ActiveChart with any valid chart object. HTH, Bernie MS Excel MVP "Bill" wrote in message ... How can I count the number of data series in an individual chart using VBA? Thanks |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Data Series
I have tried that before and I tried it again. However it says "Count method of SeriesCollection class failed". Any more ideas
----- Bernie Deitrick wrote: ---- Bil ActiveChart.SeriesCollection.Coun You can replace ActiveChart with any valid chart object HTH Berni MS Excel MV "Bill" wrote in messag .. How can I count the number of data series in an individual chart usin VBA? Thank |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Data Series
Bill,
A lot of chart stuff only works on on a selected chart: try selecting the chart first. For a test, select a chart (click on it so that its handles show), then run this Sub Test() Msgbox ActiveChart.SeriesCollection.Count End Sub HTH, Bernie "Bill" wrote in message ... I have tried that before and I tried it again. However it says "Count method of SeriesCollection class failed". Any more ideas? ----- Bernie Deitrick wrote: ----- Bill ActiveChart.SeriesCollection.Count You can replace ActiveChart with any valid chart object. HTH, Bernie MS Excel MVP "Bill" wrote in message ... How can I count the number of data series in an individual chart using VBA? Thanks |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Data Series
That works and I have subsequently solved the problem. thanks
----- Bernie Deitrick wrote: ----- Bill, A lot of chart stuff only works on on a selected chart: try selecting the chart first. For a test, select a chart (click on it so that its handles show), then run this Sub Test() Msgbox ActiveChart.SeriesCollection.Count End Sub HTH, Bernie "Bill" wrote in message ... I have tried that before and I tried it again. However it says "Count method of SeriesCollection class failed". Any more ideas? ----- Bernie Deitrick wrote: ----- Bill ActiveChart.SeriesCollection.Count You can replace ActiveChart with any valid chart object. HTH, Bernie MS Excel MVP "Bill" wrote in message ... How can I count the number of data series in an individual chart using VBA? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Time Series and Creating data points within a series | Excel Discussion (Misc queries) | |||
| chart with two data series and two colors for each data series | Charts and Charting in Excel | |||
| 2nd Axes - primary series data of only 1 series disappears! | Charts and Charting in Excel | |||
| how do I plot a data series against two series | Charts and Charting in Excel | |||
| chart data series -- plot a table as a single series | Charts and Charting in Excel | |||
Hybrid Mode
