Bubble Chart With Date Series

Benzoli7

Board Regular
Joined
Jan 11, 2010
Messages
134
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!!!

ProductdateAffinity IndexAvg Basket $
Item B1/1/2018500200
Item C1/1/2018501000
Item D1/1/2018200300
Item E1/1/2018100250
Item B2/1/2018450250
Item C2/1/2018200300
Item D2/1/2018300350
Item E2/1/2018250400
Item B3/1/201825225
Item C3/1/2018200400
Item D3/1/2018500175
Item E3/1/2018225190
Item B4/1/201825500
Item C4/1/2018200500
Item D4/1/2018750225
Item E4/1/2018275230

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

Some videos you may like

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

pgc01

MrExcel MVP
Joined
Apr 25, 2006
Messages
19,827
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,843
Messages
5,525,177
Members
409,629
Latest member
McGuilliam

This Week's Hot Topics

Top