Quote:
For example, company 1 should have pricing in 2015, 2016, 2017 and 2019 but I don't see a marker for them in 2017
|
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.)