Runtime Error 1004 when Setting Setting Series Values

Hello,

I'm having a problem with setting the values of a series collection on a chart. I have several hundred charts to plot with this same routine. It plots the first two fine but once it gets to the third chart, I get a Runtime Error 1004 "Unable to set the values property of the series class" error message when I specify the range containing the "values". The macro seems to have no problems setting the XValues.

One possible explanation I can think of is that the ranges containing the data to be plotted on the third and subsequent charts contain empty cells whereas the data ranges for the first two charts do not. I know Excel is more than capable of plotting charts from ranges containing empty cells when you're plotting charts manually but could this be the cause of my problem? If so, why are there no issues setting the XValues even though the range for the XValue inputs contains the same number of empty cells at the same locations as range containing the Values input? When I put an On Error Resume Next command in front of the section of code for plotting the charts, all charts are created with the correct XValues ranges.

Try creating the chart as Column chart. Once the series has had the range references set change the chart to desired type.

Some chart types complain when constructed via VBA and data is missing