|
如何通过EXCEL作成一年的每天24小时各个时间段的销售数据分布图。目的是统计分析24小时中每个时间段销售数据分布,以分析用户一天中的购买访问时间段,根据用户习惯,分时段去投放广告和预算等
原始数据 | | | | | | | | | | | | | | | | | 年月日时 | 销售数量 | | | 目标图表(例子) | | | | | | | 2018/09/01 02:50:15JST | 1 | | | 销售合计 | | | | | | | | | | | | | | 2018/09/03 01:28:45JST | 1 | | | 16 | | | | | | | | | | | | | | 2018/09/06 02:18:23JST | 1 | | | 15 | | | | | | | | | | | | | | 2018/09/08 17:50:09JST | 1 | | | 14 | | | | | | | | | | | | | | 2018/09/11 15:07:46JST | 1 | | | 13 | | | | | | | | | | | | | | 2018/09/11 16:38:38JST | 1 | | | 12 | | | | | | | | | | | | | | 2018/09/12 13:37:03JST | 1 | | | 11 | | | | | | | | | | | | | | 2018/09/13 06:50:32JST | 1 | | | 10 | | | | | | | | | | | | | | 2018/09/17 15:45:09JST | 1 | | | 9 | | | | | | | | | | | | | | 2018/09/18 10:27:48JST | 1 | | | 8 | | | | | | | | | | | | | | 2018/09/18 17:49:38JST | 2 | | | 7 | | | | | | | | | | | | | | 2018/09/20 13:39:59JST | 1 | | | 6 | | | | | | | | | | | | | | 2018/09/22 11:51:23JST | 1 | | | 5 | | | | | | | | | | | | | | 2018/09/23 14:48:22JST | 1 | | | 4 | | | | | | | | | | | | | | 2018/09/24 00:51:50JST | 1 | | | 3 | | | | | | | | | | | | | | 2018/09/24 03:07:11JST | 1 | | | 2 | | | | | | | | | | | | | | 2018/09/24 04:13:48JST | 1 | | | 1 | | | | | | | | | | | | | | 2018/09/27 07:21:36JST | 1 | | | | 0-1点钟 | 1-2点钟 | 2-3点钟 | 3-4点钟 | 4-5点钟 | 5-6点钟 | 8-9PM | 24小时具体某个时段 | | | | | 2018/09/27 18:48:10JST | 1 | | | | | | | | | | | | | | | | | 2018/09/29 06:18:14JST | 1 | | | 目的是统计分析24小时中每个时间段销售数据分布,以分析用户一天中的购买访问时间段,根据用户习惯,分时段去投放广告和预算等 | 2018/09/29 17:56:17JST | 1 | | | 2018/09/30 00:52:34JST | 1 | | | | | | | | | | | | | | | | | 2018/09/30 18:10:33JST | 1 | | | | | | | | | | | | | | | | | 2018/10/03 04:18:15JST | 1 | | | | | | | | | | | | | | | | | 2018/10/13 15:52:26JST | 2 | | | | | | | | | | | | | | | | | 2018/10/14 15:51:37JST | 1 | | | | | | | | | | | | | | | | | 2018/10/14 23:00:11JST | 1 | | | | | | | | | | | | | | | | | 2018/10/15 02:46:36JST | 1 | | | | | | | | | | | | | | | | | 2018/10/16 03:26:00JST | 1 | | | | | | | | | | | | | | | | |
|
|