- Joined
- Apr 28, 2008
- Messages
- 1
- Reaction score
- 0
I am using Excel to process and chart test results. I have over 30 spreadsheets that are identical in nature, but differ by the data that they contain. Each spreadsheet uses VBA macros to create eight graphs based on two sets of data.
One of my spreadsheets stops during the chart creation process with a 1004 run-time error stating "Unable to set the values property of the series class". This has already been successfully performed for the two preceeding graphs in the problem spreadsheet and isn't a problem for any other spreadsheet. The spreadsheets have been updating several times a day for a number of weeks without problems.
The problem occurs when trying to set the data for the second of two lines on a line chart using a declared and populated array. The attached screenshot has a breakpoint on the offending line and shows some of the preceeding lines of code.
I have checked that the array contains valid (double) values, it can be seen that it is the correct size.
Does anybody have any ideas what the problem may be? I will be grateful for any suggestions offered.
Have fun,
Mikey
One of my spreadsheets stops during the chart creation process with a 1004 run-time error stating "Unable to set the values property of the series class". This has already been successfully performed for the two preceeding graphs in the problem spreadsheet and isn't a problem for any other spreadsheet. The spreadsheets have been updating several times a day for a number of weeks without problems.
The problem occurs when trying to set the data for the second of two lines on a line chart using a declared and populated array. The attached screenshot has a breakpoint on the offending line and shows some of the preceeding lines of code.
I have checked that the array contains valid (double) values, it can be seen that it is the correct size.
Does anybody have any ideas what the problem may be? I will be grateful for any suggestions offered.
Have fun,
Mikey
