Have you tried using the macro recorder when clearing out the series information?

Is the chart type a line type? I think column charts are more tolerant of missing/empty data when using code. You might be able to change chart type whilst setting references and the change back to line after.