Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Unable to set the XValues property of the Series class
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
DisplayGridlines should be a property of Worksheet class, not Wind | Excel Discussion (Misc queries) | |||
VBA error: Unable to set the Values property of the Series class | Charts and Charting in Excel | |||
Problem adding Series XValues to Chart using VBA | Charts and Charting in Excel | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
"Unable to get the NormSInv property of the WorksheetFunction clas | Excel Worksheet Functions |