Excel Maps not showing data

[DPChristman]

I have a map I created with excel maps, and I am trying to bring in percentage data from a list of 42 states.

The map only shows data from 31 states, randomly ditching 11 States for some reason.

Anybody know how to fix this?

Currently using 365 V 2311

 

[felixstraube]

Can you share the data you are working with?

 

[felixstraube]

This is working fine:

Libro1
	E	F
2	Alabama	70
3	Alaska	59
4	Arizona	9
5	Arkansas	54
6	California	12
7	Colorado	27
8	Connecticut	66
9	Delaware	50
10	Florida	65
11	Georgia	72
12	Hawaii	63
13	Idaho	61
14	Illinois	100
15	Indiana	47
16	Iowa	21
17	Kansas	9
18	Kentucky	24
19	Louisiana	77
20	Maine	30
21	Maryland	43
22	Massachusetts	7
23	Michigan	38
24	Minnesota	63
25	Mississippi	56
26	Missouri	53
27	Montana	77
28	Nebraska	54
29	Nevada	92
30	New Hampshire	38
31	New Jersey	69
32	New Mexico	31
33	New York	2
34	North Carolina	38
35	North Dakota	81
36	Ohio	76
37	Oklahoma	47
38	Oregon	59
39	Pennsylvania	94
40	Rhode Island	23
41	South Carolina	50
42	South Dakota	45
43	Tennessee	49
44	Texas	93
45	Utah	2
46	Vermont	4
47	Virginia	60
48	Washington	75
49	West Virginia	57
50	Wisconsin	42
51	Wyoming	46
Hoja2

Cell Formulas
Range	Formula
F2:F51	F2	=RANDBETWEEN(1,100)

 

[DPChristman]

This is working fine:

Libro1
	E	F
2	Alabama	70
3	Alaska	59
4	Arizona	9
5	Arkansas	54
6	California	12
7	Colorado	27
8	Connecticut	66
9	Delaware	50
10	Florida	65
11	Georgia	72
12	Hawaii	63
13	Idaho	61
14	Illinois	100
15	Indiana	47
16	Iowa	21
17	Kansas	9
18	Kentucky	24
19	Louisiana	77
20	Maine	30
21	Maryland	43
22	Massachusetts	7
23	Michigan	38
24	Minnesota	63
25	Mississippi	56
26	Missouri	53
27	Montana	77
28	Nebraska	54
29	Nevada	92
30	New Hampshire	38
31	New Jersey	69
32	New Mexico	31
33	New York	2
34	North Carolina	38
35	North Dakota	81
36	Ohio	76
37	Oklahoma	47
38	Oregon	59
39	Pennsylvania	94
40	Rhode Island	23
41	South Carolina	50
42	South Dakota	45
43	Tennessee	49
44	Texas	93
45	Utah	2
46	Vermont	4
47	Virginia	60
48	Washington	75
49	West Virginia	57
50	Wisconsin	42
51	Wyoming	46
Hoja2

Cell Formulas
Range	Formula
F2:F51	F2	=RANDBETWEEN(1,100)

View attachment 104022

Not the case here (Note all states in black have 0 for numbers) Not to mention smaller states (ex CT, NJ, MD) cannot fit both the state abbrev and number within the state.

 

[felixstraube]

Maybe if you try the full name instead of the 2 letters for the state?

 

[DPChristman]

Maybe if you try the full name instead of the 2 letters for the state?

Tried both ways - Same result

 

[felixstraube]

Can you share your file or a sample of it?