If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Unable to set the XValues property of the Series class
Hi,
Are you sure that was where the code failed. This line looks the more likely candidate. ActiveChart.SeriesCollection(1).Values = "=MonthlyData!R2C5:MonthlyData!R30C5" try changing the references to, ActiveChart.SeriesCollection(1).Values = "=MonthlyData!R2C5:R30C5" Cheers Andy ramkumar_cpt wrote: 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. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#3
|
|||
|
|||
Unable to set the XValues property of the Series class
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 |
#4
|
|||
|
|||
Unable to set the XValues property of the Series class
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 |
#5
|
|||
|
|||
Unable to set the XValues property of the Series class
Yes Andy. My cell has contains no value. it is empty. so what? -- 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 |
#6
|
|||
|
|||
Unable to set the XValues property of the Series class
As a test put some values in the empty cells and try your code. It
should work. Once you have established the problem is empty cells you can experiment by populating the first empty cell and seeing if the code still works. Then you need to update your code to check the status of empty cells and put something in them temporarily so your code runs. Then clear those cells when finished. Cheers Andy ramkumar_cpt wrote: Yes Andy. My cell has contains no value. it is empty. so what? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
SHARED SOLUTION: Horizontal lines on XY Scatter w/multiple series | LeAnne | Charts and Charting | 1 | November 15th, 2004 02:35 PM |
Error: Unable to set the Xvalues property of the series class | samir | Charts and Charting | 1 | November 12th, 2004 04:46 PM |
Is there a way to turn off the autonumber | Dave | Setting up and Configuration | 4 | October 23rd, 2004 02:43 PM |
error - unable to set the XValues property of the series class | vjp | Charts and Charting | 1 | October 22nd, 2004 03:56 AM |
My Schedule: Am I dreaming? | JEM | Charts and Charting | 0 | April 19th, 2004 05:44 AM |