Insert Charts for every worksheet in workbook using VBA

Hello friends,

I'm trying to create a line chart for every sheet in a workbook that contains over 100 sheets. The data is stored in a table. I've had some luck creating the charts but unfortunately a little bit of extra information is being added to charts. I only require columns "testdate", "inst1", "inst2" for charts, where "testdate" is the x-axis, and "inst1" and "inst2" are two line series on the same plot. The code is as follows:

Please Login or Register  to view this content.

The first sheet will show a sample of what I'm trying to achieve.
Also if you could add a line of code to connect empty cells as data points as well, that'd be wonderful. Thank you!