|
本帖最后由 sweettears8 于 2018-9-29 15:48 编辑
原始数据如下所示:
Machine | 9月25日 | 9月26日 | 9月27日 | 9月28日 | AA101 | 0.43% | 0.34% | 0.93% | 0.68% | AA102 | 1.00% | 0.22% | 0.88% | 0.27% | AA103 | 0.08% | 0.70% | 0.59% | 0.73% | AA104 | 0.09% | 0.68% | 0.34% | 0.51% | AA105 | 0.01% | 0.74% | 0.69% | 0.25% | AA106 | 0.27% | 0.53% | 0.25% | 0.86% | AA107 | 0.62% | 0.95% | 0.99% | 1.00% | AA108 | 0.56% | 0.23% | 0.73% | 0.55% | AA109 | 0.12% | 0.83% | 0.49% | 0.22% | AA110 | 0.68% | 0.32% | 0.03% | 0.61% | AA111 | 0.23% | 0.78% | 0.09% | 0.36% | AA112 | 0.15% | 0.91% | 0.99% | 0.20% | AA113 | 0.44% | 0.74% | 0.52% | 0.04% | AA114 | 0.70% | 0.31% | 0.46% | 0.01% | AA115 | 0.54% | 0.02% | 0.62% | 0.94% | AA801 | 0.71% | 0.25% | 0.35% | 0.76% | AA802 | 0.42% | 0.51% | 0.87% | 0.08% | AA803 | 0.42% | 0.92% | 0.07% | 0.24% | AA804 | 0.58% | 0.70% | 0.75% | 0.58% | AA805 | 0.61% | 0.34% | 0.82% | 0.84% | AA806 | 0.93% | 0.75% | 0.90% | 0.15% | AA807 | 0.51% | 0.84% | 0.71% | 0.89% | AA808 | 0.79% | 0.14% | 0.46% | 0.56% | AA809 | 0.05% | 0.03% | 0.01% | 0.92% | AA810 | 0.92% | 0.42% | 0.67% | 0.80% | AA811 | 0.73% | 0.00% | 0.13% | 0.77% | AA812 | 0.68% | 0.56% | 0.58% | 0.95% | AA813 | 0.62% | 0.45% | 0.20% | 0.56% | AA814 | 0.80% | 0.11% | 0.98% | 0.30% |
|
| |
| | 为了用Excel图形更形象的看出各机台表现状况, 增加时间维度, 增加辅助数据后效果如下图1所示:[img]blob:http://club.excelhome.net/2d39fb09-8ada-4db5-930c-f3f67df22834[/img]
但是以上数据来源于枢纽分析, 不便于增加辅助列, 只能做到如下图2效果:
[img]blob:http://club.excelhome.net/4fcb5808-0b0b-46c0-8acb-5942e7dc3b5c[/img]
各位大神是否有好的方法实现图1中的效果, 数据见附件!
|
|