Excel - Generate a Chart with Copilot Video

Learn how to generate a chart with Copilot in this intermediate tutorial. Using data extraction from customer orders around the world, discover how to create a pivot chart to represent overall sales volume by country. Join us to explore the power of Copilot in visualizing data!

1:34
3952 views

00:00:05

customer orders from around the world for 2023.

00:00:09

This data includes details like country carrier, customer information,

00:00:14

order amounts and quantities.

00:00:16

In a previous tutorial, we saw how copilot can generate pivot tables.

00:00:21

Now let's explore how to create pivot charts.

00:00:24

First, I'll generate a column chart to represent the total sales volume by country.

00:00:29

Watch as copilot works in the conversation pane

00:00:32

and then offers to insert a results sheet.

00:00:35

This sheet contains both the pivot table and the corresponding chart.

00:00:39

Keep in mind any further customization of the pivot, table or chart,

00:00:43

like adjusting styles or formatting

00:00:46

must be done manually by the user.

00:00:49

Next,

00:00:49

let's request a pie chart to show the number

00:00:52

of orders grouped by courier or delivery company.

00:00:55

Just like before,

00:00:56

Copilot generates a chart alongside a table ready for me to adjust manually,

00:01:01

such as adding a legend for the data labels.

00:01:05

We can also create line charts, which is perfect for illustrating trends over time.

00:01:11

For example,

00:01:12

I'll request a line chart to visualise revenue growth throughout the year.

00:01:17

Once again, the chart is generated with a table for easy modification

00:01:22

copilot for Excel simplifies the process of data visualisation,

00:01:26

making it easy to analyse data even if you're not an Excel expert.

RELATED COURSES This video is part of the following courses

E-learning Intermédiaire

Vu 2012 fois

Microsoft Video Training Copilot - Discover and Learn to Use Microsoft Copilot

Master Microsoft Copilot in Microsoft 365 with our video training. Discover how AI can transform your work, enhancing productivity and creativity.

E-learning Intermédiaire

Vu 1645 fois

Microsoft Video Training Copilot - Analyzing Your Data and Presenting with Copilot

Discover how to analyze data and create impactful presentations with Microsoft Copilot. Learn to use AI for informed decisions.

ALL COURSES