Map Chart

[zinah]

Hi!

I'm creating a bubble chart that has a map in the background. The bubbles size depends on headcount but I'm facing I have headcount that is 1000+ and some headcount that are 4 and 25. These headcount won't be visible enough on the map, is there any way I can make all the bubbles appear in a proper way?

The table of chart is as below:

x	y	Country	Headcount
3.15	3.6	BE	224
4.5	3.4	AA	46
3	3	FF	130
3.8	3.6	GE	601
4.8	2.95	HH	25
3.3	4.7	NN	77
5	3.7	PP	87
2.3	1.8	SS	60
4.7	6.6	SE	4
2.6	4	UU	1,819

 

[cyrilbrd]

Thank you so much, that really helps! Now how can I change the bubble size? the size depends on the headcount of each country.

Most welcome.
Bubble size are related to the count.
See here:
Given the following dataset.

Book1
	A	B
1	Country	study
2	united kingdom	224
3	france	46
4	spain	130
5	germany	601
6	austria	25
Sheet1

Select the range of interest then click on Insert 3D Map
This will open the 3D map page.
Select the Bubble icon

Then place Study in Size:

Thus giving you the graphical representation of the tables's data in a map: