You have selected all the data or a cell in the data => then pressing ALT + F1 key in your keyboard.Say, you have created an Excel in one of the following two ways: You were not aware of the data type and already have built a chart with the data. 2) Adding a secondary axis to an existing Excel chart I will show later (after showing one more technique to add a secondary axis) how you can change the formatting of a chart to make it a professional-looking one. If you like the preview, click on the OK button. You are also seeing the preview of the chart in the middle of the dialog box. On the right side, you will find the data Series Names, 2 drop-down menus under the Chart Type heading, and 2 checkboxes under the Secondary Axis title.Ĥ) I choose Line with Markers chart for the Average Sales Price data series and tick the checkbox (on the right) for showing this data in the secondary axis. 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)

Change axis type on excel for mac