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!!!

[TABLE="width: 292"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]Product[/TD]
[TD]date[/TD]
[TD]Affinity Index[/TD]
[TD]Avg Basket $[/TD]
[/TR]
[TR]
[TD]Item B[/TD]
[TD="align: right"]1/1/2018[/TD]
[TD="align: right"]500[/TD]
[TD="align: right"]200[/TD]
[/TR]
[TR]
[TD]Item C[/TD]
[TD="align: right"]1/1/2018[/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]1000[/TD]
[/TR]
[TR]
[TD]Item D[/TD]
[TD="align: right"]1/1/2018[/TD]
[TD="align: right"]200[/TD]
[TD="align: right"]300[/TD]
[/TR]
[TR]
[TD]Item E[/TD]
[TD="align: right"]1/1/2018[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]250[/TD]
[/TR]
[TR]
[TD]Item B[/TD]
[TD="align: right"]2/1/2018[/TD]
[TD="align: right"]450[/TD]
[TD="align: right"]250[/TD]
[/TR]
[TR]
[TD]Item C[/TD]
[TD="align: right"]2/1/2018[/TD]
[TD="align: right"]200[/TD]
[TD="align: right"]300[/TD]
[/TR]
[TR]
[TD]Item D[/TD]
[TD="align: right"]2/1/2018[/TD]
[TD="align: right"]300[/TD]
[TD="align: right"]350[/TD]
[/TR]
[TR]
[TD]Item E[/TD]
[TD="align: right"]2/1/2018[/TD]
[TD="align: right"]250[/TD]
[TD="align: right"]400[/TD]
[/TR]
[TR]
[TD]Item B[/TD]
[TD="align: right"]3/1/2018[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]225[/TD]
[/TR]
[TR]
[TD]Item C[/TD]
[TD="align: right"]3/1/2018[/TD]
[TD="align: right"]200[/TD]
[TD="align: right"]400[/TD]
[/TR]
[TR]
[TD]Item D[/TD]
[TD="align: right"]3/1/2018[/TD]
[TD="align: right"]500[/TD]
[TD="align: right"]175[/TD]
[/TR]
[TR]
[TD]Item E[/TD]
[TD="align: right"]3/1/2018[/TD]
[TD="align: right"]225[/TD]
[TD="align: right"]190[/TD]
[/TR]
[TR]
[TD]Item B[/TD]
[TD="align: right"]4/1/2018[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]500[/TD]
[/TR]
[TR]
[TD]Item C[/TD]
[TD="align: right"]4/1/2018[/TD]
[TD="align: right"]200[/TD]
[TD="align: right"]500[/TD]
[/TR]
[TR]
[TD]Item D[/TD]
[TD="align: right"]4/1/2018[/TD]
[TD="align: right"]750[/TD]
[TD="align: right"]225[/TD]
[/TR]
[TR]
[TD]Item E[/TD]
[TD="align: right"]4/1/2018[/TD]
[TD="align: right"]275[/TD]
[TD="align: right"]230[/TD]
[/TR]
</tbody>[/TABLE]

 

[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.