Excel - Generate a Chart with Copilot Tutorial

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
  • 498 views
00:00:02
I have access to a data extraction
00:00:04
relating to customer orders from
00:00:06
around the world in 2023 containing
00:00:09
various information including country,
00:00:11
carrier, client amounts and quantities.
00:00:13
As we've seen in another tutorial,
00:00:15
Copilot can generate pivot tables.
00:00:17
Now let's see how to generate pivot charts.
00:00:20
To start, I wish to create
00:00:22
a histogram representing the
00:00:24
overall sales volume by country.
00:00:26
Care must be taken with
00:00:28
the wording to be precise.
00:00:30
In the conversation pane,
00:00:32
Copilot executes and suggests inserting
00:00:34
a result sheet that will contain,
00:00:36
as you can see, a pivot table
00:00:38
as well as the associated chart.
00:00:40
Customization of the pivot
00:00:42
table or chart will, however,
00:00:43
need to be done manually by the user.
00:00:46
Let's generate a second request from
00:00:48
the data sheet wanting a pie chart
00:00:51
related to the number of orders
00:00:53
distributed by our tracking numbers.
00:00:55
Essentially our delivery companies.
00:00:56
As before,
00:00:57
a chart associated with a table
00:00:59
is generated in a new potential
00:01:01
tab with the possibility for me
00:01:03
to manually adjust properties.
00:01:05
Let's add a data legend label.
00:01:10
Curve type charts are also possible,
00:01:12
as I want to illustrate here by
00:01:14
prompting a request for a chronological
00:01:16
revenue evolution over the year.
00:01:18
Once again, a chart is generated.
00:01:22
Copilot for Excel facilitates the
00:01:24
implementation and visual analysis of data,
00:01:26
especially if you're not an expert
00:01:29
in using Excel spreadsheets.

No elements match your search in this video....
Do another search or back to content !

 

DiLeaP AI: THIS MIGHT BE HELPFUL

Reminder

Show