Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unable to set the xvalues property of the series class for a single row of source data
Hello All,
The following code works if there is more than one row of source data. ActiveChart.SeriesCollection(1).XValues = "='" & ws.Name & "'! R2C3:R" & LastRow + 1 & "C3" ActiveChart.SeriesCollection(1).Values = "='" & ws.Name & "'! R2C4:R" & LastRow + 1 & "C4" ActiveChart.SeriesCollection(1).Name = "='" & ws.Name & "'! R1C4" ActiveChart.SeriesCollection(2).XValues = "='" & ws.Name & "'! R2C3:R" & LastRow + 1 & "C3" ActiveChart.SeriesCollection(2).Values = "='" & ws.Name & "'! R2C5:R" & LastRow + 1 & "C5" ActiveChart.SeriesCollection(2).Name = "='" & ws.Name & "'! R1C5" ActiveChart.SeriesCollection(3).XValues = "='" & ws.Name & "'! R2C3:R" & LastRow + 1 & "C3" ActiveChart.SeriesCollection(3).Values = "='" & ws.Name & "'! R2C6:R" & LastRow + 1 & "C6" ActiveChart.SeriesCollection(3).Name = "='" & ws.Name & "'! R1C6" Otherwise (if LastRow = 1), the following line ActiveChart.SeriesCollection(3).XValues = "='" & ws.Name & "'!R2C3:R" & LastRow + 1 & "C3" gives the following error Unable to set the xvalues property of the series class I am able to set the xvalues property for both SeriesCollection(1) and SeriesCollection(2) to the same range that I am attempting to set SeriesCollection(3)'s to. The range is non-empty and contains less than 253 cells. Any ideas as to what may be causing this? I appreciate any effort to help me. Thank you for your time and consideration. Sincerely, Sisilla |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unable to set the xvalues property of the series class for a singl
Enclose the code in an If statement:
If LastRow 1 Then 'Your code Else 'Put in new line to process single line of source data End If "Sisilla" wrote: Hello All, The following code works if there is more than one row of source data. ActiveChart.SeriesCollection(1).XValues = "='" & ws.Name & "'! R2C3:R" & LastRow + 1 & "C3" ActiveChart.SeriesCollection(1).Values = "='" & ws.Name & "'! R2C4:R" & LastRow + 1 & "C4" ActiveChart.SeriesCollection(1).Name = "='" & ws.Name & "'! R1C4" ActiveChart.SeriesCollection(2).XValues = "='" & ws.Name & "'! R2C3:R" & LastRow + 1 & "C3" ActiveChart.SeriesCollection(2).Values = "='" & ws.Name & "'! R2C5:R" & LastRow + 1 & "C5" ActiveChart.SeriesCollection(2).Name = "='" & ws.Name & "'! R1C5" ActiveChart.SeriesCollection(3).XValues = "='" & ws.Name & "'! R2C3:R" & LastRow + 1 & "C3" ActiveChart.SeriesCollection(3).Values = "='" & ws.Name & "'! R2C6:R" & LastRow + 1 & "C6" ActiveChart.SeriesCollection(3).Name = "='" & ws.Name & "'! R1C6" Otherwise (if LastRow = 1), the following line ActiveChart.SeriesCollection(3).XValues = "='" & ws.Name & "'!R2C3:R" & LastRow + 1 & "C3" gives the following error Unable to set the xvalues property of the series class I am able to set the xvalues property for both SeriesCollection(1) and SeriesCollection(2) to the same range that I am attempting to set SeriesCollection(3)'s to. The range is non-empty and contains less than 253 cells. Any ideas as to what may be causing this? I appreciate any effort to help me. Thank you for your time and consideration. Sincerely, Sisilla |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unable to set the xvalues property of the series class for a single row of source data
What kind of chart? In a line or XY chart, if a series is not plotted
because it contains all blanks or errors, then you cannot access its ..XValues, .Values, and some other properties. Temporarily change the chart type to column, change the properties, and change the chart type to what it was. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Sisilla" wrote in message oups.com... Hello All, The following code works if there is more than one row of source data. ActiveChart.SeriesCollection(1).XValues = "='" & ws.Name & "'! R2C3:R" & LastRow + 1 & "C3" ActiveChart.SeriesCollection(1).Values = "='" & ws.Name & "'! R2C4:R" & LastRow + 1 & "C4" ActiveChart.SeriesCollection(1).Name = "='" & ws.Name & "'! R1C4" ActiveChart.SeriesCollection(2).XValues = "='" & ws.Name & "'! R2C3:R" & LastRow + 1 & "C3" ActiveChart.SeriesCollection(2).Values = "='" & ws.Name & "'! R2C5:R" & LastRow + 1 & "C5" ActiveChart.SeriesCollection(2).Name = "='" & ws.Name & "'! R1C5" ActiveChart.SeriesCollection(3).XValues = "='" & ws.Name & "'! R2C3:R" & LastRow + 1 & "C3" ActiveChart.SeriesCollection(3).Values = "='" & ws.Name & "'! R2C6:R" & LastRow + 1 & "C6" ActiveChart.SeriesCollection(3).Name = "='" & ws.Name & "'! R1C6" Otherwise (if LastRow = 1), the following line ActiveChart.SeriesCollection(3).XValues = "='" & ws.Name & "'!R2C3:R" & LastRow + 1 & "C3" gives the following error Unable to set the xvalues property of the series class I am able to set the xvalues property for both SeriesCollection(1) and SeriesCollection(2) to the same range that I am attempting to set SeriesCollection(3)'s to. The range is non-empty and contains less than 253 cells. Any ideas as to what may be causing this? I appreciate any effort to help me. Thank you for your time and consideration. Sincerely, Sisilla |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unable to set the xvalues property of the series class for a single row of source data
On May 9, 4:10 pm, "Jon Peltier"
wrote: What kind of chart? In a line or XY chart, if a series is not plotted because it contains all blanks or errors, then you cannot access its .XValues, .Values, and some other properties. Temporarily change the chart type to column, change the properties, and change the chart type to what it was. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutionshttp://PeltierTech.com _______ "Sisilla" wrote in message oups.com... Hello All, The following code works if there is more than one row of source data. ActiveChart.SeriesCollection(1).XValues = "='" & ws.Name & "'! R2C3:R" & LastRow + 1 & "C3" ActiveChart.SeriesCollection(1).Values = "='" & ws.Name & "'! R2C4:R" & LastRow + 1 & "C4" ActiveChart.SeriesCollection(1).Name = "='" & ws.Name & "'! R1C4" ActiveChart.SeriesCollection(2).XValues = "='" & ws.Name & "'! R2C3:R" & LastRow + 1 & "C3" ActiveChart.SeriesCollection(2).Values = "='" & ws.Name & "'! R2C5:R" & LastRow + 1 & "C5" ActiveChart.SeriesCollection(2).Name = "='" & ws.Name & "'! R1C5" ActiveChart.SeriesCollection(3).XValues = "='" & ws.Name & "'! R2C3:R" & LastRow + 1 & "C3" ActiveChart.SeriesCollection(3).Values = "='" & ws.Name & "'! R2C6:R" & LastRow + 1 & "C6" ActiveChart.SeriesCollection(3).Name = "='" & ws.Name & "'! R1C6" Otherwise (if LastRow = 1), the following line ActiveChart.SeriesCollection(3).XValues = "='" & ws.Name & "'!R2C3:R" & LastRow + 1 & "C3" gives the following error Unable to set the xvalues property of the series class I am able to set the xvalues property for both SeriesCollection(1) and SeriesCollection(2) to the same range that I am attempting to set SeriesCollection(3)'s to. The range is non-empty and contains less than 253 cells. Any ideas as to what may be causing this? I appreciate any effort to help me. Thank you for your time and consideration. Sincerely, Sisilla- Hide quoted text - - Show quoted text - Jon & JLG, Thank you for your efforts to help me. I greatly appreciate it. The range for the XValues was non-empty, but the range for the SeriesCollection's Values was empty. Again Thanks, Sisilla |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unable to set the XValues property of the Series class | Charts and Charting in Excel | |||
Unable to set XValues Property of Series Class | Excel Programming | |||
Unable to set the XValues property of the Series class | Charts and Charting in Excel | |||
Unable to Set XValues property of the Series class | Excel Programming | |||
Unable to set the XValues property of the Series class | Excel Programming |