在Excel 2010中的2个轴上创建折线柱形图

When you create a chart in Excel 2010, you can select a chart type on the Ribbon's Insert tab.

在Excel 2010中创建图表时，可以在功能区的“插入”选项卡上选择图表类型。

For some charts, instead of selecting one type, you might like to combine two different chart types, like the line-column chart shown below.

对于某些图表，您可能希望合并两种不同的图表类型，而不是选择一种类型，如下面所示的折线图。

旧图表向导 (The Old Chart Wizard)

In Excel 2003 and earlier versions, there were combination chart types available in the Chart Wizard. You could click on one of those, to quickly create your combination chart.

在Excel 2003和早期版本中，“图表向导”中提供了组合图表类型。 您可以单击其中之一，以快速创建组合图。

In Excel 2010 and Excel 2007, these combination charts, such as Line-Column and Line-Column on 2 Axes, aren't available in the Chart Type window.

在Excel 2010和Excel 2007中，“图表类型”窗口中不提供这些组合图表，例如2轴上的“线-列”和“线-列”。

However, you can easily create your own combination charts, by creating a chart, and then changing a specific series' chart type.

但是，您可以通过创建图表然后更改特定系列的图表类型来轻松创建自己的组合图表。

观看组合图视频 (Watch the Combination Chart Video)

Watch this video to see the steps for creating a line-column chart on 2 Axes, in the newer versions of Excel.

观看此视频，以查看在较新版本的Excel中在2个轴上创建折线图的步骤。

演示地址

下载样本文件 (Download the Sample File)

To download the sample file, and to see the written instructions, you can visit my Contextures website: Line-Column Combo Chart

要下载示例文件并查看书面说明，您可以访问我的Contextures网站： 线-列组合图

翻译自: https://contexturesblog.com/archives/2012/10/25/create-a-line-column-chart-on-2-axes-in-excel-2010/