使用VBA绘制不同的工作表。

I have 7 Excel Worksheets containing data that I want to use to produce a line graph with markers. I'm able to create the line graph on the first worksheet however I can't recreate the right graph on the second worksheet. I just recorded a macro to get an idea of how to plot in VBA so I'm not sure if this is the best way to produce linegraphs but essentially the first column A will contain the X-values and the other Columns B - I will contain the Y Data Values. I have 7 Excel Worksheets containing data that