Then choose the Combo option from the left menu. In the Insert Chart dialog box, choose the All Charts tab. You see, we have selected a cell within the data that we shall use to make the chart.Ģ) Now go to Insert tab => click on the Recommended Charts command in the Charts window or click on the little arrow icon on the bottom right corner of the window.ģ) This will open the Insert Chart dialog box.
You can add the secondary axis to an Excel chart from the beginning when you’re making the chart.ġ) In this way, at first, select all the data, or select a cell in the data. Read More 1) Add secondary axis to Excel charts (the direct way)