Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Series Collection Results in Runtime Error 1004
Hello,
I have an existing chart on a worksheet for which I am trying to update the XValues for each series. The update works for the first series that I want to change, but on the subsequent ones, it raises a Runtime Error 1004. The original values in each series are all valid. If I swap the series around (so that the second and third are before the first) then the error occurs immediately. Below is a cut-down version of the code I am using. The startrow and endrow variables are normally populated from elsewhere. If anyone could give me a pointer as to why it works for the first series but fails on all subsequent ones I would be grateful. Set CHT = Worksheets("Chart").ChartObjects("Chart 1").Chart startrow = 152 endrow = 196 Value1 = "='Overall Progress - Tabular'!R" & startrow & "C6:R" & endrow & "C6" Value2 = "='Overall Progress - Tabular'!R" & startrow & "C8:R" & endrow & "C8" Value3 = "='Overall Progress - Tabular'!R" & startrow & "C10:R" & endrow & "C10" CHT.SeriesCollection("Cumulative Actual").XValues= Value1 CHT.SeriesCollection("Cumulative Predictive Failed").XValues = Value2 CHT.SeriesCollection("Cumulative Actual Failed").XValues = Value3 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Series Collection Results in Runtime Error 1004
Try CHT.SeriesCollection("Cumulative Actual").Values= Value1 CHT.SeriesCollection("Cumulative Predictive Failed").Values = Value2 CHT.SeriesCollection("Cumulative Actual Failed").Values = Value3 The XValues property is for the scale -- Kaak ------------------------------------------------------------------------ Kaak's Profile: http://www.excelforum.com/member.php...fo&userid=7513 View this thread: http://www.excelforum.com/showthread...hreadid=564643 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Series Collection Results in Runtime Error 1004
"Kaak" wrote:
Try CHT.SeriesCollection("Cumulative Actual").Values= Value1 CHT.SeriesCollection("Cumulative Predictive Failed").Values = Value2 CHT.SeriesCollection("Cumulative Actual Failed").Values = Value3 The XValues property is for the scale Thanks. I originally did use Values (the help file wasn't clear as to the difference) but the same fault occurs whichever I use. Matthew |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Series Collection Results in Runtime Error 1004
Peter,
Thanks for your reply. I've had a go (changing my XValues back to Values which I had originally used) and adding the X-axis, but I'm still getting the same error. Based on the fact that you didn't have any problems, I'm starting to wonder if the chart is corrupt. I'll recreate it as a new chart and see what happens... Matthew |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Series Collection Results in Runtime Error 1004
As an update, I've removed all charts from the workbook, and inserted a new
one with the same setup as before. Unfortunately, despite this, the code still falls over on the second value when trying to update that series. -- Matthew Cunliffe www.euro-point.co.uk Test Consultancy "Matthew Cunliffe" wrote: Peter, Thanks for your reply. I've had a go (changing my XValues back to Values which I had originally used) and adding the X-axis, but I'm still getting the same error. Based on the fact that you didn't have any problems, I'm starting to wonder if the chart is corrupt. I'll recreate it as a new chart and see what happens... Matthew |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Series Collection Results in Runtime Error 1004
You can do this without using code:
http://peltiertech.com/Excel/Charts/Dynamics.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Matthew Cunliffe" <Matthew wrote in message ... Hello, I have an existing chart on a worksheet for which I am trying to update the XValues for each series. The update works for the first series that I want to change, but on the subsequent ones, it raises a Runtime Error 1004. The original values in each series are all valid. If I swap the series around (so that the second and third are before the first) then the error occurs immediately. Below is a cut-down version of the code I am using. The startrow and endrow variables are normally populated from elsewhere. If anyone could give me a pointer as to why it works for the first series but fails on all subsequent ones I would be grateful. Set CHT = Worksheets("Chart").ChartObjects("Chart 1").Chart startrow = 152 endrow = 196 Value1 = "='Overall Progress - Tabular'!R" & startrow & "C6:R" & endrow & "C6" Value2 = "='Overall Progress - Tabular'!R" & startrow & "C8:R" & endrow & "C8" Value3 = "='Overall Progress - Tabular'!R" & startrow & "C10:R" & endrow & "C10" CHT.SeriesCollection("Cumulative Actual").XValues= Value1 CHT.SeriesCollection("Cumulative Predictive Failed").XValues = Value2 CHT.SeriesCollection("Cumulative Actual Failed").XValues = Value3 |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Series Collection Results in Runtime Error 1004
Thanks Jon. I need to write it in code as it is part of an automated update
to the whole workbook. The idea is that the user just presses one button, all the data is collated and processed, then displayed in the updated chart. As this is likely to occur several times a day, it needs to be fairly rapid (although I seem to have spend half a day trying to resolve this!) -- Matthew Cunliffe www.euro-point.co.uk Test Consultancy "Jon Peltier" wrote: You can do this without using code: http://peltiertech.com/Excel/Charts/Dynamics.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Matthew Cunliffe" <Matthew wrote in message ... Hello, I have an existing chart on a worksheet for which I am trying to update the XValues for each series. The update works for the first series that I want to change, but on the subsequent ones, it raises a Runtime Error 1004. The original values in each series are all valid. If I swap the series around (so that the second and third are before the first) then the error occurs immediately. Below is a cut-down version of the code I am using. The startrow and endrow variables are normally populated from elsewhere. If anyone could give me a pointer as to why it works for the first series but fails on all subsequent ones I would be grateful. Set CHT = Worksheets("Chart").ChartObjects("Chart 1").Chart startrow = 152 endrow = 196 Value1 = "='Overall Progress - Tabular'!R" & startrow & "C6:R" & endrow & "C6" Value2 = "='Overall Progress - Tabular'!R" & startrow & "C8:R" & endrow & "C8" Value3 = "='Overall Progress - Tabular'!R" & startrow & "C10:R" & endrow & "C10" CHT.SeriesCollection("Cumulative Actual").XValues= Value1 CHT.SeriesCollection("Cumulative Predictive Failed").XValues = Value2 CHT.SeriesCollection("Cumulative Actual Failed").XValues = Value3 |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
Series Collection Results in Runtime Error 1004
Can you edit the new source data Values in the existing series manually
Regards, Peter T "Matthew Cunliffe" wrote in message ... As an update, I've removed all charts from the workbook, and inserted a new one with the same setup as before. Unfortunately, despite this, the code still falls over on the second value when trying to update that series. -- Matthew Cunliffe www.euro-point.co.uk Test Consultancy "Matthew Cunliffe" wrote: Peter, Thanks for your reply. I've had a go (changing my XValues back to Values which I had originally used) and adding the X-axis, but I'm still getting the same error. Based on the fact that you didn't have any problems, I'm starting to wonder if the chart is corrupt. I'll recreate it as a new chart and see what happens... Matthew |
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
Series Collection Results in Runtime Error 1004
Peter,
Yes, I can. It turns out that removing the charts and starting from scratch did do the trick, but I introduced another error when I was retyping the code, so I thought I hadn't resolved it. The solution appears to be that it looks like the chart was corrupt. Thanks for all your help! -- Matthew Cunliffe www.euro-point.co.uk Test Consultancy "Peter T" wrote: Can you edit the new source data Values in the existing series manually Regards, Peter T "Matthew Cunliffe" wrote in message ... As an update, I've removed all charts from the workbook, and inserted a new one with the same setup as before. Unfortunately, despite this, the code still falls over on the second value when trying to update that series. -- Matthew Cunliffe www.euro-point.co.uk Test Consultancy "Matthew Cunliffe" wrote: Peter, Thanks for your reply. I've had a go (changing my XValues back to Values which I had originally used) and adding the X-axis, but I'm still getting the same error. Based on the fact that you didn't have any problems, I'm starting to wonder if the chart is corrupt. I'll recreate it as a new chart and see what happens... Matthew |
#11
Posted to microsoft.public.excel.programming
|
|||
|
|||
Series Collection Results in Runtime Error 1004
Dynamic charts made in this way are in general as rapid as VBA, since they
rely on built in Excel worksheet functions. As soon as the VBA changes the input data, the dynamic formulas update themselves, and the chart keeps pace. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Matthew Cunliffe" wrote in message ... Thanks Jon. I need to write it in code as it is part of an automated update to the whole workbook. The idea is that the user just presses one button, all the data is collated and processed, then displayed in the updated chart. As this is likely to occur several times a day, it needs to be fairly rapid (although I seem to have spend half a day trying to resolve this!) -- Matthew Cunliffe www.euro-point.co.uk Test Consultancy "Jon Peltier" wrote: You can do this without using code: http://peltiertech.com/Excel/Charts/Dynamics.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Matthew Cunliffe" <Matthew wrote in message ... Hello, I have an existing chart on a worksheet for which I am trying to update the XValues for each series. The update works for the first series that I want to change, but on the subsequent ones, it raises a Runtime Error 1004. The original values in each series are all valid. If I swap the series around (so that the second and third are before the first) then the error occurs immediately. Below is a cut-down version of the code I am using. The startrow and endrow variables are normally populated from elsewhere. If anyone could give me a pointer as to why it works for the first series but fails on all subsequent ones I would be grateful. Set CHT = Worksheets("Chart").ChartObjects("Chart 1").Chart startrow = 152 endrow = 196 Value1 = "='Overall Progress - Tabular'!R" & startrow & "C6:R" & endrow & "C6" Value2 = "='Overall Progress - Tabular'!R" & startrow & "C8:R" & endrow & "C8" Value3 = "='Overall Progress - Tabular'!R" & startrow & "C10:R" & endrow & "C10" CHT.SeriesCollection("Cumulative Actual").XValues= Value1 CHT.SeriesCollection("Cumulative Predictive Failed").XValues = Value2 CHT.SeriesCollection("Cumulative Actual Failed").XValues = Value3 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Runtime Error 1004 Unable to set the XValues property of series cl | Excel Programming | |||
runtime error 1004 | Excel Programming | |||
Excel 2003 Macro Error - Runtime error 1004 | Excel Discussion (Misc queries) | |||
Why I got this 1004 runtime error | Excel Programming | |||
Runtime error with the sheet collection, which was not there in 20 | Excel Programming |