Scatterchart with weight with self-defined values for x and y axes

[Autowagen]

Hi all,

I have this data:

a

b

c

d

e

f

g

h

i

j

<tbody>
[TD="class: xl63"] label
[/TD]
[TD="class: xl63, width: 68"] x [/TD]
[TD="class: xl63, width: 68"] y [/TD]
[TD="class: xl63, width: 68"] weight [/TD]

[TD="align: right"]-1[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]1[/TD]

[TD="align: right"]-10[/TD]
[TD="align: right"]-3[/TD]
[TD="align: right"]1[/TD]

[TD="align: right"]-7[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]3[/TD]

[TD="align: right"]1[/TD]
[TD="align: right"]-2[/TD]
[TD="align: right"]2[/TD]

[TD="align: right"]-8[/TD]
[TD="align: right"]-4[/TD]
[TD="align: right"]5[/TD]

[TD="align: right"]8[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]3[/TD]

[TD="align: right"]-9[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]6[/TD]

[TD="align: right"]6[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]4[/TD]

[TD="align: right"]2[/TD]
[TD="align: right"]-3[/TD]
[TD="align: right"]8[/TD]

[TD="align: right"]2[/TD]
[TD="align: right"]-2[/TD]
[TD="align: right"]5[/TD]

</tbody>

And I want this result:

The weight is optional. The labels are not optional. What's the best way to approach this? A clever way of arranging data, or is VBA required?

 

[VBA Geek]

I think you are looking for a bubble chart

 

[Autowagen]

I think you are looking for a bubble chart

I've figured out that much! How can I add my own x-axis instead of it using a normal incremental 1 to n (number of rows)? And how do I add the labels?

 

[VBA Geek]

What do you mean Creating your own X Axis? You want it to be like in the picture?