How to change the range in a 2-series chart

**guarriman** · 01-25-2011, 03:52 AM

Hi.

Using VBA 6.3 with Excel 2003, I'm trying to change the range in a chart with 2 series:

Please Login or Register  to view this content.

But, when executing, I get this error message in the "Error Line":

Please Login or Register  to view this content.

What am I doing wrong? Thank you very much in advance

**Andy Pope** · 01-25-2011, 09:36 AM

Are you setting the reference to or from a range that contains no plotable data?

**guarriman** · 01-27-2011, 05:35 AM

Hi.

Thank you very much for your answer, but I don't understand very well what you mean with "Set the reference". How can I set the reference?

"DataSourceSheet'!R8C1:R18C1" does exist and contains 11 rows with the value "Jan 1". I suppose that the error code line would print the "Jan 1" value on the X axis. In fact, two lines before it's executed with no problem (but with "SeriesCollection(1)").

By the way, I copied the code from "Tools > Macro > Record new macro...", but if I execute it I get the error code.

Regards.