如何在 Excel 中添加次坐标轴
单击数值较小的那个系列，打开“设置数据系列格式”，勾选次坐标轴。也可以在“更改图表类型 > 组合图”中把一个系列设为折线并指定到次轴。Google Sheets 在图表编辑器里将该系列的轴设为右轴。当一个系列是上万的收入、另一个是份额或很小的计数时，才需要次轴。
本文目录
快速解答
单击数值较小的那个系列，打开“设置数据系列格式”，勾选次坐标轴。也可以在“更改图表类型 > 组合图”中把一个系列设为折线并指定到次轴。Google Sheets 在图表编辑器里将该系列的轴设为右轴。当一个系列是上万的收入、另一个是份额或很小的计数时，才需要次轴。
检查要点
八行销售样本中，合计为 24450，东区为 9450，东区份额为 0.38650306748466257，Widget 份额为 0.8098159509202454。若与收入画在同一到 25000 的轴上，份额会贴在基线，看起来像没有数据。次轴不会改变底层数值，东区份额仍应是 9450/24450。
边界与兼容性
请为两个轴都加上标题，以免把金额和百分比弄混。不要把同一单位的两个系列只为了填满绘图区而分到两个轴上。若右轴顶点是 9450，说明误把收入放到了次轴；若是 38.65，可能把份额存成了百分数而不是 0.3865。饼图没有次轴。
完整英文示例、公式与作者备注
Excel How-toTested in: The totals and shares used as the two-scale example were evaluated in Google Sheets on 12 November 2026. Excel 365 menu names are the current desktop labels; I did not click through Format Data Series or the chart editor this session.
How to make a basic column, line, or pie chart is in How to Make a Chart in Excel. This page is only about a second vertical axis.
When you actually need a second axis
On the eight-sale sample, Revenue goes up to a grand total of 24450, and East is 9450. East’s share of that total is 0.38650306748466257; Widget’s share is 0.8098159509202454. If you plot Revenue and those shares on one axis that runs to 25,000, the share series sits on the baseline and looks like it has no data.
A second axis is for that mismatch in scale, not for a second category axis (dates vs text). If the axis is showing serial numbers such as 45299, that is a format problem, in chart dates showing as numbers.
Add the axis in Excel
- Create a chart that includes both series (for example Revenue as columns and Share as a line).
- Click the Share series (the small one). If it is hard to click, use Chart Design > Select Data or the Series drop-down on the Format pane.
- Right-click the series and choose Format Data Series.
- Under Series Options, select Secondary Axis.
- A vertical scale appears on the right. Set its number format to a percentage if the series is a share.
- Optionally use Chart Design > Change Chart Type > Combo to make one series a column and the other a line, and assign the line to the secondary axis in that same dialog.
Add an axis title on both sides (Chart Elements > Axis Titles) so a reader can see which scale is money and which is a percent. Do not force two series of the same unit onto two axes just to fill the plot area — that makes a 9450 and a 24450 look similar in height when they are not.
Add the axis in Google Sheets
- Open the chart editor.
- On the series you want on the right, set Axis to Right axis (under Customize > Series, or in Setup depending on the build).
- Format that axis as a percent if needed.
If Right axis is not offered, change the chart to a combo (columns plus a line) and try again. Some chart types, including pie, have no second axis.
Check the plotted numbers
The right axis does not change the underlying values. East’s share should still be 9450 ÷ 24450, which in the test workbook was 0.38650306748466257. If the line peaks at 1, you may have plotted the share correctly; if it peaks at 9450, you put Revenue on the right axis by mistake. If it peaks at 38.65, the series was stored as 38.65 instead of 0.3865 — format the axis to match the way the number is stored, or divide by 100 in a helper column.
A pivot already has the share if you used Show Values As % of Grand Total. You can chart that pivot, or compute the share next to the source with =B2/$B$10 and chart the helper column.
Once both series use a readable scale, confirm the category axis is still the one you intended (months, products, or regions) and that a legend names each series and, if the titles are short, which axis it uses.