Hello,
I am trying to automate the conversion of my raw data into a taple named "CPL" and from that table the creation of some charts. I got my code to run through the first graph fine but I got an "object not found error" when it tried to edit the second. Ideally, I would like this code to function in such a way so that each time I pull new raw data from this web based server, I can just copy it into my sheet and run the code and my graphs will be created. Please if you are able to help me with this, also explain what you doing with your code. I am trying desperately to learn VBA and it is tough when I get a bunch of code without notes in it. Any help would be appreciated and my desired output can be found in the attachment.

Book3.xlsm