Have you thought of using Pivot table?
Look at the attached file.
There is a macro created by recording the necessary changes that will copy all data in the proper format to use a pivot table or graph.
I copied your actual data in a second sheet to keep a copy of original data so you can try it.
Bookmarks