资讯
This article explains how to add a secondary axis to a chart in Excel so you can view unlike categories on the same graph. These instructions work in Excel in Microsoft 365, Excel 2021, Excel 2019 ...
In the Format Data Series pane, click Secondary Axis and change the Gap Width to 500%, as shown in Figure G. Doing so reduces the bar’s width so it looks less like a column and more like a line.
Here are six tips to turn you into a spreadsheet pro whether you're using Microsoft Excel or Google Sheets. Alphabetize your data You can customize your spreadsheet data a number of ways ...
And put it in a secondary axis by selecting that option. Then click OK. 2011 (Mac): With the Conversion Rate series selected, choose Charts tab > Change Series Chart Type > Line > 2-D Line > Line.
一些您可能无法访问的结果已被隐去。
显示无法访问的结果