当您想要直观地显示不同的数据集时，可以创建组合图表。如果您想显示诸如销售额与成本或流量与转化之类的内容，Microsoft Excel中的组合图是理想的选择。
我们将向您展示如何在 Excel 中创建组合图表(chart in Excel)，以及如何对其进行自定义以包含您需要的元素并赋予其有吸引力的外观。
如何在Excel中创建(Excel)组合图表(Combo Chart)
您可以通过多种方法在Excel中创建组合图表。您可以转换现有图表、选择快速组合图表类型或设置自定义图表。
(Convert)将现有图表(Existing Chart)转换为组合图表(Combo Chart)
如果您已有显示数据的图表（例如条形图甚至饼图）(a pie chart)，则无需将其删除并从头开始。只需(Simply)将其转换为组合图即可。
- 选择您当前的图表并转到图表设计(Chart Design)选项卡。
- (Choose Change Chart Type)在功能区的
“类型”部分中(Type)选择“更改图表类型” 。
- 当图表窗口打开时，选择左侧的
组合。(Combo)
- 然后，选择顶部的组合图表布局之一并自定义底部的系列。
- 选择“确定”(Choose OK)，您将看到新图表取代了原始图表。
选择快速组合图表类型
Excel 提供了三种组合图表类型，您可以从中选择数据。
选择您的数据集并转到“插入”(Insert)选项卡。
在“图表”(Charts)组中，选择“插入组合图表”(Insert Combo Chart)下拉箭头以查看选项。从带有折线图的簇状柱形图、带有辅助轴的簇状柱形图和折线图或者堆积面积和簇状柱形图中
进行选择。(Pick)
然后，您会看到您选择的图表类型直接弹出到电子表格中。
创建自定义组合图表
如果您没有现有图表，并且希望从一开始就自定义组合图表的系列和轴，则可以创建自定义图表。
- 选择您的数据集并转到“插入”(Insert)选项卡。
- 选择插入组合图表(Insert Combo Chart)下拉箭头并选择创建自定义组合图表(Create Custom Combo Chart)。
- 当图表窗口打开时，您将在顶部看到四种组合图表类型。选择其中之一(Select one)作为自定义图表的基础。
- 在底部，您将看到数据系列、图表类型以及用于选择辅助轴的选项。当您进行调整时，您将在上方看到组合图的精美预览。
- 虽然柱形图和折线图可以很好地配合使用，但如果您愿意，您可以为每个数据系列选择不同的图表类型。选择要更改的系列右侧
图表类型(Chart Type)下方的下拉框，然后选择新的图表类型。
- 默认情况下，第一个数据系列显示在主轴上。但是，您可以更改此设置，或者只需使用右侧的
辅助轴(Axis)复选框添加辅助轴。
- 创建自定义组合图后，选择“确定”保存它并将其放置在工作表上。
如何自定义组合图
选择并插入组合图表后，您可能想要添加更多元素或为图表增添一些活力。Excel提供了多种用于自定义图表的功能。
转到图表设计选项卡
对于基本外观功能和图表元素，请选择图表并转到“图表设计”(Chart Design)选项卡。
从功能区左侧开始，您可以使用“添加图表元素”(Add Chart Element)下拉菜单来添加和定位图表标题、数据标签和图例等项目。
在右侧，使用“快速布局”(Quick Layout)菜单更改布局以包含和定位元素，而无需逐一执行此操作。
在“图表样式”(Chart Styles)部分中，您可以使用“更改颜色”(Change Colors)下拉菜单来选择不同的配色方案，或使用“样式”(Styles)框来选择全新的设计。
使用功能区上的其余选项，您可以切换列和行、更改图表数据(the chart data)选择、选择新的图表类型或将图表移动到另一张工作表。
打开格式图表区域侧边栏
要更改图表字体、添加边框以及定位图表和文本，请右键单击图表并选择“设置图表区域格式”(Format Chart Area)。这将在右侧打开一个侧边栏，您可以在其中进行更详细的调整。
根据您要更改的项目，使用(Use Chart) 侧边栏顶部的图表选项(Options)或文本选项。(Options)然后，您可以使用正下方的选项卡进行更改。
图表(Chart)选项：更改填充和边框样式和颜色，添加阴影或柔化边缘等效果，以及设置图表的大小或位置。
文本选项：更改填充或轮廓样式和颜色、添加效果以及定位或对齐文本。
使用图表按钮(Chart Buttons)（仅限
Windows ）
对图表进行调整的另一种方法是使用图表右侧显示的按钮。这些目前仅在Windows(Windows)上的Microsoft Excel中可用，在Mac 上(Mac)不可用。
图表元素(Chart Elements)（加号）：与“图表设计”选项卡上的(Chart Design)“图表元素”(Chart Elements)下拉框类似，您可以在图表上添加、删除和定位项目。
图表样式(Chart Style)（画笔）：与“图表设计”选项卡上的(Chart Design)“图表样式”(Chart Styles)部分类似，您可以为图表选择不同的配色方案或样式。
图表过滤器(Chart Filters)（过滤器）：使用此按钮，您可以选中或取消选中要在图表上显示的数据集中的详细信息。这为您提供了一种通过暂时隐藏其他详细信息来仅查看特定图表数据的快速方法。
现在您已经知道如何在Excel中创建组合图，接下来看看如何为您的下一个项目制作甘特图(make a Gantt chart)。
How to Create a Combo Chart in Microsoft Excel
When you want to display different data sets visually, you can create а combination chart. If yoυ want to show something like ѕales with costѕ or traffic with conversions, а combo chart in Microsoft Excel is ideal.
We’ll show you how to create a combo chart in Excel as well as customize it to include the elements you need and give it an attractive appearance.
How to Create a Combo Chart in Excel
You have a few ways to create a combo chart in Excel. You can convert an existing chart, select a quick combo chart type, or set up a custom chart.
Convert an Existing Chart to a Combo Chart
If you already have a chart showing your data, like a bar chart or even a pie chart, you don’t have to delete it and start from scratch. Simply turn it into a combo chart.
- Select your current chart and go to the Chart Design tab.
- Choose Change Chart Type in the Type section of the ribbon.
- When the chart window opens, pick Combo on the left.
- Then, select one of the combo chart layouts at the top and customize the series at the bottom.
- Choose OK and you’ll see your new chart replace the original one.
Select a Quick Combo Chart Type
Excel offers three combo chart types that you can pick from for your data.
Select your data set and go to the Insert tab.
In the Charts group, choose the Insert Combo Chart drop-down arrow to see the options. Pick from a clustered column with a line chart, a clustered column and line chart with a secondary axis, or a stacked area and clustered column chart.
You’ll then see the chart type you pick pop right onto your spreadsheet.
Create a Custom Combo Chart
If you don’t have an existing chart and prefer to customize the series and axis for the combo chart from the start, you can create a custom chart.
- Select your data set and go to the Insert tab.
- Choose the Insert Combo Chart drop-down arrow and pick Create Custom Combo Chart.
- When the chart window opens, you’ll see four combo chart types at the top. Select one of these as the base for your custom chart.
- At the bottom, you’ll see your data series, chart types, and options to pick a secondary axis. As you make your adjustments, you’ll see a nice preview of the combo chart directly above.
- While a column chart and line graph work well together, you can choose a different chart type for each data series if you like. Select the drop-down box below Chart Type to the right of the series you want to change and select the new chart type.
- By default, the first data series displays on the primary axis. However, you can change this or simply add a secondary axis using the Secondary Axis check boxes on the right side.
- When you finish creating your custom combo chart, pick OK to save it and place it on your worksheet.
How to Customize a Combo Chart
Once you choose and insert your combo chart, you may want to add more elements or give the chart some pizzazz. Excel offers several features for customizing a chart.
Go to the Chart Design Tab
For basic appearance features and chart elements, select your chart and go to the Chart Design tab.
Starting on the left side of the ribbon, you can use the Add Chart Element drop-down menu to add and position items like the chart title, data labels, and legend.
To the right, use the Quick Layout menu to change the layout to include and position elements without having to do so one-by-one.
In the Chart Styles section, you can use the Change Colors drop-down menu to pick a different color scheme or the Styles box to choose a whole new design.
With the remaining options on the ribbon, you can switch columns and rows, change the chart data selection, pick a new chart type, or move the chart to another sheet.
Open the Format Chart Area Sidebar
For changing the chart font, adding a border, and positioning the chart and text, right-click the chart and choose Format Chart Area. This opens a sidebar on the right where you can make more detailed adjustments.
Use Chart Options or Text Options at the top of the sidebar depending on which item you want to change. You can then use the tabs directly beneath to make your changes.
Chart Options: Change the fill and border styles and colors, add effects like a shadow or soft edge, and set the size or position for the chart.
Text Options: Change the fill or outline styles and colors, add effects, and position or align the text.
Use the Chart Buttons (Windows Only)
One more way to make adjustments to your chart is to use the buttons that display on the right side of it. These are currently only available in Microsoft Excel on Windows, not Mac.
Chart Elements (plus sign): Like the Chart Elements drop-down box on the Chart Design tab, you can add, remove, and position items on the chart.
Chart Style (paint brush): Like the Chart Styles section on the Chart Design tab, you can pick a different color scheme or style for your chart.
Chart Filters (filter): With this button, you can check or uncheck the details in your dataset that you want to display on your chart. This gives you a quick way to view only specific chart data by hiding other details temporarily.
Now that you know how to create a combo chart in Excel, look at how to make a Gantt chart for your next project.
