chart interval shows number

[uwmarkyo]

Hi
I tried to create a scatter plot for this data, but the interval converted to number label as following image. may I know how to keep the interval label?

 

[rlv01]

You could create a helper column "Seconds" and plot that as your x-axis instead of "Time".

tmp.xlsm
	A	B	C
145	Time	Seconds	Data
146	0:00:02	2	1
147	0:00:04	4	3
148	0:00:06	6	5
149	0:00:08	8	3
150	0:00:10	10	5
151	0:00:12	12	4
152	0:00:14	14	2
153	0:00:16	16	3
154	0:00:18	18	4
155	0:00:20	20	1
156	0:00:22	22	1
Sheet6

Cell Formulas
Range	Formula
B146:B156	B146	=A146/(1/(24*3600))

 

[uwmarkyo]

You could create a helper column "Seconds" and plot that as your x-axis instead of "Time".

tmp.xlsm
	A	B	C
145	Time	Seconds	Data
146	0:00:02	2	1
147	0:00:04	4	3
148	0:00:06	6	5
149	0:00:08	8	3
150	0:00:10	10	5
151	0:00:12	12	4
152	0:00:14	14	2
153	0:00:16	16	3
154	0:00:18	18	4
155	0:00:20	20	1
156	0:00:22	22	1
Sheet6

Cell Formulas
Range	Formula
B146:B156	B146	=A146/(1/(24*3600))

this will work. Great appreciation, thanks.