Help with Stacked Column Graph

[rpatrick]

I'm having a bit of difficulty finding the solution for what I thought (expected? hoped? assumed?) would be an easy problem. I've searched but can't seem to find an answer.

I have sales data; multiple sales received per day. I'd like a graph that shows all the sales for 3/5 as a stacked column, each component of the stack would be each sale. I am only able to produce a graph that shows only one data point for 3/5, one for 3/6, one for 3/7, etc.

I attached a dumbed-down version of a workbook if anybody wants to take a crack at it. Any help is appreciated.

I'm doing this for sales reports for my sales team of ten, so I was hoping for something fast/streamlined that won't add alot to my workload.

[JieJenn]

Pivot Table is your friend