Count Multiple Columns by Dates - Line Graph

[mattycl]

Hi Guys,

I need to generate a line graph from a number of columns with dates in.

In summary I have a column saying date opened with a load of dates. Then another column saying offer accepted with a load of dates.

I need to do a line graph which shows the number of each occurrence (column) by date.

Help is much appreciated. Thanks.

Excel Problem.png

[BadlySpelledBuoy]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

BSB