VBA code to plot the line graph for each row data in a worksheet

Hi,

Consider the table given below:

Scores	May	June	July	August
ABC	45	55	50	60
XYZ	55	70	80	75
BCD	50	60	70	80
CDG	40	60	50	90

I wanted to plot the line graph for each row with the first row as header for each row. Assume where column data will be appended for every month.

Can someone please help me with vba code to solve the above scenario.

Thanks in advance.

Hi Jeff,

I have a macro code which will fetch data from the source and append it into the new columns for every month on running the macro every time. I wanted to plot the graph for each user with their corresponding scores for every month while running the macro.

Thanks,
Karthik