MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Add Method Series Collection class failed

Posted by Tom Shoemaker on November 28, 2000 3:24 PM


Could someone please help for the proper format of this seriescollection.add

Sub test3()
Sheets("MICAP & NMCS").Select
ActiveSheet.ChartObjects("Chart 4").Activate
ActiveChart.SeriesCollection.Add Source:=Sheets("MICAP & NMCS").Range("U6:AF6"), SeriesLabels:=Sheets("MICAP & NMCS").Range("U6:AF6"), CategoryLabels:=Sheets("MICAP & NMCS").Range("U4:AF4"), Replace:=Sheets("MICAP & NMCS").Range("U6:AF6")

End Sub

Posted by Tim Francis-Wright on November 28, 2000 9:06 PM

I think that the replace element should be either True or False--
that's probably causing the error.