![]() 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. |