create multiple x y charts, one for each column with the same x axis using excel-vba

Hi,

I've been working on the problem of automating the plotting of line diagrams. But I did not yet manage to solve it yet.


I would need multiple charts one for each column (from E to R) using the same column (B) for the X axis. The ultimate aim is to be able to clean out the extreme or outlying values.

Could anyone please help me with this problem, I would really appreciate it.


Thank you!


After recording a macro on one of the worksheets and editing the code I got the following:

I edited it so only the name of the worksheet has to be changed because all the 30 worksheets I have to run this on have the same structure, but the best would be if it could run automatically for all the sheets in the actual file.

Unfortunately it stops after the first graph giving me a runtime error.

Please Login or Register  to view this content.

Thank you for the help, unfortunately it gave me a runtime error, although I specified the ranges.

I am by the way looking for something like this: fig.png. And again thank you for your efforts!

Please Login or Register  to view this content.

On that file it runs perfectly, I do not have any idea why it won't work in the original document. It says: Location of object chart failed or, Runtime error 1004, method ' Range of object'_Global failed

I have attached the original file, and it would be more than perfect if it would plot the graphs referring to the same worksheet on one new wsheet.

Attachment 374771

Thank you very-very much for your efforts so far.

Dear Brendan!

I have edited it a bit, but it works perfectly thank you very-very much!

All the best!

I.