Need a dynamic chart in excel sheet

Dear All,
Please help me to create a dynamic chart in excel my criteria is on each day how many branches raised an errors. so on X-axis it should be date and Y-Axis is count of branches.

Hi,

I have created a graph in the template you have uploaded. Please check if this what you are looking for.

Dear cbatrody
You calculated manually and write in different column and create a chart.i want once i feed the data in excel sheet it will calculate automatically and update my chart. the problem with my excel sheet is merged columns i would not able to create chart with merged columns.any thoughts how to create a chart if you have merged columns.