Archive of Mr Excel Message Board

Back to General Excel archive index
Back to archive home

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()
Windows("test.xls").Activate
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

Re: Add Method Series Collection class failed

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.

HTH

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.