How to Add or Remove a Secondary Axis in Microsoft Excel Charts

When you have a chart with mixed data types or a dataset that varies broadly between series, consider using a secondary axis in Microsoft Excel. With it, you can display the data you need without overwhelming or confusing your viewers.

When to Use a Secondary Axis

As mentioned, if you have different data types or your series amounts widely vary, these are good times to use a secondary axis.

For instance, you can see that the column chart below doesn’t accurately depict the visitors and sales in our dataset. There’s a large variance in the sales amounts, making it hard to get a decent picture of the number of visitors per month. Plus, the sales are in dollar amounts, whereas the visitors are basic number values.

If your chart would benefit from a secondary axis like this one, here’s how to add one as well as remove a secondary axis later if you change your mind or your data.

How to Add a Secondary Axis in Excel

To add a secondary axis to your Excel chart, you’ll use the combo chart type. If you’re using a different chart, like a line graph or bar chart, you can change it easily.

  1. Select your chart and go to the Chart Design tab to see the chart options.
  2. Choose Change Chart Type in the Type section. Tip: You can also right-click the chart and pick Change Chart Type.
  1. On the left side of the pop-up dialog box, pick Combo.
  1. On the right side, pick the chart at the top that uses the “Line on Secondary Axis” as shown below.
  1. Use the drop-down boxes at the bottom to customize the types of charts for each series or the checkboxes to change which series displays as the Secondary Axis.
  1. When you finish, select OK to apply the change to your chart.

You’ll then see your updated chart with its secondary vertical axis (y-axis), which should provide a more accurate visualization of the data.

How to Remove a Secondary Axis in Excel

If you update your data and no longer need the secondary axis or simply decide that you’d like to remove it, you can do this one of two ways.

Select the chart, go to the Chart Design tab, and do one of the following.

Remove the Axis

To just remove the secondary axis without any other changes to the chart, follow these steps:

  1. Open the Add Chart Element drop-down menu,
  2. Move to Axes.
  3. Deselect the corresponding Secondary option.

Remove the Axis and Change the Chart

To remove the axis and adjust the chart at the same time, such as returning it to a previous chart type, use these steps instead:

  1. Pick Change Chart Type.
  2. Either uncheck the box for the Secondary Axis at the bottom or pick a chart design at the top without the secondary axis as shown below.
  1. Make any other adjustments you’d like and select OK to apply the changes.

Adding a secondary y-axis to your chart can help you as well as others understand complex data in a more meaningful way. Now that you know how to add a secondary axis in Excel, check out our tutorial for adding error bars to a chart in Excel too.



Source : How to Add or Remove a Secondary Axis in Microsoft Excel Charts

Comments

Post a Comment

Popular posts from this blog

How to Use and Customise the Status Bar in Microsoft Excel

Image
Excel’s status bar is one of the hidden gems (and an unsung hero) that makes it the default spreadsheet software you turn to. It quietly resides at the bottom of the Excel window, often overlooked but brimming with valuable information and customization options. In this article, we will look at it and show you how to take advantage of it. Excel Status Bar Default Options Even before you customize the Excel status bar, it’ll display some helpful information and give you access to some useful functionalities. The common Excel options you can find as default on the status bar are: Cell Mode Macro Recording Tool Accessibility Check Page Number Statistics/Mathematical Options Worksheet Views Zoom Options Let’s see what each of them does and how you can use them. Cell Mode At the leftmost side of the Excel status bar, you’ll find the cell mode indicator. It’ll inform you about the status of the currently selected cell. There are four different status modes: Ready . It ...
Read more

What Is Windows AI-Powered Copilot?

Image
Microsoft has released its brand-new artificial intelligence (AI) companion, Microsoft Copilot. Previously known as Bing Chat, Copilot has a series of new abilities that can help you get more done in less time. In this article, we’ll provide a brief description of each of Microsoft’s new AI copilots, then we’ll focus on the Windows 11 copilot and what it can do to boost your productivity. What Is Microsoft Copilot? Microsoft Copilot is an artificial intelligence chatbot you can ask to perform different tasks, including generating text and images and answering general questions. Microsoft’s plan is to have a Copilot in each of its apps to provide assistance and improve user experience across the Microsoft ecosystem. Here are the different Copilots that are currently available or slated for future release: Windows 11 Copilot: Available for free as a preview in North America, Asia, and South America, Windows 11 Copilot lets you perform tasks, get answers, and create AI-generate...
Read more