本示例数据来自Coursera深度学习，可参考：https://blog.csdn.net/hpdlzu80100/article/details/113115439
前言：散点图比较常用，但是类似下图这种比较复杂的散点图第一次绘制，感觉比较新鲜。
散点图：
遗留问题：如何使用Excel可视化带有彩色标签的散点图，如下图所示：
数据：
| 1.20E+00 | 3.58E+00 | 0 |
| 6.94E-01 | 2.89E+00 | 0 |
| 4.75E-01 | 2.48E+00 | 0 |
| 2.62E-01 | 2.11E+00 | 0 |
| 6.81E-01 | 3.10E+00 | 0 |
| 1.66E-01 | 1.78E+00 | 0 |
| 1.55E+00 | 2.49E+00 | 0 |
| 1.45E+00 | 3.58E+00 | 1 |
| 1.46E+00 | 3.84E+00 | 1 |
| 1.23E+00 | 3.47E+00 | 1 |
| 1.52E+00 | 2.27E+00 | 1 |
| 7.52E-01 | 8.93E-01 | 1 |
| 3.52E-01 | 3.59E-01 | 1 |
| 1.27E+00 | 1.91E+00 | 0 |
| -2.63E+00 | -1.52E+00 | 0 |
| -3.52E-02 | -3.49E-02 | 0 |
| -3.38E+00 | -1.71E+00 | 0 |
| -1.01E+00 | -6.83E-02 | 0 |
| -3.52E+00 | -1.53E+00 | 0 |
| -3.81E+00 | -1.80E+00 | 1 |
| -3.86E+00 | -1.46E+00 | 1 |
| -2.94E+00 | -6.40E-01 | 1 |
| -2.66E+00 | -4.48E-01 | 1 |
| -2.75E+00 | -5.68E-01 | 1 |
| -1.95E+00 | -2.63E-01 | 1 |
| -1.03E+00 | -9.52E-02 | 0 |
| -2.40E+00 | -3.86E-01 | 0 |
| 1.21E+00 | -8.42E-02 | 0 |
| 3.97E+00 | -1.47E+00 | 0 |
| 3.31E+00 | -8.11E-01 | 0 |
| 3.56E+00 | -1.12E+00 | 0 |
| 1.52E-01 | -2.62E-04 | 1 |
| 2.73E+00 | -5.42E-01 | 1 |
| 3.09E+00 | -7.98E-01 | 1 |
| 1.13E+00 | -8.87E-01 | 1 |
| 2.31E+00 | -1.53E+00 | 1 |
| -9.84E-02 | 9.98E-02 | 1 |
| -5.53E-02 | 5.65E-02 | 0 |
| -1.71E+00 | 2.78E+00 | 0 |
| -6.33E-01 | 7.17E-01 | 0 |
| -5.97E-01 | 6.59E-01 | 0 |
| -1.75E+00 | 3.43E+00 | 0 |
| -6.81E-02 | 9.78E-01 | 0 |
| -6.88E-02 | -1.13E+00 | 1 |
| -1.57E-01 | 1.35E+00 | 1 |
| -1.53E+00 | 2.37E+00 | 1 |
| -9.55E-01 | 3.33E+00 | 1 |
| -3.14E-01 | 2.26E+00 | 1 |
| -8.07E-01 | -3.17E+00 | 1 |
| -2.33E-02 | -4.48E-01 | 0 |
| -1.07E+00 | 3.68E+00 | 0 |
| -4.27E-02 | 9.83E-01 | 0 |
| -4.89E-01 | -2.49E+00 | 0 |
| -1.81E+00 | -3.18E+00 | 0 |
| -1.04E-01 | -1.40E+00 | 0 |
| -8.32E-01 | -3.31E+00 | 1 |
| -3.42E-01 | -3.56E-01 | 1 |
| -1.68E+00 | -3.76E+00 | 1 |
| -1.25E+00 | -1.66E+00 | 1 |
| -1.27E+00 | -1.71E+00 | 1 |
| -1.03E+00 | -1.23E+00 | 0 |
| -1.40E+00 | -2.04E+00 | 0 |
| -1.16E+00 | -1.51E+00 | 0 |
| 1.48E+00 | 1.11E+00 | 0 |
| -1.07E+00 | -1.29E+00 | 0 |
| 7.88E-01 | 6.92E-01 | 0 |
| 2.08E+00 | 1.43E+00 | 1 |
| 3.90E+00 | 1.43E+00 | 1 |
| 3.09E+00 | 1.70E+00 | 1 |
| -1.11E-01 | -1.12E-01 | 1 |
| 3.06E+00 | 7.34E-01 | 1 |
| -6.52E-01 | 1.09E-02 | 0 |
| -7.55E-02 | -3.53E-04 | 0 |
| 3.22E+00 | 7.64E-01 | 0 |
| -5.00E-01 | 9.25E-03 | 0 |
| 3.86E+00 | 1.49E+00 | 0 |
| 3.14E-01 | 4.27E-03 | 0 |
| 3.82E-01 | 7.39E-03 | 1 |
| -2.78E+00 | 5.57E-01 | 1 |
| -9.59E-01 | 6.20E-02 | 1 |
| -2.13E+00 | 1.39E+00 | 1 |
| -2.59E+00 | 1.57E+00 | 1 |
| -2.81E+00 | 1.69E+00 | 0 |
| -4.21E+00 | 1.92E+00 | 0 |
| -1.38E+00 | 1.11E+00 | 0 |
| -3.06E+00 | 1.74E+00 | 0 |
| -2.98E+00 | 6.66E-01 | 0 |
| 1.57E+00 | -2.39E+00 | 0 |
| 1.47E+00 | -2.26E+00 | 1 |
| 3.91E-01 | -4.10E-01 | 1 |
| 1.60E+00 | -3.03E+00 | 1 |
| -1.72E+00 | 1.31E+00 | 1 |
| 3.77E-02 | -3.60E-02 | 1 |
| 1.46E+00 | -3.52E+00 | 0 |
| 1.31E+00 | -3.83E+00 | 0 |
| 4.72E-01 | -2.52E+00 | 0 |
| 2.25E-02 | -4.89E-01 | 0 |
| 5.30E-01 | -2.79E+00 | 0 |
| 3.66E-02 | -7.20E-01 | 0 |
| 3.76E-02 | 8.92E-01 | 1 |
| 1.59E-01 | -1.48E+00 | 1 |
| 1.62E+00 | -4.04E+00 | 1 |
| 1.66E-01 | 1.81E+00 | 1 |
| 2.32E-01 | 1.81E+00 | 1 |
| 1.21E-01 | 1.33E+00 | 0 |
| 1.72E+00 | 2.76E+00 | 0 |
| 9.85E-01 | 3.77E+00 | 0 |
| 1.64E+00 | 2.62E+00 | 0 |
| 1.47E+00 | 4.04E+00 | 0 |
| 1.31E+00 | 1.81E+00 | 0 |
| 1.69E+00 | 3.37E+00 | 1 |
| 1.69E+00 | 2.58E+00 | 1 |
| -1.49E+00 | -1.20E+00 | 1 |
| 5.35E-01 | 5.62E-01 | 1 |
| -3.16E+00 | -1.69E+00 | 1 |
| -4.00E+00 | -1.52E+00 | 0 |
| -2.39E+00 | -1.52E+00 | 0 |
| -3.02E-01 | -2.92E-01 | 0 |
| -3.10E+00 | -7.94E-01 | 0 |
| -2.55E+00 | -5.11E-01 | 0 |
| -3.77E+00 | -1.34E+00 | 0 |
| -2.91E+00 | -6.34E-01 | 0 |
| 8.17E-01 | -4.13E-02 | 0 |
| -3.32E+00 | -8.14E-01 | 0 |
| -5.00E-01 | -2.06E-02 | 0 |
| 3.03E+00 | -7.99E-01 | 0 |
| 2.01E+00 | -2.20E-01 | 0 |
| 2.05E+00 | -2.98E-01 | 0 |
| 3.30E-01 | -9.56E-03 | 0 |
| -9.53E-01 | -5.68E-02 | 0 |
| 2.34E+00 | -4.04E-01 | 0 |
| 1.96E+00 | -1.45E+00 | 0 |
| 2.14E+00 | -1.54E+00 | 0 |
| 1.93E+00 | -1.39E+00 | 0 |
| 3.34E+00 | -1.21E+00 | 0 |
| 2.21E+00 | -1.58E+00 | 0 |
| 6.55E-01 | -5.86E-01 | 0 |
| -1.26E+00 | 1.59E+00 | 0 |
| -1.08E+00 | 3.43E+00 | 0 |
| -8.54E-01 | 1.01E+00 | 0 |
| 5.02E-01 | -4.71E-01 | 0 |
| -1.49E+00 | 2.22E+00 | 0 |
| 1.08E+00 | -9.09E-01 | 0 |
| -1.77E+00 | 3.41E+00 | 0 |
| -1.70E+00 | 3.76E+00 | 0 |
| -7.83E-01 | 3.18E+00 | 0 |
| -1.43E+00 | 3.75E+00 | 0 |
| -5.56E-01 | 2.84E+00 | 0 |
| -1.86E-01 | -1.74E+00 | 0 |
| -2.12E-02 | -6.80E-01 | 0 |
| -2.33E-03 | -2.49E-01 | 0 |
| -7.88E-02 | -1.06E+00 | 0 |
| -1.40E+00 | -3.97E+00 | 0 |
| -4.03E-01 | -2.35E+00 | 0 |
| -1.63E+00 | -3.22E+00 | 0 |
| -1.16E+00 | -1.58E+00 | 0 |
| -1.50E+00 | -3.74E+00 | 0 |
| -1.24E+00 | -3.42E+00 | 0 |
| -1.71E+00 | -3.32E+00 | 0 |
| -2.94E-01 | -3.06E-01 | 0 |
| -1.08E+00 | -3.69E+00 | 0 |
| -3.67E-01 | -3.86E-01 | 0 |
| 2.95E+00 | 1.74E+00 | 0 |
| -1.29E+00 | -1.65E+00 | 0 |
| 2.71E+00 | 1.68E+00 | 0 |
| -1.65E-01 | -1.83E-01 | 0 |
| 2.37E+00 | 1.60E+00 | 0 |
| 2.04E+00 | 1.43E+00 | 0 |
| 1.00E+00 | 7.48E-02 | 0 |
| 1.45E+00 | 1.14E+00 | 0 |
| 2.97E+00 | 1.80E+00 | 0 |
| 2.40E+00 | 3.41E-01 | 0 |
| 3.68E+00 | 1.47E+00 | 0 |
| 6.71E-01 | 2.95E-02 | 0 |
| 2.83E+00 | 1.61E+00 | 0 |
| -2.86E-01 | 7.29E-04 | 0 |
| -1.43E+00 | 1.32E-01 | 0 |
| -2.79E+00 | 6.47E-01 | 0 |
| 8.26E-01 | 4.43E-02 | 0 |
| -3.86E+00 | 1.42E+00 | 0 |
| -2.96E+00 | 5.91E-01 | 0 |
| -3.16E+00 | 1.77E+00 | 0 |
| -1.04E+00 | 8.94E-01 | 0 |
| -2.46E+00 | 1.58E+00 | 0 |
| -3.18E+00 | 1.68E+00 | 0 |
| -3.57E+00 | 1.82E+00 | 0 |
| -3.55E+00 | 1.26E+00 | 0 |
| -2.97E+00 | 1.67E+00 | 0 |
| -3.03E+00 | 1.70E+00 | 0 |
| 1.64E+00 | -3.79E+00 | 0 |
| 1.27E+00 | -1.62E+00 | 0 |
| 5.69E-01 | 2.60E+00 | 0 |
| 1.78E+00 | -3.28E+00 | 0 |
| 9.96E-02 | -1.24E+00 | 0 |
| 1.69E+00 | -3.81E+00 | 0 |
| 1.79E+00 | -3.70E+00 | 0 |
| 1.03E+00 | -3.76E+00 | 0 |
| 7.24E-01 | -8.53E-01 | 0 |
| 5.97E-01 | 2.87E+00 | 0 |
| 2.14E-01 | 1.73E+00 | 0 |
| 9.52E-02 | -1.28E+00 | 0 |
| 1.54E+00 | 3.24E+00 | 0 |
| 1.66E+00 | 3.45E+00 | 0 |
| 1.58E+00 | 3.30E+00 | 0 |
| 1.13E+00 | 3.79E+00 | 0 |
| 1.89E+00 | 3.26E+00 | 0 |
| 1.45E+00 | 3.61E+00 | 0 |
| 1.28E+00 | 3.72E+00 | 0 |
| 1.54E+00 | 3.66E+00 | 0 |
| -1.99E+00 | -1.49E+00 | 0 |
| 1.74E+00 | 3.12E+00 | 0 |
| 3.71E-01 | 3.91E-01 | 0 |
| -7.45E-01 | -6.63E-01 | 0 |
| -1.71E-01 | -1.65E-01 | 0 |
| -2.11E+00 | -1.46E+00 | 0 |
| -3.08E+00 | -1.67E+00 | 0 |
| -3.55E+00 | -1.14E+00 | 0 |
| -1.48E-01 | -1.41E-01 | 0 |
| -3.86E+00 | -1.40E+00 | 0 |
| -3.62E+00 | -1.13E+00 | 0 |
| -3.23E+00 | -8.16E-01 | 0 |
| -3.71E+00 | -1.38E+00 | 0 |
| 1.22E+00 | -9.77E-02 | 0 |
| -2.14E-01 | -2.64E-03 | 0 |
| -2.53E+00 | -4.03E-01 | 0 |
| 1.52E+00 | -1.66E-01 | 0 |
| 3.18E+00 | -7.75E-01 | 0 |
| -1.62E+00 | -1.97E-01 | 0 |
| 4.08E+00 | -1.20E+00 | 0 |
| 3.04E+00 | -1.67E+00 | 0 |
| 2.31E+00 | -1.57E+00 | 0 |
| 5.47E-01 | -4.90E-01 | 0 |
| 3.67E+00 | -1.69E+00 | 0 |
| 1.39E+00 | -1.14E+00 | 0 |
| 9.16E-03 | -8.59E-03 | 0 |
| -5.32E-01 | 5.81E-01 | 0 |
| 5.84E-01 | -5.26E-01 | 0 |
| 9.43E-01 | -8.25E-01 | 0 |
| -1.40E+00 | 1.89E+00 | 0 |
| -1.23E+00 | 1.58E+00 | 0 |
| -1.89E+00 | 3.07E+00 | 0 |
| -1.28E+00 | 3.59E+00 | 0 |
| -1.50E+00 | 2.16E+00 | 0 |
| -1.43E+00 | 3.34E+00 | 0 |
| -7.21E-01 | 3.30E+00 | 0 |
| -5.66E-01 | 2.98E+00 | 0 |
| -1.99E-01 | 1.76E+00 | 0 |
| -5.62E-02 | -8.08E-01 | 0 |
| -9.66E-03 | -3.03E-01 | 0 |
| -2.38E-01 | -1.89E+00 | 0 |
| -9.28E-02 | -1.11E+00 | 1 |
| -1.35E+00 | 3.64E+00 | 1 |
| -1.03E-01 | -1.30E+00 | 1 |
| -1.13E+00 | 3.86E+00 | 1 |
| -1.27E+00 | -3.80E+00 | 1 |
| -8.81E-01 | -3.48E+00 | 1 |
| -1.10E+00 | -3.67E+00 | 1 |
| -8.07E-01 | -9.77E-01 | 1 |
| -4.54E-01 | -4.97E-01 | 1 |
| -4.05E-01 | -4.47E-01 | 1 |
| -1.49E+00 | -3.47E+00 | 1 |
| -1.53E+00 | -2.62E+00 | 1 |
| -1.38E+00 | -1.80E+00 | 1 |
| 3.03E+00 | 1.76E+00 | 1 |
| -2.29E-01 | -2.40E-01 | 1 |
| 3.74E+00 | 1.63E+00 | 1 |
| 3.47E+00 | 1.75E+00 | 1 |
| 4.04E+00 | 1.43E+00 | 1 |
| 3.22E+00 | 1.83E+00 | 1 |
| 3.43E+00 | 9.83E-01 | 1 |
| 3.67E+00 | 1.82E+00 | 1 |
| -1.83E-02 | -8.22E-05 | 1 |
| 3.02E+00 | 6.19E-01 | 1 |
| 3.63E+00 | 1.68E+00 | 1 |
| 3.67E+00 | 1.05E+00 | 1 |
| 2.28E+00 | 3.52E-01 | 1 |
| 9.57E-01 | 4.14E-02 | 1 |
| -3.29E+00 | 1.67E+00 | 1 |
| -3.73E+00 | 1.29E+00 | 1 |
| -3.59E+00 | 1.09E+00 | 1 |
| -3.60E+00 | 1.30E+00 | 1 |
| -1.73E+00 | 1.30E+00 | 1 |
| -3.16E-01 | 3.06E-01 | 1 |
| -3.44E+00 | 1.66E+00 | 1 |
| -2.42E+00 | 5.25E-01 | 1 |
| -3.34E+00 | 1.11E+00 | 1 |
| -1.83E+00 | 1.37E+00 | 1 |
| -9.61E-01 | 8.49E-01 | 1 |
| 7.51E-03 | -7.63E-03 | 1 |
| -8.84E-01 | 7.61E-01 | 1 |
| 1.41E+00 | -3.90E+00 | 1 |
| 1.61E+00 | -3.50E+00 | 1 |
| 1.57E+00 | -2.35E+00 | 1 |
| 1.50E+00 | -3.48E+00 | 1 |
| 1.54E+00 | -3.56E+00 | 1 |
| 1.76E+00 | -2.98E+00 | 1 |
| 1.46E-01 | 1.42E+00 | 1 |
| 1.24E+00 | -3.97E+00 | 1 |
| 1.77E-01 | -1.54E+00 | 1 |
| 3.24E-01 | -2.12E+00 | 1 |
| 3.49E-01 | -2.06E+00 | 1 |
| 3.63E-02 | -8.54E-01 | 1 |
| 8.40E-01 | -3.44E+00 | 1 |
| 6.36E-03 | 4.18E-01 | 1 |
| 1.62E+00 | 3.67E+00 | 1 |
| 1.72E+00 | 3.47E+00 | 1 |
| 7.49E-01 | 3.11E+00 | 1 |
| 1.60E+00 | 3.71E+00 | 1 |
| 1.57E+00 | 2.58E+00 | 1 |
| 3.95E-01 | 4.15E-01 | 1 |
| -2.91E+00 | -1.82E+00 | 1 |
| -3.73E+00 | -1.64E+00 | 1 |
| 5.64E-01 | 6.31E-01 | 1 |
| -2.50E+00 | -1.68E+00 | 1 |
| -3.51E+00 | -1.78E+00 | 1 |
| -1.79E+00 | -1.34E+00 | 1 |
| -2.92E+00 | -6.43E-01 | 1 |
| -2.41E+00 | -1.51E+00 | 1 |
| 3.46E-02 | 3.56E-02 | 1 |
| -2.32E+00 | -4.21E-01 | 1 |
| -2.50E+00 | -4.74E-01 | 1 |
| -1.95E+00 | -2.58E-01 | 1 |
| -1.66E+00 | -1.79E-01 | 1 |
| -1.10E+00 | -7.25E-02 | 1 |
| 1.96E+00 | -2.39E-01 | 1 |
| 2.22E+00 | -3.64E-01 | 1 |
| -1.45E+00 | -1.22E-01 | 1 |
| 3.18E+00 | -7.53E-01 | 1 |
| -3.18E-01 | -9.61E-03 | 1 |
| 3.55E+00 | -1.40E+00 | 1 |
| 2.79E-01 | -2.61E-01 | 1 |
| 3.49E+00 | -1.85E+00 | 1 |
| 3.92E+00 | -1.49E+00 | 1 |
| 3.51E+00 | -1.57E+00 | 1 |
| 1.68E+00 | -1.19E+00 | 1 |
| -3.46E-01 | 3.72E-01 | 1 |
| -7.68E-01 | 8.88E-01 | 1 |
| 3.78E+00 | -1.21E+00 | 1 |
| -6.44E-01 | 7.17E-01 | 1 |
| 9.51E-01 | -7.97E-01 | 1 |
| -1.24E+00 | 1.64E+00 | 1 |
| -1.99E+00 | 3.82E+00 | 1 |
| -1.02E+00 | 3.55E+00 | 1 |
| -1.63E+00 | 3.44E+00 | 1 |
| -1.50E+00 | 3.55E+00 | 1 |
| -4.28E-03 | 3.10E-01 | 1 |
| -3.93E-01 | 2.41E+00 | 1 |
| -5.84E-02 | 7.98E-01 | 1 |
| -1.53E+00 | 3.51E+00 | 1 |
| -5.86E-01 | -3.09E+00 | 1 |
| -9.24E-01 | -3.31E+00 | 1 |
| -9.65E-02 | 1.24E+00 | 1 |
| -1.77E+00 | -2.81E+00 | 1 |
| -3.30E-01 | 2.31E+00 | 1 |
| -3.24E-01 | 2.26E+00 | 1 |
| -5.14E-01 | -2.69E+00 | 1 |
| -1.72E+00 | -3.37E+00 | 1 |
| -1.06E+00 | -1.29E+00 | 1 |
| -1.79E+00 | -3.14E+00 | 1 |
| 2.03E+00 | 1.46E+00 | 1 |
| 1.53E+00 | 1.16E+00 | 1 |
| 1.75E+00 | 1.35E+00 | 1 |
| 2.41E+00 | 1.54E+00 | 1 |
| -1.14E+00 | -1.47E+00 | 1 |
| 1.80E-01 | 1.81E-01 | 1 |
| 3.49E+00 | 1.83E+00 | 1 |
| 2.43E+00 | 4.64E-01 | 1 |
| 3.15E+00 | 1.73E+00 | 1 |
| 3.04E+00 | 1.71E+00 | 1 |
| 3.16E+00 | 1.70E+00 | 1 |
| 1.82E+00 | 2.86E-01 | 1 |
| -1.85E+00 | 2.10E-01 | 1 |
| 6.67E-01 | 2.64E-02 | 1 |
| 3.42E+00 | 9.41E-01 | 1 |
| 7.88E-01 | 3.45E-02 | 1 |
| 2.81E-01 | 1.01E-02 | 1 |
| -1.85E+00 | 1.92E-01 | 1 |
| -2.22E+00 | 4.21E-01 | 1 |
| -1.23E+00 | 7.28E-02 | 1 |
| -3.20E+00 | 1.72E+00 | 1 |
| -1.17E+00 | 9.66E-01 | 1 |
| -3.45E+00 | 9.85E-01 | 1 |
| -3.70E+00 | 1.15E+00 | 1 |
| -3.34E+00 | 1.60E+00 | 1 |
| -1.34E+00 | 1.04E+00 | 1 |
| 7.78E-01 | -8.90E-01 | 1 |
| 1.47E+00 | -2.08E+00 | 1 |
| -3.38E+00 | 1.73E+00 | 1 |
| 1.80E+00 | -3.09E+00 | 1 |
| 1.57E+00 | -2.31E+00 | 0 |
| 1.58E+00 | -2.91E+00 | 0 |
| 1.71E+00 | -2.96E+00 | 0 |
| 1.32E+00 | -3.57E+00 | 0 |
| 1.20E+00 | -3.65E+00 | 0 |
| 3.36E-01 | -2.45E+00 | 0 |
| 1.11E+00 | -3.50E+00 | 0 |
| 1.50E+00 | -3.69E+00 | 0 |
| 7.11E-01 | -3.03E+00 | 0 |
| 4.50E-01 | 2.41E+00 | 0 |
| 7.31E-01 | 3.07E+00 | 0 |
2万+
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
