When you look more closely at lowest dot for year 2017, you see it looks like an ellips. Really there are 2 dots - for Company1 and for Company5.

For the rest, I changed how chart table shows missing values. Now the graph ignores them instead of displaying as 0's. Look into attachment. (In previous version, e.g. for year 2018 there were actually 5 dots with zero values.)

Attached Files

MultiSeriesScatterGraph.xlsx (17.9 KB, 11 views)