I downloaded your spreadsheet and had a look. I think that the most flexible way to present your data graphically is to produce a Pivot table report from your "Original Worksheet" sheet.
You can choose the source data to include a large number of rows that are not yet filled in so that when adding details to these rows the pivot table and related charts update automatically.
Charts can be made directly from the pivot table created except that the format and type does depend on the version of Excel that you are running.
