Iraelaemei
New Member
- Joined
- Nov 13, 2014
- Messages
- 34
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
<tbody>
</tbody>
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>
Last edited: