Crear gráficos en excel es una manera diferente de visualizar los datos y presentar la información, gracias a los gráficos podemos interpretar mucho mas rápido el contexto de una gran información y hacer que sea entendible visualmente para las personas. También son útiles para crear y resumir reportes en la actividad que estes realizando, ya sea que esta contenga mucho o pocos datos.
TYPES OF GRAPHICS
There are different types of graphs that we can create in excel to summarize and better interpret the data, some of the most used main ones are:
1. Bar Chart:
It is one of the most used due to its easy visualization and interpretation, it contains an X axis in which a category is placed and in the Y axis the values of the information. Generally the information is contained in an excel table to convert it to a graph.
2. Stacked bar chart:
Es similar a la gráfica de barras, en el podemos visualizar los datos de una forma apilada, esto quiere decir que la barra va a estar seguida verticalmente de la otra separada por una division de colores para poder diferenciar los valores. No se recomienda utilizar este gráfico en forma 3D, pues la interpretación es mucho mas compleja.
4. Line graph:
This helps us when we want to make clear what is the trend of the data, it is represented by lines in which we can interpret how it rises, falls or is maintained in a fast way, you can also make comparisons with respect to other information. It is very useful when we want to show time lines.
5. Pie chart:
It is the most visually representative graph, that is why we must be careful with what information we can illustrate, because the divisions in the form of pizza can be very similar to the point of not being able to notice the differences in the values, but when we want to represent a very high value in relation to a very low one, so this graph is not very useful. It is not recommended to use this graph in 3D because it could not be interpreted.
These are the most used graphs in excel at the moment, but there are others that are also very useful to visualize the information, among which are:
- Horizontal bar charts
- Scatter plots
- Bubble charts
- Combined graphics
- Area charts
- Hierarchy charts
- Waterfall graphics
The use of each of them will depend on the need you have to make the information known. You can consult other here.
HOW TO CREATE CHARTS IN EXCEL:
Creating or Inserting graphics in Excel is simple, for this you must perform the following steps:
1. Selecciona la información que quieres gráficar en excel, en este caso tenemos la siguiente tabla
2. En el menu seleccionar la ficha INSERTAR > Gráfico recomendados o Seleccionar el gráfico que necesites
3. Insert the chart in this case we select a bar chart. You can modify the information you want in the graph to improve the interpretation, from the title, colors, values, percentages, etc.
In the following video you can watch the tutorial to discover other options you can use when creating charts in excel. Click here to watch.