How can I use the data from my class tally form to make a line chart in Excel?

I have tried using my submission data in excel, but the data I need seems to be all together in one column.

I am needing to make a graph to show class numbers over time.

Also I need to be able to log the total amounts.

Here is a screen shot.

I hope you can help please. x 

Cheryl xx

Hi Cheryl,

We will be more than happy to help out with your request. However, could you spare some additional information so we suggest the best way to address this issue. You mentioned that the information you need is all together in one column. Please specify which information this is and how you would like them to be presented in your excel submission report. We are looking forward to your response. I hope to hear from you soon.

Cheers!
Sean