For example, we have our data set including expenses and revenue for our locations. We also have the number of employees for each location to show how those numbers affect the expenses and revenue. This chart has two problems.

First, the values for the employees are well below the smallest amounts for expenses and revenue. Second, we have a mix of currency and number formats. Not only is the data almost impossible to see, but it’s meaningless without the number values.

As you can see, plotting this data without a secondary axis doesn’t provide a successful or useful picture.

Add a Secondary Axis in Excel

RELATED: How to Create a Combo Chart in Excel

To begin the conversion to a two-axis chart, select one of the indicators for the axis you want to turn into a secondary axis. Then, right-click and pick “Change Series Chart Type.”

You’ll see the Change Chart Type window open with Combo selected on the left. On the right, you have your current chart type with the data beneath.

Use the Chart Type drop-down box next to the data series you want to change. Commonly, using a line or line with markers for the second axis works well. However, you can choose another option like area or scatter with lines for a unique appearance if you like.

Then, check the box to the right of the same series for “Secondary Axis.”

You’ll then see a preview of the updated chart. As you can see, the second axis stands out on its own and also includes the values along the right side. Both of which make the data much easier to understand.

Note: Combo charts normally work with the column chart type. So, you may have to adjust this if you’re using a bubble chart or other kind of graph.

When you finish, click “OK” to apply the change to the chart in your sheet. You can then add axis titles or set up data labels for even more clarity.

RELATED: 6 Tips for Making Microsoft Excel Charts That Stand Out

Remove a Secondary Axis in Excel

If you decide later that you no longer want a secondary axis in your chart, the way you remove it depends on how you want to display the remaining data.

You can remove the axis and corresponding data from your two-axis chart quickly and easily. Select the secondary axis on the chart and press your Delete key.

You’ll then see both removed from the chart.

You can keep the data on the chart and change its type just like the example above for converting it to a combo chart.

Right-click the data series and pick “Change Series Chart Type.”

Then, choose the type in the drop-down menu. Be sure to uncheck the box for Secondary Axis. Click “OK” to apply the change.

Right-click the data series and pick “Format Data Series.”

When the sidebar opens, select the Primary Axis option in the Series Options section. Note that you should be directed to this exact spot from the shortcut menu.

Again, depending on the chart type, you may need to change the style of the axis after you convert it. You can do this by right-clicking, choosing “Change Series Chart Type,” and picking the style as described earlier.

By adding a secondary axis in Excel, you can improve your chart’s readability to make it a more useful visual. For more, look at how to choose a chart to fit your data in Excel.