Hi everyone!

I'm working on a customer satisfaction survey for training. 10-30 people would be taking the survey about every 2-3 days.
I've come up with the survey just fine using office 2013 and I have no problems with this part at all.

However, I am trying to get the survey data into graphs/charts and I am having a bit of an issue. I've created names for various pieces of data, so that the graphs auto update with each new submission.

I want to get the data combined by date instead of listing each separately by submission.

I've included my test copy with test data from co-workers.

Any help you guys can give would be most appreciated!

Thank you!

Survey.xlsx