Excel - Create pie, bar, and line charts Tutorial

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

An error occurred while attempting to play the video

Disponible dans Microsoft365

DiLeap AI: CE QUI POURRAIT VOUS INTÉRESSER

Excel - Pie chart

In this video, you will learn about pie charts and how to create them using Microsoft 365. The video demonstrates how to switch from a bar chart to a 2D pie chart and change the colors to distinguish each category.
It also shows how to add a legend for better analysis and provides options for formatting the chart.
Additionally, it mentions that using column graphs is generally recommended over pie charts or doughnut charts.
This tutorial will help you understand the basics of creating and customizing pie charts in Microsoft 365.

485 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
1197 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 - Bar chart

In this video, you will learn how to customize a bar chart using Microsoft 365. The video demonstrates how to select and insert the data, adjust the chart's appearance, add data labels, and highlight specific values.
It also shows how to switch the chart type to better display a larger list of items.
By following these steps, you will be able to create visually appealing and practical bar charts for data visualization.
This tutorial is essential for anyone looking to enhance their data analysis skills using Microsoft 365.

537 views

Excel - Create your first chart

In this video, you will learn how to create your first chart using Microsoft 365. The tutorial guides you through the process step by step, starting with opening the necessary folders and selecting the data for your chart.
It shows you how to access the recommended charts and choose the most suitable one for your data.
You will also learn how to customize the chart's appearance by changing colors and styles.
This tutorial is a great resource for beginners who want to create visually appealing charts in Microsoft 365.

473 views

RELATED COURSES This tutorial is part of the following courses

Video Training Microsoft Excel - Discovery level

Discover and familiarize yourself with Excel: from creating and using your tables to enhancing your visuals and collaboration. Our introductory Excel tutorials combine simplicity and efficiency!

Your trainer for this course
Cours E-learning

243 vues

ALL COURSES