To add a secondary axis in Excel, first ensure your chart type supports it (like column, bar, line, or area), avoiding unsupported types like pie or radar charts. Next, with two data series present, click the chart, use the Chart Elements button to select Axes > Secondary Axis or right-click the data series and choose "Plot Series On > Secondary Axis". Finally, customize the appearance by matching colors, labeling both axes, adjusting scale values if needed, and changing chart types for clarity when one dataset is significantly smaller.

Adding a secondary axis in Excel is super handy when you're comparing two data sets that have different scales. Like, imagine you've got sales numbers in the thousands and percentage growth in single digits — trying to show both on the same axis makes one of them basically disappear. The fix? A secondary axis. Let's jump into how to do it.

Select the right chart type

Before even thinking about a secondary axis, make sure your chart supports it. Most combo charts (like column line) work well. If you're using something like a pie chart or a 3D chart, you’re out of luck — those don't support secondary axes.

Here’s what to check:

• Stick with column, bar, line, or area charts
• Avoid pie, doughnut, or radar charts
• Combo charts are often the easiest path

If you're not already on a compatible chart, convert it first by right-clicking the chart > Change Chart Type and picking a combo or standard format.

Add the secondary axis in just a few clicks

Once your chart is set up with two data series, here’s how to separate them:

1. Click on the chart to select it
2. Click the Chart Elements button (the plus sign)
3. Hover over Axes, then click the arrow next to it and choose Secondary Horizontal Axis or Secondary Vertical Axis, depending on what you need
4. Or, right-click the data series you want to move to the secondary axis > Format Data Series > Plot Series On > Secondary Axis

This will instantly add a second axis — usually on the right side for vertical or top for horizontal — and your selected data series will shift to use that instead.

Customize appearance so it doesn’t get confusing

Now that you’ve got two axes, things can get messy fast. Here’s how to clean it up:

• Make sure each data series clearly matches its axis (e.g., line color matches axis color)
• You can format the secondary axis by right-clicking it and choosing Format Axis — adjust min/max values if needed
• Label both axes so viewers know what they’re looking at
• If one data series is way smaller, consider changing its chart type (like switching from bar to line)

The goal is clarity — people shouldn’t have to guess which line goes with which scale.

And that’s pretty much it. Once you know where the options live, adding a secondary axis becomes second nature. It’s not complicated, but it’s easy to overlook unless you really need it — like when your boss asks why one data set looks flat when it’s actually doing great, just on a different scale.

The above is the detailed content of how to add a secondary axis to an excel chart. For more information, please follow other related articles on the PHP Chinese website!