This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
When creating a scatter plot using Excel 2016 in some cases extra data points are displayed. As far as I can figure out this happens when the following conditions are met:
The extra data point(s) are shown super-exposed on top of the last data point of a data series, using the marker style of the next series (when the first data point of that next series contains a value that cannot be plotted). When hovering over those extra data points, the x & y values associated with the first data point of the next series are displayed (see picture below).
This graph uses the following data table:
| Other | A | B | C | D | |
|---|---|---|---|---|---|
| 01/01/1950 | 98.70% | 1.30% | 0.00% | 0.00% | 0.00% |
| 01/01/1951 | 99.21% | 0.79% | 0.00% | 0.00% | 0.00% |
| 01/01/1952 | 99.51% | 0.49% | 0.00% | 0.00% | 0.00% |
| 01/01/1953 | 97.67% | 1.95% | 0.39% | 0.00% | 0.00% |
| 01/01/1954 | 95.22% | 4.31% | 0.48% | 0.00% | 0.00% |
| 01/01/1955 | 85.48% | 13.42% | 0.00% | 0.00% | 1.10% |
| 01/01/1956 | 78.88% | 20.13% | 0.99% | 0.00% | 0.00% |
| 01/01/1957 | 75.19% | 24.34% | 0.47% | 0.00% | 0.00% |
| 01/01/1958 | 71.33% | 26.88% | 1.67% | 0.12% | 0.00% |
| 01/01/1959 | 64.28% | 33.30% | 2.09% | 0.00% | 0.00% |
| 01/01/1960 | 54.74% | 41.86% | 3.30% | 0.00% | 0.00% |
| 01/01/1961 | 33.40% | 62.96% | 3.07% | 0.10% | 0.00% |
| 01/01/1962 | 21.04% | 76.75% | 1.83% | 0.29% | 0.00% |
| 01/01/1963 | 13.21% | 83.45% | 1.64% | 0.72% | 0.26% |
| 01/01/1964 | 8.57% | 87.44% | 2.82% | 0.76% | 0.00% |
| 01/01/1965 | 5.05% | 89.84% | 3.51% | 1.47% | 0.00% |
| 01/01/1966 | 2.50% | 93.51% | 2.43% | 1.44% | 0.00% |
| 01/01/1967 | 1.62% | 94.90% | 2.32% | 0.87% | 0.00% |
| 01/01/1968 | 0.84% | 95.39% | 1.82% | 1.49% | 0.06% |
| 01/01/1969 | 0.30% | 96.74% | 1.15% | 1.27% | 0.06% |
| 01/01/1970 | -0.13% | 96.33% | 1.16% | 1.74% | 0.06% |
| 01/01/1971 | 0.17% | 97.19% | 0.46% | 1.61% | 0.29% |
| 01/01/1972 | 0.06% | 96.85% | 0.71% | 2.08% | 0.18% |
| 01/01/1973 | 0.06% | 96.48% | 0.49% | 1.88% | 0.67% |
| 01/01/1974 | -0.15% | 96.35% | 0.22% | 2.41% | 0.73% |
| 01/01/1975 | 0.53% | 96.07% | 0.23% | 1.21% | 1.66% |
| 01/01/1976 | 0.89% | 93.50% | 0.00% | 1.71% | 3.57% |
| 01/01/1977 | 0.08% | 88.28% | 0.08% | 1.15% | 9.02% |
| 01/01/1978 | 1.25% | 72.03% | 0.10% | 1.54% | 23.53% |
| 01/01/1979 | 0.73% | 57.10% | 0.15% | 1.02% | 40.56% |
| 01/01/1980 | 1.42% | 29.10% | 0.11% | 0.33% | 68.60% |
| 01/01/1981 | 0.30% | 12.29% | 0.00% | 0.09% | 87.02% |
| 01/01/1982 | 0.09% | 4.61% | 0.00% | 25.00% | 95.20% |
Can anyone tell me what is the cause of this problem?
How can this problem be prevented?
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Dear Andreas,
I have tried all the check & repair suggestions you made. Unfortunately none of them had any effect on the issue.
Thank you for all your efforts.
Kind regards,
Peter.