Chart macro

[monk2211]

Hey everyone. I'm trying to make a scatterplot so what I did was recorded a macro and now I want to be able to update it using a for-loop. Here's my code.

Please Login or Register  to view this content.

My problem is with the three lines of .Name, .Values, and .XValues. When I run, I get a compile error of Method or Data Member Not Found.

I need to be able to create a new series each time the if-statement is run through and change the name, y-vals, and x-vals of the series according to my variables of counter2 and position2. Help me please!

[Andy Pope]

Try this

Please Login or Register  to view this content.

If not post example workbook

[monk2211]

That fixed my compile error, but now I get a new one:

Run-Time Error '438':
Object doesn't support this property or method.

Example workbook attached. Scroll down to the GRAPH comment.

[Andy Pope]

Chart sheets do not have a cells property.

try this revised code

Please Login or Register  to view this content.

[monk2211]

That worked perfect! Thank you!