Runtime Error 1004 when Setting Setting Series Values

**Andy Pope** · 04-09-2010, 09:00 AM

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

**tonymctigue** · 04-09-2010, 10:05 AM

Originally Posted by Andy Pope

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

Hole in one. Got it working. Thanks for the help.