Count number of times a date occurs and make a graph out of it [closed]

The simplest is to do a PivotChart.
Select your array of dates (with a header) and create a new Pivot Chart (Insert / PivotChart / Ok)
Then on the field list window, drag and drop the date column in the Axis list first and then in the value list first.

Step 1:

Step1

Step 2:

Step2

Leave a Comment