Platform Banner

Excel - Change chart type Tutorial

In this video, you will learn how to change the chart type in Microsoft Excel.
The video demonstrates how to select the chart, navigate to the Chart Design tab, and use the "Change Chart Type" button to switch to a different chart type.
It also shows how to switch chart styles and modify the legend position.
This knowledge will help you enhance your data visualization skills in Excel.

1:29
2549 views

Available in Microsoft365

Objectifs :

In this tutorial, we will learn how to change the type of a chart in Excel, building on the previous lesson where we created our first graph. We will explore the steps to modify chart types and styles effectively.

Chapitres :

Introduction to Chart Modification
In our previous tutorial, we learned how to create our first graph in Excel. This session focuses on how to change the chart type, allowing for better data visualization and presentation.
Accessing the Workbook
To begin, navigate to the folder labeled 'Step Four: Data Visualization.' Open the subfolder 'Create Your First Graph' and access the workbook titled 'Create Your First Graph Course.' This workbook contains the data we will be working with.
Changing the Chart Type
We initially inserted a linear chart, but now we want to change it to a different type. First, increase the size of the chart for better visibility. Once the chart is selected, the 'Chart Design' tab will appear. On the right side, locate the 'Change Chart Type' button. Clicking this will open a window displaying all available chart types in Excel.
Selecting a New Chart Type
In the chart type window, select 'Clustered Column' from the options available. After making your selection, click 'OK' to apply the changes. The chart type will now be updated to reflect your choice.
Modifying Chart Styles
In addition to changing the chart type, you can also modify the chart's style. Return to the 'Chart Styles' section and click to see more options. Hover over different styles to preview them. Once you find a style you like, select it to apply. If you have not altered the legend, it will automatically transfer to the new chart.
Conclusion
You have now learned how to modify the chart type and style in Excel. These skills will enhance your ability to present data effectively, making your charts more visually appealing and informative.

FAQ :

How do I change the chart type in Excel?

To change the chart type in Excel, select the chart you want to modify, go to the Chart Design tab, and click on the 'Change Chart Type' button. From there, you can choose a new chart type from the available options.

What are the different types of charts available in Excel?

Excel offers various chart types, including column, bar, line, pie, area, scatter, and more. Each type serves different purposes for data visualization.

Can I customize the style of my chart in Excel?

Yes, you can customize the style of your chart by selecting the chart and then choosing from the Chart Styles options available in the Chart Design tab. You can hover over different styles to preview them before applying.

What is the purpose of a legend in a chart?

The legend in a chart serves to identify the different data series represented in the chart. It helps viewers understand what each color or symbol corresponds to in the data.

How can I increase the size of my chart in Excel?

To increase the size of your chart in Excel, click on the chart to select it, then drag the corners or edges to resize it to your desired dimensions.

Quelques cas d'usages :

Sales Data Visualization

A sales manager can use different chart types to visualize monthly sales data, switching from a linear chart to a clustered column chart to better compare sales across different products.

Project Timeline Tracking

A project manager can utilize a linear chart to track project milestones over time, and later change it to a bar chart for a clearer comparison of task durations.

Financial Reporting

An accountant can create a pie chart to represent the distribution of expenses in a financial report, then switch to a column chart to highlight trends in spending over several months.

Survey Results Analysis

A researcher can visualize survey results using a clustered column chart to compare responses across different demographics, enhancing the clarity of the data presentation.

Performance Metrics Dashboard

A business analyst can create a dashboard with various chart types to display key performance indicators, allowing for quick insights into business performance and trends.

Glossaire :

Chart Type

The specific style of chart used to represent data visually, such as bar, line, or pie charts.

Linear Chart

A type of chart that displays information as a series of data points connected by straight lines, typically used to show trends over time.

Clustered Column Chart

A chart type that displays values in vertical bars grouped together for comparison, often used to compare multiple categories.

Chart Design Tab

A section in Excel that provides options for customizing the appearance and layout of a selected chart.

Chart Styles

Predefined visual formats for charts in Excel that can be applied to change their appearance quickly.

Legend

A key that explains the symbols or colors used in a chart, helping viewers understand what each part of the chart represents.

00:00:02

In our previous tutorial we saw

00:00:04

how to add our first graph.

00:00:06

Now we are going to learn how to

00:00:09

change a chart type, go back to folder,

00:00:11

step four data visualization,

00:00:13

open the folder one,

00:00:14

create your first graph,

00:00:15

then open the workbook

00:00:17

"Create your first graph course".

00:00:18

So we have a table.

00:00:20

We inserted a linear chart,

00:00:22

but this time we decided we want

00:00:24

to change the type of chart.

00:00:26

So I'm going to increase the size

00:00:29

of this chart so we can see better.

00:00:31

So once you've selected

00:00:33

the chart you will notice the chart

00:00:35

design tab when you're here on the

00:00:38

right of the chart styles you have

00:00:40

the button change chart type in this

00:00:42

window again you can find the list

00:00:45

of all the charts available in Excel,

00:00:47

so I'm going to go ahead and switch

00:00:50

it to a column clustered column.

00:00:52

So I'm going

00:00:53

to select this one and click OK and just like

00:00:57

that I've changed the type.

00:00:59

Another thing I can do is

00:01:01

switch the styles as well.

00:01:03

So I'm going to go back to that

00:01:05

start styles window open to see

00:01:07

more options and remember you

00:01:08

can just hover over any style.

00:01:10

I'm just going to select this one,

00:01:12

and if you haven't changed the

00:01:14

legend by selecting them or not,

00:01:15

you're going to find all these

00:01:17

options transferred to the new

00:01:19

chart as well so you can see here.

00:01:21

The legend appears at the bottom,

00:01:22

so let me select this type.

00:01:24

Now you know how to modify the chart type.

Mandarine AI: WHAT YOU SHOULD KNOW

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