WHICH DIAGRAM OR GRAPH IN EXCEL 2019?
Charts and diagrams are the ideal way to display data in a well-organized manner. That is, if you use the correct diagram. That’s where many Microsoft Excel and Office users go wrong. A graph or diagram is quickly selected, while it does not match the dataset or statistics. Do you not want to make a mistake in the future when you want to visualize figures? We present the 5 most important diagrams and charts in Excel 2019, including an explanation when to use them!
This is one of the most used diagrams within Excel. With a line chart you can show how something develops over time. This type of diagram is also ideal for displaying a trend.
A tip is to proportionally divide the “periods” on the horizontal axis. For example, try using a distribution per day, week or month. On the vertical axis, for example, the weekly turnover, the number of visitors in the period or the number of leads could be noted. An extra line is regularly added to the line chart that displays the forecast or expected revenue.
A pie chart makes it possible to display a distribution in a well-arranged manner. Consider, for example, the division between men and women within the organization. Or the nationality of employees within an international organization.
Each sector of a pie chart gives the relative size relative to the total. Together, the individual sectors always represent 100 percent. Furthermore, every sector has a distinctive colour. In order not to make the individual “pie pieces” too small, it is recommended to compare a maximum of 5 different categories in one diagram. Are there more categories? Then it is advised to choose a bar chart.
Column and bar chart
A bar chart is regularly used to visualize a data distribution or to compare values. A frequently used application of the bar chart is the comparison of company sales (or other data) per quarter, month or year.
To begin with, the category must be shown on the horizontal axis. This could for example be the quarters, but also the different product categories. The quantity is then displayed on the vertical axis. Always take into account a logical scale. It is also recommended to sort all bars by size. By using ascending or descending bars, you provide more overview and structure.
Stacked bar chart
The stacked diagram initially looks a lot like the normal bar chart. The big difference is that with a stacked column chart you can not only clearly present the categories themselves. But you can also compare the sub-data of the categories with each other.
A stacked chart can be used, for example, if you want to compare the turnover of an electronics store with each other per period. And then also want to add the turnover per product category (e.g. refrigerators, TVs and radios) to the individual “bars”.
With a scatter diagram it is possible to show a relationship between certain data. For example, the scatter diagram can be used to show the correlation between the weather and the ice cream sale. Or to show whether there is a connection between the level of education and the score on a competence test.
Data is displayed within the scatter diagram in a “point cloud”. A line is drawn regularly, across all points within this cloud. In most cases, this line indicates the average of the data per category. Do you want to use the scatter diagram to show a connection? Then the chance of a direct relationship is greater if the individual points are close to each other.
Make well-arranged diagrams yourself?
Do you want to present data in a well-organized manner? Then start using Office 2019, with Excel 2019 included. This makes it easier than ever to present complex data in an easy way. Furthermore, Excel 2019 contains a useful function that combines your data set with a matching diagram. Order Office 2019 directly and you will receive the 100% original license within 5 minutes via e-mail!