Bubble Chart

[Iraelaemei]

I am trying to Create a Bubble Chart With the following data I would Like the x-axis to be the top row (Red Numbers) and the y-axis to be the Left side row (Blue Numbers) with the bubble size being the data in the middle.

I have been unsuccessful in having Excel Plot this data correctly, outside of me having to go in a Plot each point individually.

Can what I am wanting be done automatically by Excel? OR, will I have to go in and plot everything individually?

Please let me know if you need any further clarification.

Thanks

		Age of Loan
		0	1	2	3	4	5	6	7	8	9	10	11
Number of	1		1	6	1	3	1	3	4	1			1
Payments	2	1	1			3				1
Behind	3			1	2		1		1
Y-Axis	4							4
	5			1									1
	6				1
	7
	8
	9
	10
	11
	12					1
	13
	14					1
	15
	16			1

<tbody>
</tbody>

 

[pgc01]

Hi

It's very simple when the table has the right format.

If you want to create the chart directly you have to normalise the table.

Like

X Y Size
0 2 1
1 1 1
1 2 1
2 1 6
...

Then just select the values and insert the bubble chart.

If you have problems converting the table post back.

 

[Iraelaemei]

Thank you!

This worked.

Mark as solved.

 

[pgc01]

You're welcome.