Using the Excel Pivot Table tool, I notice there are two major features of the online music business trends dataset to be visualized.

First of all, the trend among the total number of tracks purchased for each genre was increasing from 2012 to 2014 but dropped during 2015, while the percent purchased as streaming music was continuously increasing from 2012 to 2015. So I’ve designed a main line chart to show this trend and the total number of tracks for every genre over the years.  Click here to view my full report on my design process.