Types of diagrams and their features

Before you draw up any chart, you need to decide on which types of diagrams you are interested in.

Consider the main ones.

bar chart

The very name of this species is borrowed from the Greek language. A literal translation is a column. This is a kind of columnar graph. Diagrams in this type of exel can be voluminous, flat, display contributions (rectangle in a rectangle), etc.

Scatter chart

Shows the mutual relationship between numeric data in a certain number of rows and represents a pair of groups of numbers or numbers in the form of a single row of points in coordinates. Types of diagrams of this type display data clusters, are used for scientific purposes. If you are preparing to create a bitmap, all the data that you want to arrange along the axis of the axis should be placed in one line / column, and the values on the "play" axis in the adjacent row / column.

Bar chart and graph

A line chart describes a certain relationship of individual data. In this diagram, the values are along the vertical axis, while the categories are on the horizontal axis. It follows that this diagram pays more attention to comparing data than to changes that occur over time. This type of diagram exists with the parameter "accumulation", which allows you to show the contribution of individual parts to the overall final result.

The graph shows the sequence of changes in numerical values at absolutely equal intervals of time.

These kinds of diagrams are most often used for construction.

Diagrams with areas

The main purpose of such a chart is to focus on the amount of data change for a certain period, by showing the summation of the entered values. And also display the share of individual values in the total amount.

Ring and pie charts

These types of diagrams are very similar in purpose. Both show the role of each element in the total amount. Their difference is only that the ring diagram has the ability to contain several rows with data. Each individual nested ring represents an individual series of values / data.

Petal

Here, each category represents an individual coordinate axis originating from the zero point of coordinates. This type of diagram allows you to compare the total values from a certain number of entered data.

Bubble

One of the species is a point species. The value of the marker depends on the value of the third variable. In the preliminary preparation, the data should be located exactly as in preparing for the construction of a bitmap.

Stock chart

The use of this is often an integral process in the sale of shares or other securities. It is also possible to build it to visually determine the change in temperature conditions. For three and five values, this kind of graph can contain a pair of axes: the first one - for bars that represent the interval of some fluctuations, the second - to change the price category.

This is only a small part of the chart types that you might need. Types of diagrams in Excel are very diverse. The choice always depends on the goals. So determine what you want to get in the end, and the construction wizard will help you decide!