I'm using LibreOffice Calc so the menus and option layouts are a little different, but this will be similar enough that you should be able to find the settings in Excel. It's been a while since I've done charting, so there are probably more direct ways to get to this solution, but I just knocked out a quick and dirty solution.
I used a pivot table to aggregate the data:
![enter image description here](../../I/static/images/15bc094df5201d09687f3ace872d8d0014c95e6299473406d3c4ac7557ac8f23.png)
(Deselect totals, drag FromNumber and SendDate in that order to Row Fields, drag SendDate to Data Fields, change Sum to Count.) That produces this pivot table:
![enter image description here](../../I/static/images/d49f819f8ff1ac99ae665a6650414741812fad527b1011023e320917cc08eaf6.png)
The column chart that you want treats the dates as category labels rather than actual dates. The bars just go in sequence, starting with the first category. So every date for every phone number needs a placeholder if there isn't an actual value. Otherwise, the bars won't be associated with the right date.
Your sample data doesn't have a January value for the 987 number. To prevent the 987 bars from appearing in the wrong place, I just created a duplicate table and inserted a zero entry for January:
![enter image description here](../../I/static/images/49054bd56de851d994af5c25cc5eb0656028b0fbd1a7e458efc7c7cb512a0a57.png)
To duplicate the pivot table, I just populated the first cell with =A2
and dragged to fill. Then added the dummy January entry.
Select the new table, insert chart, and select the column chart option. The chart needs some adjustment in the other setup tabs.
Under Data Range, specify Data Series in rows:
![enter image description here](../../I/static/images/730df17bcf2a8772ccda58a5e8a0f831c7982d4267cc23d3d79141ba0b537d7c.png)
Data Series will need some cleanup. For each of the phone numbers, select Y-Values
. Under Range for Y Values
, select the appropriate range of counts. Under Categories
, select the entire range of SendDate values (the whole table column excluding the header). Once you specify the category range for the first phone number, that should apply to the other numbers as well, just verify.
![enter image description here](../../I/static/images/dfd6a7ddf4d5b45dee8fccaa6bd36ad2a18217849a681d095febc17ecd7e5727.png)
Remove all of the series labelled as Row n
, leaving just the phone numbers.
That will produce the basic chart:
You can customize where the legend is located, the Y axis intervals, chart and axis labels, and other formatting.