Thread: create a line chart

I’m relatively new to Excel VBA macros and have what I think would be of good use for one but I can't seem to get my hands around it. Previously, I’ve created charts by recording a macro when using a fixed amount of data (i.e. number of rows don’t change). I now have a need to create a macro that graphs data from two columns that have a variable number of rows which is where my problem lies.

What I’m trying to do is the following.

1)Generate a line graph using data (time) in column C and (storage) in column E.
2)Chart title to contain data from cell A1.
3)The input file name may be different each time I run the macro but the columns will be the same.
4)The number of rows will vary.
5)I would like the chart to be a separate sheet in the workbook with the data.

Any ideas on how this could be accomplished? I’ve attached a sample example of what I’m looking for and how the data looks except the example shows the chart embedded not in a separate sheet. I would appreciate any help you can provide.

Thanks,
John