hide a series in a chart

01-18-2005, 11:07 AM
Worksheets("Sheet3").ChartObjects("Chart 1").ProtectChartObject = True
ActiveSheet.ChartObjects("Chart 1").Activate
ActiveChart.SeriesCollection(1).ChartType = xlLine

ActiveChart.Plot.SeriesCollection(2).Position.Hidden = True

I tried the above code for hiding Series 2 taking the hint from the following solution suggested for a similar query. perhaps i understood it wrong!

With MSChart1.Plot
For i=1 To MSChart1.ColumnCount
End With

But i get an error method or data member not found. even when i remove the plot method it doesn't work..pls help.. :(

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum