Hi


I have one sheet. It contains some charts. I want to put the
XValues use macro. But I am unable to run this macro. I got error as
Unable to set the XValues property of the Series class.("Run time error
1044"). Anybody can help me?

My macro code is:

ActiveWindow.Visible = False
Windows("FullTemplate.xls").Activate
Range("I22").Select
ActiveSheet.ChartObjects("Chart 1031").Activate
ActiveChart.ChartArea.Select
*ActiveChart.SeriesCollection(1).XValues =
Worksheets("MonthlyData").Range("B2:B5")*
ActiveChart.SeriesCollection(1).Values =
"=MonthlyData!R2C5:MonthlyData!R30C5"


Note: I am using Line chart. Pls help me.



Thanks in advance.

Ram.


--
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