如何在 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.