need to group by date and chart each day

I'm not having luck with getting a chart to do what I want and would appreciate any help.

The attached workbook file has a sample of the data and the formula that allows a date range to be entered and then totals the values for that range. This is great for checking specific days.

What I want is a chart that totals each days values for all days available. This needs to be done without entering in a date range manually. Would like to do something like that looks like this . . .
desired chart.gif


Thanks for any suggestions.

Hey Teylyn,

That is very helpful and a nice tutoring session. Playing with this to understand better I end up with couple other questions.

I can add a line of data with a new date and it updates into the pivot values - but it doesn't update into the line chart. Even adding data with existing dates does not update into the line chart although the pivot data does update.when refreshed.
Also, the line chart has the day/month transposed.

Why is the chart not showing changes when the pivot data has been updated?
How are the dates in the chart fixed so the day/month is in the same order as referenced data?


Really appreciate you taking the time to show the steps. Very helpful.