Excel - Create a combo chart Tutorial

In this video, you will learn how to create a combo chart using Microsoft 365. A combo chart allows you to combine different types of data, such as temperature and precipitation, in one chart.
By including a secondary axis, you can better visualize data with different value ranges.
To create a combo chart, select the cells you want to chart and go to the Insert tab on the ribbon.
Click the combo button and choose an option that suits your needs.
You can also move and resize the chart to make it easier to work with.
To enhance the chart, you can add a title and a secondary axis for precipitation.
In the task pane, select Secondary axes and make the chart clearer by adding axis titles.
Creating a combo chart in Microsoft 365 will help you effectively display and analyze different types of data in one chart.
This tutorial provides step-by-step instructions for creating a combo chart and optimizing your data visualization.

1:47
4970 views

Available in Microsoft365

Objectifs :

This video aims to teach viewers how to effectively use combo charts to visualize different types of data, such as temperature and precipitation, by utilizing a secondary axis for better clarity and understanding.

Chapitres :

Introduction to Combo Charts
Combo charts are a powerful tool for visualizing multiple types of data that often have different value ranges. By combining two or more chart types, such as line and bar charts, you can create a more comprehensive view of your data.
Creating a Combo Chart
To create a combo chart, follow these steps: 1. **Select the Data**: Highlight the cells containing the data you want to chart. 2. **Insert Tab**: Click on the 'Insert' tab located on the ribbon. 3. **Combo Chart Option**: Click the combo chart button and choose the desired chart option. Note that a combo chart is not a quick analysis option, so it requires a few more steps to set up.
Resizing and Title Adjustment
Once the chart is created, you may want to move and resize it for better visibility. Additionally, giving the chart a clear title helps convey the information effectively.
Adding a Secondary Axis
To enhance the clarity of your combo chart, especially when dealing with different data types like precipitation, you can add a secondary axis. Here’s how: 1. **Select the Precipitation Line**: Click on the line representing precipitation in the chart. 2. **Task Pane**: In the task pane, select 'Secondary Axis'. 3. **Axis Titles**: For further clarity, consider adding axis titles. Click the chart element button, then select the title boxes to add appropriate titles.
Copying a Chart
If you need to replicate your chart for another dataset or presentation, you can easily copy the chart. This allows for efficient use of your visualizations across different contexts.

FAQ :

What is a combo chart?

A combo chart is a graphical representation that combines two or more different types of charts, such as bar and line charts, to display multiple data series with varying value ranges. This allows for better comparison and analysis of the data.

How do I add a secondary axis in a combo chart?

To add a secondary axis in a combo chart, select the data series you want to represent on the secondary axis, then right-click and choose 'Format Data Series.' In the task pane, select 'Secondary Axis' to enable the secondary axis for that series.

Why would I use a combo chart?

A combo chart is useful when you want to compare different types of data that have different value ranges, such as temperature and precipitation. It allows for a clearer visual representation of how these data sets relate to each other.

Can I customize the titles of my chart axes?

Yes, you can customize the titles of your chart axes. Click on the chart element button, select the title boxes, and enter your desired titles to provide context for the data represented on each axis.

What should I do if my combo chart looks cluttered?

If your combo chart looks cluttered, consider resizing the chart, adjusting the data series displayed, or simplifying the chart by removing unnecessary elements. You can also use different colors or styles to differentiate the data series more clearly.

Quelques cas d'usages :

Weather Data Analysis

A meteorologist can use a combo chart to analyze temperature and precipitation data over time. By using a secondary axis for precipitation, they can easily compare trends and identify correlations between temperature changes and rainfall patterns.

Sales Performance Review

A sales manager can create a combo chart to visualize monthly sales revenue alongside the number of new customers acquired. By using a secondary axis for customer numbers, the manager can assess the impact of customer acquisition on sales performance.

Financial Reporting

An accountant can utilize a combo chart to present revenue and expenses in a financial report. By displaying expenses on a secondary axis, stakeholders can quickly understand the relationship between income and expenditures.

Project Management

A project manager can apply a combo chart to track project milestones against budget expenditures. By using a secondary axis for budget, the manager can effectively communicate project progress and financial health to stakeholders.

Marketing Campaign Analysis

A marketing analyst can use a combo chart to compare website traffic and conversion rates during a campaign. By placing conversion rates on a secondary axis, they can evaluate the effectiveness of marketing strategies in driving sales.

Glossaire :

Combo Chart

A type of chart that combines two or more different chart types to represent multiple data series with varying value ranges, allowing for better comparison and analysis.

Secondary Axis

An additional vertical axis on a chart that allows for the representation of data series with different value ranges, making it easier to visualize relationships between them.

Chart Element

Components of a chart, such as titles, axes, legends, and data labels, that can be customized to enhance the chart's clarity and effectiveness.

Insert Tab

A section in the ribbon of spreadsheet software (like Microsoft Excel) where users can find options to insert various elements, including charts, tables, and images.

Axis Titles

Labels that describe the data represented on the axes of a chart, providing context and clarity to the viewer.

00:00:05

such as temperature and precipitation

00:00:07

by combining two or more chart types in one combo chart.

00:00:12

Different types of data often have different value ranges

00:00:16

and with a combo chart, you can include a secondary axis.

00:00:23

Select the cells you want to chart.

00:00:26

Combo chart isn't a quick analysis option.

00:00:29

So we click the Insert tab on the ribbon,

00:00:32

click the combo button and choose an option.

00:00:39

I'm moving and resizing the chart to make it easier to work with.

00:00:50

I give the chart a title.

00:00:57

Adding a secondary axis for precipitation will make the chart easier to understand.

00:01:03

I double-click the precipitation line in the chart

00:01:07

and select Secondary axes in the task pane.

00:01:14

It would make the chart even clearer if we added axis titles.

00:01:19

Click the chart element button,

00:01:22

click the arrow besides axis titles,

00:01:25

select Primary vertical and Secondary vertical,

00:01:30

click the title boxes and type the appropriate text.

00:01:43

Up next, copy a chart.

Mandarine AI: WHAT YOU SHOULD KNOW

RELATED COURSES This tutorial is part of the following courses

2674 Views

Video Training Microsoft Excel - Advanced level

With our "advanced" tutorials, discover and master the full potential of Excel, using complex functions, macros and the power of DCTs and Po...

ALL COURSES