How to Add a Secondary Axis in Mac Excel 2013

When creating charts in Excel, there are times when you need to compare two distinct types of series on the same graph. For instance, you might want to visualize sales data alongside growth percentages. In this case, a secondary axis can be a helpful tool in making your chart more informative and easy to understand.

In this article, we will explore how to add a secondary axis in Mac Excel 2013. We'll use a real-life example of a sales record for an XYZ company to demonstrate the process.

Let's start by assuming that our data is organized in an Excel sheet with three columns: Column A contains the name of months, Column B contains sales done in each month, and Column C contains the growth in comparison to last year's month. Our goal is to create a clustered column chart to visualize this data.

To begin, go to the 'Insert' tab and click on 'Charts' followed by 'Clustered Column Chart.' This will open the 'Chart Wizard' where you can select the chart type and customize its appearance.

Once you've created your chart, you might notice that there's no secondary axis. However, don't worry – we'll fix this in a moment!

To add a secondary axis, right-click on one of the columns in your chart and select 'Format Data Series.' In the 'Format Data Series' dialog box, click on the 'Series Options' tab and then check the box next to 'Secondary Axis.'

You will now see that a secondary axis has been added to your chart. This axis is marked on the right edge of the graph and measures a different value from the primary axis.

Using our example data, you can use this secondary axis to compare sales records with growth percentages. For instance, if you have a high sales record in January but a low growth percentage, your chart will clearly show this discrepancy.

In conclusion, adding a secondary axis in Mac Excel 2013 is a simple process that allows you to compare two distinct types of series on the same graph. By following these steps and using our example data, you should now be able to create informative charts that help you better understand your sales records.

How to add a secondary axis in mac excel 2013