How to Create Combo Chart in Microsoft Excel

This video will show you how to create combo chart in Microsoft excel. For illustration purpose it was used a data set with monthly sales values for a particular year and marketing expenses incurred to generate that particular revenue. The combo chart was created to show these two variables in a way that sales revenue showed as a stacked bar chart whereas monthly marketing expenses showed in a line chart.

.....................................................................................................................................................................

Flow of the Video

00:00 Introduction to the Combo Charts
00:40 Understanding the Context for the Combo Chart
01:14 Inserting a Combo Chart
01:50 Select Two Axis Data for the Combo Chart
02:52 Remove Grid Lines Behind the Chart Area
03:10 Remove Extra Space between Clustered Bars
03:58 Set Colours for the Bar Chart and Line Chart
05:02 Add Chart Title
05:34 Insert Axis Titles for the Combo Chart
06:13 Adding Further Formatting for the Combo Chart
06:46 Closing Statement

.....................................................................................................................................................................

A combo chart in Excel is a type of chart that allows you to combine two or more different chart types in a single chart. This can be useful when you want to visualize and compare different sets of data that have varying scales or data types. Combo charts are especially handy when you have both numerical and categorical data in your dataset.

Here are the key components of a combo chart in Excel:

Primary and Secondary Axes: Combo charts typically have a primary vertical axis on the left side (associated with one chart type) and a secondary vertical axis on the right side (associated with another chart type). The primary axis is used for one set of data, while the secondary axis is used for the other set of data. These axes can have different scales.

Chart Types: You can use different chart types for each data series in a combo chart. For example, you can use a bar chart for one data series and a line chart for another. Excel allows you to choose from various chart types, including bar, column, line, scatter, area, and more.

Data Series: Combo charts consist of multiple data series, each associated with a specific chart type. Each data series represents a set of data points you want to visualize. You can have one or more data series on the primary axis and one or more on the secondary axis.

Legend: A combo chart will have a legend that explains which chart type corresponds to each data series. The legend helps readers interpret the chart.

Data Labels and Axis Labels: You can add data labels to individual data points or data series to provide additional information. You should also include axis labels and titles to make the chart more informative.

.....................................................................................................................................................................

To create a combo chart in Excel, follow these steps:

Select Your Data: Highlight the data you want to chart, including both the x-values (categories) and y-values.

Insert a Chart: Go to the "Insert" tab on the Excel ribbon and select the desired chart type (e.g., bar chart, line chart) for one of your data series. This will create a chart with the selected data series.

Add More Data Series: After creating the initial chart, you can add more data series by right-clicking on the chart, choosing "Select Data," and then clicking "Add" to add new data series. You can specify the chart type for each new series.

Format the Chart: Customize your combo chart by formatting data series, axes, labels, and legends as needed.

Adjust Axes: If the scales of the primary and secondary axes are significantly different, you may need to manually adjust the axis scales to ensure the data is displayed clearly.

Combo charts are particularly helpful when you want to compare related data with different units of measurement or when you want to show trends and relationships between two or more datasets on the same chart. They provide a powerful tool for visualizing complex data in Excel.

~-~~-~~~-~~-~
Please watch: "(124) How to use SUMIF Function in Excel "
   • How to use SUMIF Function in Excel  
~-~~-~~~-~~-~