Looking for some help with Excel

[DezUk]

I want to try and present the data I have in an excel spreadsheet in more visual graphical form. Basically I am reporting of bug tickets for the past three months and want to show a graph with newly opened tickets, against closed tickets and also show ongoing tickets. They all have a priority level of High or Very High.

I am useless with Excel but I know this can probably be converted into a graph of some sort, can anyone help?

This is the spreadsheet in question.

 

[DezUk]

Should be back now, removed any content that might allow access to areas, thanks to kgi

 

[DezUk]

Thankd for the feedback guys I will have a look into this and give the old pivot tables a try