散点图在Excel中的绘制

Question

我想用散点图的格式来绘制数据。

样本数据：

Date_time     Table_1.1 Table_1.2 Table_1.3 Table_1.4 Table_1.5

30/09/2007 09:00    Normal  Normal  Normal  Normal  Outlier                                     
30/09/2007 10:00    Normal  Normal  Normal  Normal  Outlier                                     
30/09/2007 11:00    Normal  Normal  Normal  Normal  Normal                                      
30/09/2007 12:00    Outlier Outlier Outlier Outlier Normal                                      
30/09/2007 13:00    Outlier Outlier Normal  Outlier Outlier                                     
30/09/2007 14:00    Outlier Normal  Normal  Outlier Outlier                                     
30/09/2007 15:00    Outlier Normal  Normal  Outlier Outlier                                     
30/09/2007 16:00    Normal  Outlier Normal  Outlier Outlier                                     
30/09/2007 17:00    Normal  Outlier Normal  Normal  Outlier                                     
30/09/2007 18:00    Normal  Outlier Outlier Outlier Normal                                      
30/09/2007 19:00    Outlier Normal  Normal  Outlier Normal                                      
30/09/2007 20:00    Outlier Outlier Outlier Outlier Outlier                                     
30/09/2007 21:00    Outlier Outlier Outlier Outlier Outlier                                     

预期成果：

Y轴应该是日期时间，Table_1.1~Table1.5应该位于x轴，并且只说明Outlier.

Answer 1

图表的本质，如：

​

​

是将未绘制的数据(即正常值)空出，并赋值以定义x轴之间的距离。