Crear GRÁFICOS en Excel ✅ cómo introducir datos y crear GRÁFICAS - Vídeo Dailymotion

Saltar al reproductor Saltar al contenido principal Saltar al pie de página

6/6/2025

En este vídeo te muestro cómo crear gráficos en Excel paso a paso: desde hacer un gráfico de barras en Excel y la forma más fácil de crear un gráfico circular en Excel.

Categoría

Transcripción

Mostrar la transcripción completa del vídeo

00:00Today I'm going to show you how to create charts in Excel.

00:02I'm going to show you the most common way, so to speak,

00:05but I'll also show you how to create charts when you don't want to create a chart of all the data you have in the table,

00:11but only some parts.

00:12The first thing you need is to have your data in Excel.

00:16It doesn't really matter if you have it arranged like this or if you have the months up here and the products down here.

00:21You'll see why later.

00:24The fastest way is to select all your data, the ones you want to show in the chart,

00:28and in the Insert tab, click on the type of chart you want to insert.

00:34Just by placing your mouse over it, you'll see a preview of how the data looks in that type of chart.

00:40Let's see if it changes to another chart.

00:44You can even try a line chart, one of this type, or a pie chart.

00:50If you want to practice with this template, I'll send it to my mailing list on Sunday, March 23rd.

00:55If you're not on it, I'll leave the link to sign up in the video description.

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

01:00Depending on the data you want to display in the graph, you probably already have an idea of which graph might work best for you.

01:07I'm going to show the units sold per month for two devices and I want to see which device sold the most in each month.

01:12So, I can use a bar graph of this type, but for this case, a line graph with markers would be best.

01:22Now we just have to keep editing the options so that it looks the way we want.

01:26With the graph selected, the graph design and format options are enabled.

01:31These two tabs are where you can edit everything.

01:34One option you should know about is the one to change rows to columns.

01:37This changes the axes.

01:39In this case, it doesn't make much sense because the data is displayed correctly.

01:43You can quickly change it with this option to change rows to columns.

01:46In this case, it doesn't make sense.

01:48As you can see, it doesn't look right, but you should know about this option.

01:52We can also change the design styles.

01:54Expand it and choose the one that suits you best.

01:56As you can see, you can see how the graph is displayed by hovering over it.

02:01If one of these chart styles works exactly for what you want, just select it.

02:05You can change the colors by scrolling down from here.

02:10We'll see it in different shades, just choose the one that works best for you.

02:15And these quick design options can also help you display data in other ways.

02:21Both the design styles and the quick design options allow you to change the chart elements in general.

02:27But if you want to change one, you have to do it from here, from chart elements.

02:31And as you can see, here you can set whether you want to show the horizontal axis or not the vertical axis.

02:39Here are the options.

02:41If you want to show the axis titles or not, once they appear, just double-click to edit them.

02:47You can show the chart title or not.

02:50If you want to show it, here you have the display options or more options.

02:54And to edit it, just delete what already exists and replace it.

02:59You have the option to show data labels.

03:02By hovering the mouse, you can preview how they would look.

03:04This can then be edited.

03:06If you want to include a data table or not.

03:09We also had this option with the quick design, but you can customize it further from here.

03:14Error Bars

03:15If you want to see a legend, by clicking on the little arrow,

03:18you can preview it in each of the positions.

03:22Trend lines and ascending and descending bars.

03:27And if you want to customize the color of a line or a bar.

03:30For example, I want this green one to be orange.

03:33Right click in here and fill.

03:35Choose the color orange.

03:37You see that these markers have been changed to orange and then you also change the outline to orange

03:42and in this way you have customized the color of a single series.

03:45And what happens if you don't want to show all the data in a table?

03:47Imagine that we have the data like this.

03:49Well, we can also do it the following way.

03:51Without selecting any data, we are going to insert it.

03:55We select the type of graph.

03:57I am going to select the same one as before so that it remains the same.

04:02And once I have it here, we are going to select the data.

04:05We are going to add a series.

04:08The name of the series would be the iPhone.

04:11We accept.

04:13The data range would be this.

04:15And here I have the first series.

04:20So that the names of the months are not shown here, I edit it and select it from here.

04:26I accept and I would have the first series.

04:28If I want to add another one, well, again, select data.

04:33Let's add another series, the Samsung one.

04:36This is the name.

04:38We have the values here.

04:39I accept and it is not necessary to change the labels of the horizontal axis because it already

04:45takes those of the previous series.

04:47We accept.

04:48And here we have the graph.

04:49As you can see, it shows us the same colors as the last graph we created on the other sheet and

04:54the customization would be exactly the same.

04:56If you found it useful, give it a like and if you want to be up to date with everything,

04:59subscribe to my mailing list.

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

05:03See you in the next video.

Recomendada

2:06

Próximamente

Gráfico comparativo con ICONOS en Excel ✅

6/6/2025

4:05

📈📉📊 Como GRAFICAR en EXCEL 2024 FÁCIL y RÁPIDO

9/11/2024

3:25

📉📈 Cómo HACER un GRÁFICO de DOBLE EJE en EXCEL (TUTORIAL en ESPAÑOL FULLHD)

9/11/2024

3:54

📈📉 Cómo HACER un GRÁFICO con COORDENADAS X e Y en EXCEL 2024 FÁCIL y RÁPIDO

9/11/2024

4:57

✍ Como CREAR una GRÁFICA ESTADÍSTICA en WORD FÁCIL y RÁPIDO

28/10/2024

8:22

Como CREAR una GRÁFICA ESTADÍSTICA CIRCULAR en WORD FÁCIL y RÁPIDO

2/11/2024

2:13

Tutorial Excel Añadir nuevas series a un grafico

6/10/2015

5:24

✍ Como HACER un GRÁFICO de BARRAS en WORD FÁCIL y RÁPIDO

2/11/2024

1:53

Como INSERTAR un ARCHIVO WORD en EXCEL ✅

14/8/2024

4:00

activar o desactivar el Almacenamiento reservado para el Sistema en Windows 10

15/3/2023

2:24

Activar solo admins de grupo de Whatsapp pueden enviar mensajes

15/3/2023

2:15

Cómo deshabilitar Windows PowerShell en Windows 10

8/3/2023

2:04

🗑️❌ Los ICONOS del ESCRITORIO han DESAPARECIDO en WINDOWS 11 SOLUCION en 1 MINUTO

hace 4 días

3:00

🔕 Como OCULTAR el ICONO de la CAMPANA de la BARRA de TAREAS de WINDOWS 11

hace 4 días

5:00

📚💻 Como COMPRIMIR ARCHIVOS 7z y TAR en WINDOWS 11 SIN APLICACIONES

hace 4 días

2:52

🕑❌ NO VEO el RELOJ en BARRA de TAREAS de WINDOWS 11 SOLUCIÓN

hace 4 días

3:19

💻🚀 4 FORMAS de ACCEDER al ESCRITORIO en WINDOWS 11

hace 4 días

5:03

💻❌ DESACTIVAR CONTENIDO DESTACADO en WINDOWS 11 FÁCIL y RÁPIDO

hace 4 días

4:12

📂🔒 Actualmente NO tiene PERMISO de ACCESO a esta CARPETA en WINDOWS 11 o WINDOWS 10 SOLUCION

hace 4 días

2:56

🙍‍♂️❌ Como DESINSTALAR MICROSOFT TEAMS en WINDOWS 11 FÁCIL y RÁPIDO

hace 4 días

2:11

📄📄 Como PONER una PÁGINA al LADO de la OTRA en WORD FÁCIL y RÁPIDO

hace 4 días

0:54

How to Fix Bugs & Errors in Call App | Solve Call Not Working Issues on Android

15/6/2025

0:58

How to Enable Silent Mode on Any Phone | Mute Notifications & Calls Easily

15/6/2025

0:45

How to View YouTube Watch History on Android | Find Previously Watched Videos

15/6/2025

1:09

How to Enable One-Handed Mode on Android | Use Your Phone with One Hand

15/6/2025