Runtime Error 1004 when Setting Setting Series Values

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