![]() ![]() Now, we have created slightly different data. In Jan, even though revenue is 41261, the $ profit percentage is limited to just 12.5% only.But, when we look at the June month, we have the second-lowest revenue, but the profit percentage is very high among all the other months.In Feb, we got the lowest revenue, and so did profit percentage.Now with this chart, we can make some easy interpretations. We can see on the right-hand side of the chart that we have one more Y-axis, which represents the line chart numbers. The chart selects Line for the profit and checks the box Secondary Axis. In this Combo, we can see a chart preview and various other recommended charts.Now, select the “Combo” option, which is there right at the bottom.We first need to right-click and select Change Chart Type. ![]() ![]() It is not the combo chart because we have only a column clustered chart here, so we need to change the Profit % data to the line chart. Now, we will have a chart like the one below.Then, go to Insert Charts Column Chart Clustered Column Chart in Excel. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |