Excel Question

[hashempour]

Hi Mr. Excel, I have a question, I have 2 columns A and B, A contains just a date of a reported incident (that expands many months) and Column B has the responsible system name, is there a way to create a graph that shows the number of weekly incidents per responsible system names?
Thanks

 

[SteveO59L]

Use a pivot table to group your data weekwise, then chart the results

 

[hashempour]

Thanks for the reply, the pivot table worked had to group the dates by day and count of 7, select a start date and done.