of Jackets sold and Average Temperature are data plotted as a clustered chart only. Step 3: Now, your chart should like this. Step 2: Select the data and insert a new column chart. Step 1: The dataset should look like this. We need to plot a graph, see when are the highest sales happened and find the reasons. In this example, I will show you the sale of leather jackets in the last 12 months with the temperate data.ĭata includes the sales of leather jackets against the average temperature data for the last 12 months. In the previous example, we have seen the combination of sales, COGS, and profit margin. ![]() In the year 2013, COGS is more and profit comes down drastically.
0 Comments
Leave a Reply. |