Platform Banner

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

Available in Microsoft365

Objectifs :

This video aims to teach viewers how to create various types of charts in Excel, including pie, bar, and line charts, while emphasizing the importance of selecting the appropriate chart type based on the data being analyzed.

Chapitres :

Introduction to Chart Types
In this video, we will explore how to create pie, bar, and line charts in Excel. Understanding which chart type to use with specific data sets is crucial for effective data visualization.
Creating a Pie Chart
To create a pie chart, first select the cells containing the data you wish to analyze. Then, click on the 'Charts' option in Excel. The software will display recommended chart options based on your selected data. Keep in mind that these options may vary depending on the data you choose. After selecting the pie chart option, your chart will be created. Note that pie charts can only represent one data series effectively.
Customizing the Pie Chart
Once the pie chart is created, you can move and resize it for better visibility and customization. To do this, click on the chart, hold down the left mouse button, and drag it to your desired location. You can also resize the chart by clicking and dragging the bottom right corner.
Limitations of Pie Charts
It's important to recognize that pie charts are not suitable for displaying too much data. If you attempt to graph excessive data in a pie chart, it can become cluttered and difficult to interpret.
Creating a Bar Chart
Next, we will create a bar chart using the same data from the pie chart. Charting the same data in different ways can provide new insights and perspectives. To create a bar chart, select the data, click on the 'Insert' tab, and choose the 'Charts' group. Here, you can find various chart options.
Exploring Chart Options
In the 'Charts' group, you can click on 'Recommended Charts' to see which charts work best with your selected data. For a broader selection, click on 'All Charts' to explore the different types of charts available in Excel.
Creating a Line Chart
Since a pie chart is not recommended for the data we selected, we will create a line chart instead. To do this, select the data, click on 'Line', and then choose 'Line with Markers'. After pointing to your desired option, click 'OK' to create the line chart.

FAQ :

What types of charts can I create in Excel?

In Excel, you can create various types of charts including pie charts, bar charts, line charts, and many more. The type of chart you choose depends on the data you want to represent.

How do I create a pie chart in Excel?

To create a pie chart in Excel, select the cells containing the data you want to chart, click on the 'Insert' tab, and then choose 'Pie Chart' from the Charts group. Excel will create the chart based on your selected data.

Can I use multiple data series in a pie chart?

No, a pie chart can only display one data series. If you have multiple data series, consider using a bar chart or line chart instead.

What is the purpose of using different types of charts?

Using different types of charts allows you to visualize data from various perspectives, which can help uncover insights and trends that may not be apparent with a single chart type.

What should I do if my pie chart looks cluttered?

If your pie chart looks cluttered, it may be due to too much data being represented. Consider simplifying your data or using a different chart type, such as a bar chart, to improve clarity.

Quelques cas d'usages :

Sales Data Analysis

A sales manager can use pie charts to visualize the proportion of total sales contributed by each product category. This helps in identifying which categories are performing well and which need improvement.

Monthly Expense Tracking

An individual can create a bar chart to track monthly expenses across different categories (e.g., food, transportation, entertainment). This visual representation helps in budgeting and identifying spending patterns.

Trend Analysis in Marketing

A marketing analyst can use line charts to track website traffic over time. By plotting data points for each month, they can identify trends and make informed decisions about marketing strategies.

Project Progress Monitoring

A project manager can utilize bar charts to compare the progress of different tasks within a project. This allows for quick identification of tasks that are behind schedule and need attention.

Weather Data Visualization

A meteorologist can create line charts with markers to display temperature changes over a week. This helps in visualizing daily fluctuations and predicting future weather patterns.

Glossaire :

Clustered Column Chart

A type of chart that displays data using vertical bars grouped together for comparison. Each group represents a category, and the height of the bars indicates the value.

Pie Chart

A circular chart divided into sectors, each representing a proportion of the whole. It is used to display a single data series.

Bar Chart

A chart that presents categorical data with rectangular bars, where the length of each bar is proportional to the value it represents.

Line Chart

A type of chart that displays information as a series of data points called 'markers' connected by straight line segments. It is useful for showing trends over time.

Data Series

A set of related data points that are plotted on a chart. In a pie chart, only one data series can be displayed.

Quick Analysis

A feature in Excel that provides a fast way to analyze data and create charts based on selected cells.

Insert Tab

A tab in Excel's ribbon that contains options for inserting various elements into a worksheet, including charts.

Recommended Charts

A feature in Excel that suggests the most suitable chart types based on the selected data.

Markers

Points on a line chart that represent individual data values, often displayed as dots or symbols.

00:00:06

In this video, we're going to create pie, bar and line charts.

00:00:13

Each type of chart highlights data differently

00:00:16

and some charts can't be used with some types of data.

00:00:21

We'll go over this shortly.

00:00:24

To create a pie chart, select the cells you want to chart,

00:00:28

click Quick analysis and click Charts.

00:00:33

Excel displays recommended options based on the data in the cells you select.

00:00:39

So the options won't always be the same.

00:00:42

I'll show you how to create a chart that isn't a quick analysis option shortly.

00:00:47

Click the pie option and your chart's created.

00:00:52

You can chart only one data series with a pie chart.

00:00:55

In this example, those are the cells figures in cells B2 through B5.

00:01:02

I'm going to move and resize the chart so it displays without having to scroll,

00:01:07

which will also make it easier to customise;

00:01:10

something we'll look at in the next video.

00:01:13

I click the chart, hold down the left mouse button and drag to move it.

00:01:21

I scroll down a little,

00:01:24

click the bottom right-hand corner of the chart

00:01:26

and drag it up into the left to make it smaller.

00:01:30

Different data displays better in different types of charts.

00:01:33

If you try to graph too much data in a pie chart, it looks like this.

00:01:39

Not very useful.

00:01:40

Now I'm creating a bar chart using the same data we used to create the pie chart.

00:01:47

Charting the same data different ways

00:01:50

can provide you with a different perspective

00:01:53

that may help you discover different insights in the data.

00:01:57

We're creating some of the more common chart types

00:01:59

but there are many more options.

00:02:02

To create charts that aren't quick analysis options,

00:02:06

select the cells you want to chart,

00:02:11

click the Insert tab;

00:02:14

in the Charts group we have a lot of options.

00:02:17

Click Recommended charts to see the charts that will work

00:02:20

best with the data you've selected.

00:02:23

Click All charts for even more options.

00:02:27

These are all of the different types of charts you can create.

00:02:32

As I mentioned earlier, a pie chart isn't a recommended

00:02:35

option for the data we selected because it can only display one data series.

00:02:41

We can make a pie chart but it would only show the first data series,

00:02:46

the average precipitation for New York

00:02:48

and on the second data series, the average precipitation for Seattle.

00:02:54

Instead, let's make a line with markers chart.

00:02:59

Click Line, click Line with marker,

00:03:03

point to an option and you get a preview of the chart;

00:03:07

click OK.

00:03:09

We've created our line chart.

RELATED COURSES This tutorial is part of the following courses

2874 Views

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 introduct...

ALL COURSES