One of my colleagues came up with a visualization problem today. He was making an MS Excel dashboard for his client. The client wanted to track the sales of a drug across various countries (using third-party monthly sales data). The data itself was really simple—it had sales value in USD million for 10 months since launch of the drug in various countries.[To know more about the ‘months since launch’ way of representing data, follow D’s post on LaunchTraX
To give you a better idea of the data set, I have created a mock data table for this post (lets call it the sales_table; M1 = one month since launch; M10= 10 months since launch).
His idea was to use a dynamic ‘line with marker chart’ to represent this. Continue reading