Download "Gráfico Excel Torta (Gráfico dinámico)"

Please wait. We're preparing links for easy ad-free video watching and downloading.

Previous video: ✔ Como Saber el modelo de la placa base desde el CMD Next video: 100 HACKS THAT REALLY WORK

100 HACKS THAT REALLY WORK

100 HACKS THAT REALLY WORK

Channel: 5-Minute Crafts

✔ Como Saber el modelo de la placa base desde el CMD

✔ Como Saber el modelo de la placa base desde el CMD

Channel: nauzetjesus

3 Absolutely USEFUL ideas you've never thought of before to do DIY projects !!!

3 Absolutely USEFUL ideas you've never thought of before to do DIY projects !!!

Channel: Mr Novruz

GIANT CREEPY EPOXY RESIN CRAFT || Amazing Miniature For Horror Fans 🐙

GIANT CREEPY EPOXY RESIN CRAFT || Amazing Miniature For Horror Fans 🐙

Channel: 5-Minute Crafts

excel

torta

grafico

grafica

tutorial

curso

pudin

dinamica

tabla dinamica

grafico dinamico

graficos en excel

Ms excel

microsoft excel

plantilla

trucos excel

tips de excel

tips

truco

trucos

tablas dinamicas

00:00:00

Hello How are you? I hope you are

00:00:02

feeling well today today we are going to

00:00:05

learn how to use a Dynamic graph

00:00:07

With Microsoft Excel for that in the first

00:00:10

instance we must have our data table

00:00:14

eh As we can see in this example

00:00:17

here we can see in this example

00:00:21

Let's say a table where it contains

00:00:24

the sales that a

00:00:27

certain store or a company has made in the different

00:00:29

countries such as Colombia Argentina Peru

00:00:32

United States finally Mexico yes for

00:00:37

this this company because it has a

00:00:39

sales representative or sellers in

00:00:42

each of these

00:00:43

countries Yes, then let's look at the

00:00:47

first column where it says product.

00:00:49

Well, the products that

00:00:51

this company sells, such as boots, tennis

00:00:55

pants, t-shirts, glasses and watches, the

00:00:59

seller column, well, the seller who

00:01:01

executes the sale, the date column is the

00:01:05

date on which that sale was executed. sale

00:01:08

quantity is nothing more than the quantity

00:01:11

sold of that

00:01:13

product in this column we have the

00:01:15

unit price in dollars of that

00:01:18

product and the Total column is nothing more

00:01:21

than the total sold of that

00:01:23

product from each

00:01:25

seller in this case this seller to uh

00:01:30

Victoria has sold therefore 15,000 in boots

00:01:34

on January 7 Okay It is simply nothing more

00:01:37

than the unit price times the quantity and

00:01:40

Well finally the country column is nothing

00:01:43

more than the country where the

00:01:45

sale was executed Okay we must keep in mind that

00:01:48

our our table of values all

00:01:51

the columns must contain a title, there

00:01:55

must be no title or no

00:01:57

empty cell okay without No, because Microsoft

00:02:00

Excel is not going to allow us to insert

00:02:03

our

00:02:05

dynamic table Now

00:02:08

let's start, we go

00:02:11

anywhere in the table and we go to the

00:02:13

option insert in

00:02:16

insert we use the dynamic table option

00:02:19

Okay, notice that Excel

00:02:23

has automatically detected the table that we

00:02:25

have built and has

00:02:29

placed them in this place of the window,

00:02:31

as you can

00:02:32

see, if in this case it is not

00:02:35

detected, then you can give it

00:02:37

click here you can

00:02:39

select them we start

00:02:41

selecting it Yes up to here very good

00:02:46

perfect and here it gives us the option of

00:02:51

where we want to place that dynamic table

00:02:53

in this case well I'm going to leave it here in

00:02:56

New spreadsheet Okay very

00:02:58

good then in this cake It depends what

00:03:02

that we are left to express or

00:03:05

expose or verify in our

00:03:07

statistics in this case I am going to look

00:03:10

at the cake Which are the sellers

00:03:13

who sold the most and have the greatest

00:03:16

participation in sales Okay so in

00:03:19

this case we take notice that in this

00:03:24

window which is nothing more that the

00:03:28

Fields list has placed the titles of

00:03:32

our table, this is the product, seller,

00:03:35

date, quantity, total unit price and

00:03:39

country. Okay, so in this case I am

00:03:43

needing The seller to place it here in

00:03:46

the rows option. Notice that

00:03:48

a table is being built and in the rows

00:03:51

each of the rows is placing

00:03:54

the sellers Okay very well and now

00:03:58

we place the total where it says sum of

00:04:02

values Okay so here it shows me in

00:04:06

total yes how much each

00:04:10

seller sold in the month of January Okay now let's

00:04:15

insert our

00:04:16

graph we'll go to the

00:04:18

insert option and we select the

00:04:21

Pie Chart you can select the

00:04:23

chart that you want in this case

00:04:26

I am going to use the pie chart and

00:04:28

I will use the 3D pie chart Okay

00:04:31

very good so I have already inserted my

00:04:35

pie chart now we are going to the details we

00:04:39

go to the design field Okay and

00:04:43

we select the design that we

00:04:45

like the most to use this design because it

00:04:48

seems more appropriate to me I like it yes I am going to

00:04:52

expand this graph a little more and there

00:04:55

we obtain eh Now yes each of us let's say

00:04:58

about the sellers and your participation as

00:05:02

such now I need you to give me the

00:05:04

percentages of participation in all

00:05:07

those sales Okay in this case we

00:05:10

right click on any name of

00:05:13

our seller Okay we format it

00:05:17

as a data label and there it gives us the

00:05:20

option to choose the content of the

00:05:24

label in this case because I am going to

00:05:26

use percentage So look

00:05:29

now it gives me the percentage of

00:05:31

participation of that seller in the

00:05:34

sales Okay very

00:05:38

good We also

00:05:41

select our again our

00:05:43

graph we

00:05:46

give it Oops now well right click

00:05:50

format the data series

00:05:53

and we are going to separate a little we are going to

00:05:57

rotate our graph well

00:06:00

depending on what you want

00:06:01

Highlight I am going to leave it, let's say I am going to

00:06:04

leave

00:06:06

Victoria on this side Ok Very good And in

00:06:11

circular section well it

00:06:14

simply separates us a little more because

00:06:18

the slices of the cake Okay there it was

00:06:22

perfect Very good

00:06:24

excellent there we have in the first

00:06:27

instance obtained our truth graph

00:06:30

for each of the sellers

00:06:32

Okay now comes a very

00:06:34

interesting trick if I want to know about each

00:06:38

product Which seller has the highest

00:06:41

percentage of participation in sales

00:06:45

Okay in this case we go to the

00:06:51

analyze tab we click and insert

00:06:54

data cementation and we give product we

00:06:57

select product we let's

00:07:00

accept Notice that a new window has appeared

00:07:03

Okay where we have all the

00:07:06

company's products yes referenced

00:07:09

So look if you We click on

00:07:13

boots, what is Excel going to do in this case?

00:07:17

It is telling me of all the boots: Yes,

00:07:21

46, in this

00:07:23

case Victoria has sold it,

00:07:26

2% of the votes are sold by Alicia

00:07:31

and Marcela, 19. while Kevin, 6,

00:07:35

and John. the one Okay in this case notice

00:07:39

that if I select each of the

00:07:41

products it gives me the percentage of

00:07:43

participation in sales of each product

00:07:47

of the different

00:07:49

sellers that the company has because it is

00:07:52

an interesting fact Well, when it comes to

00:07:55

presenting our data or to look at and

00:07:57

analyze our statistics, it quickly gives us

00:08:03

the data that we

00:08:06

want as such, notice that the

00:08:09

table changes

00:08:12

okay. And there we finally have our

00:08:16

pie chart segmented by each

00:08:19

of the products that we

00:08:21

sell now to finish. let's

00:08:25

do a small

00:08:27

example let's look here and let's

00:08:30

place

00:08:32

e let's place

00:08:35

eh okay Now I don't want to say I don't

00:08:40

want to

00:08:41

look at it by seller I want to look at it it's

00:08:46

by country okay So I remove the seller

00:08:50

I put the country

00:08:52

here and Ready here I have the country

00:08:58

and Okay now it gives me instead of the sellers I

00:09:03

already have the countries Okay and there

00:09:07

it is very

00:09:09

good excellent and there it is then

00:09:13

our Dynamic cake graph to

00:09:16

make it more beautiful we go to the

00:09:18

View option we remove the

00:09:21

grid line and that's it there We have our

00:09:23

Dynamic graph, we can use and

00:09:26

manipulate it as we would like. I

00:09:30

hope you liked this video.

00:09:31

If you liked it, please share it and

00:09:35

like. Thank you very much and be very well

00:09:37

until next time.

Description:

En este video explico como hacer un gráfico dinámico de torta en Excel PREGUNTAS O COMENTARIOS? Dejame tus inquietudes en el post de videos

Preparing download options

Popular

HD video

Only sound

All

* — If the video is playing in a new tab, go to it, then right-click on the video and select "Save video as..."

** — Link intended for online playback in specialized players

Questions about downloading video

How can I download "Gráfico Excel Torta (Gráfico dinámico)" video?

http://unidownloader.com/ website is the best way to download a video or a separate audio track if you want to do without installing programs and extensions.
The UDL Helper extension is a convenient button that is seamlessly integrated into YouTube, Instagram and OK.ru sites for fast content download.
UDL Client program (for Windows) is the most powerful solution that supports more than 900 websites, social networks and video hosting sites, as well as any video quality that is available in the source.
UDL Lite is a really convenient way to access a website from your mobile device. With its help, you can easily download videos directly to your smartphone.

Which format of "Gráfico Excel Torta (Gráfico dinámico)" video should I choose?

The best quality formats are FullHD (1080p), 2K (1440p), 4K (2160p) and 8K (4320p). The higher the resolution of your screen, the higher the video quality should be. However, there are other factors to consider: download speed, amount of free space, and device performance during playback.

Why does my computer freeze when loading a "Gráfico Excel Torta (Gráfico dinámico)" video?

The browser/computer should not freeze completely! If this happens, please report it with a link to the video. Sometimes videos cannot be downloaded directly in a suitable format, so we have added the ability to convert the file to the desired format. In some cases, this process may actively use computer resources.

How can I download "Gráfico Excel Torta (Gráfico dinámico)" video to my phone?

You can download a video to your smartphone using the website or the PWA application UDL Lite. It is also possible to send a download link via QR code using the UDL Helper extension.

How can I download an audio track (music) to MP3 "Gráfico Excel Torta (Gráfico dinámico)"?

The most convenient way is to use the UDL Client program, which supports converting video to MP3 format. In some cases, MP3 can also be downloaded through the UDL Helper extension.

How can I save a frame from a video "Gráfico Excel Torta (Gráfico dinámico)"?

This feature is available in the UDL Helper extension. Make sure that "Show the video snapshot button" is checked in the settings. A camera icon should appear in the lower right corner of the player to the left of the "Settings" icon. When you click on it, the current frame from the video will be saved to your computer in JPEG format.

What's the price of all this stuff?

It costs nothing. Our services are absolutely free for all users. There are no PRO subscriptions, no restrictions on the number or maximum length of downloaded videos.