However, these data sets typically share the same unit of measurement.

To compare data sets with different units of measure, a secondary axis can be added to the chart.

choose the line or column associated with the second data series.

Click on the Line Representing a Data Series to Select It

Confirm that the series you selected is shown in the Current Selection box in the menu.

In this example, it’s Series “Employees.”

ChooseSecondary Axisin the right panel, under Series Options.

The Format tab.

Once added, this second axis can be customized just like the primary axis.

Now look at your chart.

A second reason is that the two series don’t have data of the same magnitude.

The Current Selection Tools at Left Allow You to Format a Specific Data Series

Consider, for example, the revenue of the company versus the employees.

Select Format Selection.

Now Turn Your Attention to the Left-Hand Panel’s Option to Add a Second Axis

With a Secondary Axis, the Graph’s Trends Are a Lot More Accurate

A Simple Excel Report Consisting of Yearly Values in Three Categories

Revenue and Expenses Are Both Measured in Dollars

When the Magnitude of Series is Different, Trends Can Become Skewed