Hi there,
I'm trying to create a bubble chart displayed with quadrants (using two axes) + also determine the size of the bubble based on the size. However, I'm struggling when it comes to adding the actual names of the units - when I try to include the fourth column of data, the type of chart that I'm getting is falling apart. Anyone would be able to help?
Below is the basic idea:
What I would need to get, is the call-outs to have "Unit A", "Unit B" etc.
Thanks in advance for any ideas!
I'm trying to create a bubble chart displayed with quadrants (using two axes) + also determine the size of the bubble based on the size. However, I'm struggling when it comes to adding the actual names of the units - when I try to include the fourth column of data, the type of chart that I'm getting is falling apart. Anyone would be able to help?
Below is the basic idea:
What I would need to get, is the call-outs to have "Unit A", "Unit B" etc.
bubble_chart_example.xlsx | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | |||
1 | Name | % Gap | YoY change | Size | ||||||||||||||
2 | Unit A | 15% | 5% | 337 | ||||||||||||||
3 | Unit B | 12% | -4% | 360 | ||||||||||||||
4 | Unit C | 11% | 6% | 280 | ||||||||||||||
5 | Unit D | 16% | -2% | 400 | ||||||||||||||
6 | Unit E | -5% | 1% | 500 | ||||||||||||||
7 | ||||||||||||||||||
8 | ||||||||||||||||||
9 | ||||||||||||||||||
10 | ||||||||||||||||||
11 | ||||||||||||||||||
12 | ||||||||||||||||||
13 | ||||||||||||||||||
14 | ||||||||||||||||||
15 | ||||||||||||||||||
16 | ||||||||||||||||||
17 | ||||||||||||||||||
18 | ||||||||||||||||||
19 | ||||||||||||||||||
20 | ||||||||||||||||||
21 | ||||||||||||||||||
Arkusz1 |
Thanks in advance for any ideas!