Thread: Scatter Charts
View Single Post
 
Old 02-20-2019, 11:32 PM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 873
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

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.)
Attached Files
File Type: xlsx MultiSeriesScatterGraph.xlsx (17.9 KB, 9 views)
Reply With Quote