add a secondary y axis to a graph in excel for mac

It looks easy, but we have one more way i.e., manual way. They may include 1 line for a single data set or multiple lines to compare different data sets. As we can see in the preview, sales conversion percentage comes under a secondary axis with a different chart type i.e., “ Line Chart in Excel Line Chart In Excel Line Graphs/Charts in Excels are visuals to track trends or show changes over a given period & they are pretty helpful for forecasting data.Though these charts are simple to create, analyzing them becomes increasingly difficult as the number of categories increases from single to multiple. Choose the first one, which says, “ Clustered Column Chart in Excel Clustered Column Chart In Excel In Excel, a clustered column chart depicts data in a series of vertical columns. Under this, we can see excel has a recommended chart based on the data set.And from the design tab, click on “Change Chart Type.” We cannot see the sales conversion percentage column, so select the chart and go to the Design tab.Once you have applied the column chart, we will get a chart like this.Method #1: Simple to Add Secondary Axis in Excel Now we will see how to add a secondary axis in excel. As we can see on the right hand, there is another vertical axis showing the percentage of sales conversion.

Add a secondary y axis to a graph in excel for mac