Bubble Chart With Date Series

[Benzoli7]

Can anyone point me in the right direction to create a bubble chart out of the data below that shows each product as the same color, the date along the x-axis, the affinity index on the y-axis, and the avg basket $ as the bubble size? I've been searching, but can't find an example of what I'm trying to do. Thanks for the help!!!

Product	date	Affinity Index	Avg Basket $
Item B	1/1/2018	500	200
Item C	1/1/2018	50	1000
Item D	1/1/2018	200	300
Item E	1/1/2018	100	250
Item B	2/1/2018	450	250
Item C	2/1/2018	200	300
Item D	2/1/2018	300	350
Item E	2/1/2018	250	400
Item B	3/1/2018	25	225
Item C	3/1/2018	200	400
Item D	3/1/2018	500	175
Item E	3/1/2018	225	190
Item B	4/1/2018	25	500
Item C	4/1/2018	200	500
Item D	4/1/2018	750	225
Item E	4/1/2018	275	230

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>

 

[pgc01]

Hi

This seems to be a simple standard chart where you define the X values as the date, the Y values as the affinity index and the avg basket as the bubble size.

Can you please explain what you've done and what does not work.