In a chart, click the data series that you want to plot on a secondary vertical axis, or do the following to select the data series from a list of chart elements. Items you will need Existing Excel spreadsheet with a chart. Warning You cannot make a secondary horizontal axis unless you have made a secondary vertical axis first. Add or remove a secondary axis in a chart for Mac - Microsoft Community For example, display the first series as a line chart and the second series as a bar graph. Tip Distinguish the secondary axis from the primary axis by changing the chart type for a single data series. Step 2 Click the 'Layout' tab, then click on 'Axes' from the 'Axes' group.
