I have following data in table and I want to display in graph can you please suggest which graph should i choose to represent below data. I want to use highchart.
Ref No Available Date Report Date Competitor
214 24-02-2017 17-02-2017 ABC
337 24-02-2017 18-01-2017 ABC
337 10-02-2017 18-01-2017 XYZ
322 24-01-2017 13-01-2017 XYZ
337 10-02-2017 12-01-2017 DEF
322 24-01-2017 10-01-2017 ABC
337 10-02-2017 10-01-2017 DEF
214 24-01-2017 03-01-2017 XYZ
I want to show in graph particular competitor has how many Ref No. on perticular month (Report Date)
Let Say for example ABC
has 3 Ref No. (322,337,214)
from those month of January
has 2 (322,337)
month of February
has 1 (214)
.
Thanks in advance