Scatter Plot Graph - Issue with x-axis Label

[Jermine]

Hi guys,

I'm pretty new to Scatter Plot Graph and having an issue with this chart.

I would like to know why is the label for x-axis is not showing the Agent Tenure as per the data in the table but numbers?
The data under 'Agent Tenure' is : 1-2 Years, 7-12 Months, Apprentice, Month 1, Month 2, Month 3, Month 4, and Month 5.

In short, I'm trying to see the correlation between Actual Call Duration and Agent Tenure.

Book2.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T
1		Agent Tenure	Level 5	Actual call Duration	Hold Duration	% of Hold			Agent Tenure	Level 5	Actual call Duration	Hold Duration	% of Hold
2		1-2 Years	Zsmart	366	172	47%			7-12 Months	Non-Zsmart	563	226	40%
3		1-2 Years	Zsmart	375	71	19%			7-12 Months	Non-Zsmart	615	237	39%
4		1-2 Years	Zsmart	362	135	37%			7-12 Months	Non-Zsmart	509	177	35%
5		1-2 Years	Zsmart	289	95	33%			7-12 Months	Non-Zsmart	552	213	39%
6		1-2 Years	Zsmart	710	145	20%			7-12 Months	Non-Zsmart	555	127	23%
7		1-2 Years	Zsmart	278	79	28%			7-12 Months	Non-Zsmart	337	91	27%
8		1-2 Years	Zsmart	271	74	27%			7-12 Months	Non-Zsmart	442	200	45%
9		1-2 Years	Zsmart	636	108	17%			7-12 Months	Non-Zsmart	255	77	30%
10		1-2 Years	Zsmart	275	63	23%			7-12 Months	Non-Zsmart	665	104	16%
11		1-2 Years	Zsmart	541	411	76%			7-12 Months	Non-Zsmart	529	327	62%
12		1-2 Years	Zsmart	402	189	47%			Apprentice	Non-Zsmart	506	250	49%
13		7-12 Months	Zsmart	379	120	32%			Apprentice	Non-Zsmart	375	228	61%
14		7-12 Months	Zsmart	941	353	38%			Apprentice	Non-Zsmart	280	153	55%
15		7-12 Months	Zsmart	857	224	26%			Month 1	Non-Zsmart	184	65	35%
16		7-12 Months	Zsmart	407	66	16%			Month 1	Non-Zsmart	314	81	26%
17		7-12 Months	Zsmart	219	87	40%			Month 1	Non-Zsmart	394	136	35%
18		7-12 Months	Zsmart	306	82	27%			Month 1	Non-Zsmart	435	154	35%
19		7-12 Months	Zsmart	692	457	66%			Month 1	Non-Zsmart	356	190	53%
20		7-12 Months	Zsmart	427	97	23%			Month 1	Non-Zsmart	601	396	66%
21		7-12 Months	Zsmart	314	65	21%			Month 1	Non-Zsmart	562	146	26%
22		7-12 Months	Zsmart	362	79	22%			Month 1	Non-Zsmart	228	100	44%
23		7-12 Months	Zsmart	485	202	42%			Month 1	Non-Zsmart	201	77	38%
24		7-12 Months	Zsmart	626	268	43%			Month 1	Non-Zsmart	1592	498	31%
25		7-12 Months	Zsmart	844	206	24%			Month 1	Non-Zsmart	416	134	32%
26		7-12 Months	Zsmart	447	150	34%			Month 1	Non-Zsmart	286	102	36%
27		7-12 Months	Zsmart	369	97	26%			Month 1	Non-Zsmart	469	217	46%
28		Apprentice	Zsmart	311	173	56%			Month 1	Non-Zsmart	373	199	53%
29		Apprentice	Zsmart	465	113	24%			Month 1	Non-Zsmart	506	73	14%
30		Month 1	Zsmart	407	143	35%			Month 1	Non-Zsmart	946	64	7%
31		Month 1	Zsmart	1340	751	56%			Month 1	Non-Zsmart	256	71	28%
32		Month 1	Zsmart	512	122	24%			Month 1	Non-Zsmart	774	245	32%
33		Month 1	Zsmart	535	119	22%			Month 1	Non-Zsmart	317	79	25%
34		Month 1	Zsmart	402	100	25%			Month 1	Non-Zsmart	154	66	43%
35		Month 1	Zsmart	312	112	36%			Month 1	Non-Zsmart	248	88	35%
36		Month 1	Zsmart	270	80	30%			Month 1	Non-Zsmart	477	218	46%
37		Month 1	Zsmart	590	237	40%			Month 1	Non-Zsmart	699	579	83%
38		Month 1	Zsmart	317	116	37%			Month 1	Non-Zsmart	333	111	33%
39		Month 1	Zsmart	437	172	39%			Month 1	Non-Zsmart	993	340	34%
40		Month 1	Zsmart	560	100	18%			Month 1	Non-Zsmart	1227	105	9%
41		Month 1	Zsmart	198	86	43%			Month 1	Non-Zsmart	534	398	75%
42		Month 1	Zsmart	418	140	33%			Month 1	Non-Zsmart	626	186	30%
43		Month 1	Zsmart	301	160	53%			Month 1	Non-Zsmart	1330	215	16%
44		Month 1	Zsmart	334	116	35%			Month 1	Non-Zsmart	773	298	39%
45		Month 1	Zsmart	128	61	48%			Month 1	Non-Zsmart	1127	301	27%
46		Month 1	Zsmart	666	147	22%			Month 1	Non-Zsmart	402	67	17%
47		Month 1	Zsmart	488	295	60%			Month 1	Non-Zsmart	503	162	32%
48		Month 1	Zsmart	580	117	20%			Month 2	Non-Zsmart	1157	368	32%
49		Month 1	Zsmart	309	113	37%			Month 2	Non-Zsmart	193	76	39%
50		Month 1	Zsmart	287	78	27%			Month 2	Non-Zsmart	315	185	59%
51		Month 2	Zsmart	598	239	40%			Month 2	Non-Zsmart	349	134	38%
52		Month 2	Zsmart	726	409	56%			Month 2	Non-Zsmart	691	352	51%
53		Month 2	Zsmart	317	256	81%			Month 2	Non-Zsmart	289	61	21%
54		Month 2	Zsmart	316	155	49%			Month 2	Non-Zsmart	565	156	28%
55		Month 2	Zsmart	297	79	27%			Month 2	Non-Zsmart	256	148	58%
56		Month 2	Zsmart	726	197	27%			Month 2	Non-Zsmart	421	133	32%
57		Month 2	Zsmart	359	147	41%			Month 3	Non-Zsmart	177	75	42%
58		Month 2	Zsmart	468	177	38%			Month 3	Non-Zsmart	479	221	46%
59		Month 2	Zsmart	289	78	27%			Month 3	Non-Zsmart	525	152	29%
60		Month 2	Zsmart	417	83	20%			Month 3	Non-Zsmart	583	428	73%
61		Month 2	Zsmart	650	320	49%			Month 3	Non-Zsmart	213	65	31%
62		Month 2	Zsmart	811	90	11%			Month 3	Non-Zsmart	217	104	48%
63		Month 2	Zsmart	179	82	46%			Month 4	Non-Zsmart	633	264	42%
64		Month 2	Zsmart	526	76	14%			Month 4	Non-Zsmart	180	72	40%
65		Month 2	Zsmart	427	213	50%			Month 4	Non-Zsmart	380	90	24%
66		Month 2	Zsmart	793	181	23%			Month 5	Non-Zsmart	564	334	59%
67		Month 2	Zsmart	739	462	63%			Month 5	Non-Zsmart	767	355	46%
68		Month 2	Zsmart	312	119	38%			Month 5	Non-Zsmart	710	267	38%
69		Month 2	Zsmart	290	105	36%
70		Month 2	Zsmart	449	234	52%
71		Month 2	Zsmart	518	265	51%
72		Month 2	Zsmart	422	230	55%
73		Month 2	Zsmart	347	185	53%
74		Month 2	Zsmart	314	204	65%
75		Month 2	Zsmart	672	80	12%
76		Month 2	Zsmart	303	84	28%
77		Month 2	Zsmart	448	295	66%
78		Month 2	Zsmart	461	128	28%
79		Month 2	Zsmart	490	187	38%
80		Month 2	Zsmart	300	93	31%
81		Month 2	Zsmart	369	197	53%
82		Month 3	Zsmart	272	92	34%
83		Month 3	Zsmart	306	117	38%
84		Month 3	Zsmart	307	107	35%
85		Month 3	Zsmart	532	259	49%
86		Month 3	Zsmart	252	67	27%
87		Month 3	Zsmart	353	75	21%
88		Month 3	Zsmart	549	118	21%
89		Month 3	Zsmart	288	102	35%
90		Month 3	Zsmart	197	78	40%
91		Month 3	Zsmart	435	106	24%
92		Month 3	Zsmart	646	258	40%
93		Month 3	Zsmart	455	248	55%
94		Month 3	Zsmart	290	98	34%
95		Month 3	Zsmart	434	282	65%
96		Month 3	Zsmart	1948	954	49%
97		Month 3	Zsmart	1144	468	41%
98		Month 3	Zsmart	236	100	42%
99		Month 4	Zsmart	253	117	46%
100		Month 4	Zsmart	286	77	27%
101		Month 4	Zsmart	2185	605	28%
102		Month 4	Zsmart	499	254	51%
103		Month 4	Zsmart	413	141	34%
104		Month 4	Zsmart	292	98	34%
105		Month 4	Zsmart	345	100	29%
106		Month 4	Zsmart	904	583	64%
107		Month 4	Zsmart	273	79	29%
108		Month 4	Zsmart	550	68	12%
109		Month 4	Zsmart	294	84	29%
110		Month 4	Zsmart	2189	225	10%
111		Month 4	Zsmart	938	221	24%
112		Month 4	Zsmart	829	110	13%
113		Month 4	Zsmart	660	343	52%
114		Month 4	Zsmart	400	161	40%
115		Month 4	Zsmart	304	88	29%
116		Month 5	Zsmart	588	204	35%
117		Month 5	Zsmart	375	122	33%
118		Month 5	Zsmart	358	120	34%
119		Month 5	Zsmart	386	113	29%
120		Month 5	Zsmart	692	483	70%
121		Month 5	Zsmart	320	132	41%
122		Month 5	Zsmart	506	84	17%
123		Month 5	Zsmart	571	190	33%
124		Month 5	Zsmart	499	194	39%
125		Month 6	Zsmart	154	65	42%
126		Month 6	Zsmart	1747	1026	59%
127		Month 6	Zsmart	686	335	49%
128		Month 6	Zsmart	425	236	56%
129		Month 6	Zsmart	183	87	48%
130		Month 6	Zsmart	1040	378	36%
131		Month 6	Zsmart	300	70	23%
132		Month 6	Zsmart	1011	76	8%
133		Month 6	Zsmart	398	202	51%
134		Month 6	Zsmart	623	120	19%
135		Month 6	Zsmart	721	94	13%
136		Month 6	Zsmart	249	111	45%
137		Month 6	Zsmart	381	197	52%
138		Month 6	Zsmart	210	103	49%
139		Month 6	Zsmart	394	198	50%
140		More Than 2 Years	Zsmart	259	78	30%
141		More Than 2 Years	Zsmart	434	83	19%
142		More Than 2 Years	Zsmart	406	86	21%
143
144
145
146
147
Sheet5

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
K2:K68	Cell	contains a blank value	text	NO
D2:D142	Cell	contains a blank value	text	NO

 

[RoryA]

Both axes on a scatter plot are numeric, which is why you don't see text.