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

Saltar al reproductor Saltar al contenido principal

hace 5 meses

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.

Sé la primera persona en añadir un comentario

Añade tu comentario

Recomendada

7:55

Próximamente

▶ Crear GRÁFICOS estadísticos. Introducir datos en Excel y crear gráficas

hace 2 meses

9:03

Excel - Crear gráficos estadísticos en Excel según el tipo de datos. Tutorial en español HD

hace 6 semanas

3:53

Cómo hacer GRÁFICO de DISPERSIÓN en Excel ✅

hace 7 semanas

4:05

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

hace 1 año

2:06

Gráfico comparativo con ICONOS en Excel ✅

hace 5 meses

2:19

Cómo hacer un GRÁFICO de PASTEL en Excel ✅

hace 3 meses

3:55

Excel - Cómo hacer un gráfico de doble eje en Excel. Tutorial en español HD

hace 6 semanas

3:25

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

hace 1 año

3:54

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

hace 1 año

4:57

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

hace 1 año

8:17

Cómo crear un DIAGRAMA de GANTT en Excel [ Cronograma usando los gráficos ]

hace 6 semanas

4:07

Excel | Gráficos dentro de celdas Excel 💹 | Minigráficos | Indicadores de datos. Tutorial en español

hace 7 semanas

8:22

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

hace 1 año

5:50

Excel - Crear histograma y polígono de frecuencias en Excel. Tutorial en español HD

hace 6 semanas

2:13

Tutorial Excel Añadir nuevas series a un grafico

hace 10 años

2:59

Excel - Imagen como marca de agua. Marca de agua en Excel. Tutorial en español HD

hace 7 semanas

7:50

Excel - Escala de tiempo en tablas dinámicas. Tutorial en español HD

hace 6 semanas

5:24

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

hace 1 año

1:13

🔥 Activa Cualquier Versión de Microsoft Office en 2025 ✅ Método 100% Legal y Fácil (Paso a Paso)

Pc Software Oficial

hace 4 días

8:02

🔥 ¡DESCARGA e INSTALA OFFICE 2021 GRATIS! 💻 Full en Español ✅ Activado y 100% Funcional

Pc Software Oficial

hace 2 semanas

5:27

🔥 Cómo DESCARGAR e INSTALAR Microsoft Office 2024 💻 GRATIS, Legal y ACTIVADO de por Vida 🚀

Pc Software Oficial

hace 2 semanas

2:33

⏳ AnyDesk limite de 5 minutos✅SOLUCIÓN Julio 2025

SimpleSolutionsMX

hace 6 semanas

4:06

⏳Limite de 5 minutos en AnyDesk_✅Alternativa GRATIS Agosto 2025

SimpleSolutionsMX

hace 6 semanas

2:47

Actualizar controladores usb windows 10

hace 4 meses

4:04

Actualmente no tiene permiso de acceso a esta carpeta en Windows 10

hace 4 meses