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