Hi,

Andy. yes that is my mistake. Now i have corrected that error. But
again i got the same error as Unable to set the XValues property of
the Series class.("Run time error 1044"). Pls help me?

This time my coding is:

ActiveSheet.ChartObjects("Chart 1030").Activate
ActiveChart.ChartArea.Select
*ActiveChart.SeriesCollection(1).XValues =
"=MonthlyData!R2C1:R30C1"* ActiveChart.SeriesCollection(1).Values =
"=MonthlyData!R2C2:R30C2"
ActiveChart.SeriesCollection(2).XValues =
"=MonthlyData!R2C1:R30C1"
ActiveChart.SeriesCollection(3).XValues = "=MonthlyData!R2C1:R30C1"


--
ramkumar_cpt
------------------------------------------------------------------------
ramkumar_cpt's Profile: http://www.excelforum.com/member.php...o&userid=28673
View this thread: http://www.excelforum.com/showthread...hreadid=487902