Does your range contain empty cells?
ramkumar_cpt wrote:
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"
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info