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
1841 views

An error occurred while attempting to play the video

Disponible dans Microsoft365

DiLeap AI: CE QUI POURRAIT VOUS INTÉRESSER

Excel - Combo chart

In this video, you will learn about combo charts and how to create them using Microsoft 365. The video demonstrates how to add a combo chart to visualize different types of information.
It shows how to select the data, access the combo chart options, and choose the appropriate chart type.
By using a combo chart, you can highlight the product price in a bar graph and the conversion rate in a line graph.
This tutorial is essential for anyone looking to create visually appealing and informative charts in Microsoft 365.

561 views

Excel - Create a chart

In this video, you will learn how to create a chart using Microsoft 365. The video covers the process of selecting the cells you want to use for the chart, clicking the quick analysis button, and accessing the Charts tab.
Excel then displays recommended charts based on the selected data.
You can hover over each chart option to see which one looks best for your data.
The video demonstrates creating a clustered column chart, which is great for comparing data.
By following the steps in the video, you will be able to create eye-catching charts that make it easier to analyze your data.
This tutorial is essential for anyone using Microsoft 365 and looking to improve their data visualization skills.

0:52
1186 views

Excel - Create pie, bar, and line charts

In this video, you will learn how to create pie, bar, and line charts using Microsoft 365. The video demonstrates the process of selecting the cells you want to chart and clicking on the Charts option.
Excel will display recommended chart options based on the selected data.
However, it's important to note that the options may vary depending on the data.
The video shows how to create a pie chart by selecting the cells and clicking on the pie option.
It also explains that a pie chart can only display one data series.
The video then moves on to creating a bar chart using the same data, highlighting how charting the data in different ways can provide different perspectives and insights.
The video concludes by mentioning that there are many more chart options available in the Insert tab of the Charts group.
It recommends using the Recommended charts option to find the best chart for the selected data.
Finally, the video demonstrates how to create a line chart with markers, which can be a better option than a pie chart for displaying multiple data series.
This tutorial will help you create visually appealing and informative charts using Microsoft 365, enhancing your data analysis skills.

3:13
1441 views

Excel - Create a PivotChart

In this video, you will learn how to create a PivotChart using Microsoft 365. The video demonstrates the process of creating a new sheet, selecting the data, and creating the PivotChart.
It also shows how to add filters and modify the chart to customize it according to your needs.
Creating a PivotChart allows you to visualize and analyze data in a more dynamic and interactive way.
This tutorial will help you master the skill of creating PivotCharts using Microsoft 365, enhancing your data analysis capabilities.

566 views

Excel - Stacked Bar Chart

In this video, you will learn about stacked bar charts.
The video covers how to create and customize a stacked bar chart using Microsoft 365. It demonstrates how to adjust the axis values, remove the chart title, switch to a stacked bar chart, and customize the gridlines and data labels.
This will help you create visually appealing and informative stacked bar charts for data visualization.

523 views

RELATED COURSES This tutorial is part of the following courses

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 Power Pivot, combined with the Power Query tool.

Your trainer for this course
Cours E-learning

184 vues

ALL COURSES