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

The secondary axis is based on a column chart. The data has “Month” in the first column, “Sales” and “Sales percentage” in the second and third column, respectively. We’ll use the above table to demonstrate the addition of a secondary axis in the chart. Below are the steps to add a secondary axis to an existing chart.

Representation of the two data sets in a single chart usually helps in better visualization from a reader as well as an analyst’s point of view.

This type of technique is often used in the financial model where we need a clear picture of the data. If both the data sets are important to show, we can use a secondary axis. This is the most advanced technique used in analytics to show two data sets in the same graph.

While creating a secondary axis, the result is both axes vertically shown on the same graph.

Both the data sets are on Y-axis, but the second data set is added as a secondary axis to the same chart. Sales amounts are shown in blue bars, whereas Targets are shown in the orange line represented in the vertical axis as shown above.

When a secondary axis is added, the graph will look like this, as shown below.

This data has two datasets I,e Sales and Target Achieved %. You can download this Add a Secondary Axis Excel Template here – Add a Secondary Axis Excel Template

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