Gráfico comparativo con ICONOS en Excel ✅

online

¿Quieres quedar como un profesional? Aprende cómo hacer un gráfico comparativo en Excel e incluye iconos en tu gráfico, se quedarán con la boca abierta.

Transcript

00:00If you apply this effect to your graphs, you'll look like a pro.

00:05Pay attention, I'll explain how to do it.

00:07Here I have the data that I'm going to graph, which is the means of transport to go to work.

00:11I select the data.

00:14Insert recommended graphs.

00:16Choose the grouped column graph.

00:20Select the vertical axis, right click, format the axis.

00:25In maximums, put a 1.

00:26If you want to practice with this template, sign up for my mailing list.

00:31I'll leave the link in the description of the video.

00:33I'll send it to you next Sunday April 6th by email.

00:37Don't ask me for it later because I won't send it.

00:40We don't need the title.

00:43And now we're going to insert icons.

00:47I'm looking for vehicles.

00:49I select the car, insert.

00:52Right click on the icon.

00:53I'll cut it.

00:54I'll select the series, only this series.

00:59And in the series options, we'll go to fill.

01:02We'll display the fill options.

01:04And select fill with image or texture.

01:07Select clipboard.

01:10Now we have the car and now we have to stack it.

01:13Let's go to the next icon.

01:16Insert icons.

01:17Right click, cut and in fill fill with image or from the clipboard and we stack it and insert icons again.

01:30Right click, cut and in fill fill with image and texture, clipboard and stack.

01:45This is the result.

01:46And if we change the values, we see how the graph is updated.

01:53And you know, if you don't want to miss anything, sign up for my list.

01:56I'll leave you the link here.

01:58See you in the next video.

Categoría

Transcripción

Recomendada