Before you make any schedule, you need to decide on the question of what types of diagrams you are interested in.
Consider the main ones.
bar chart
The name of this species is borrowed from the Greek language. Literal translation - write by pillar. This is a kind of bar graph. Diagrams in excel of this kind can be volumetric, flat, display contributions (rectangle in a rectangle), etc.
Scatter chart
Shows the relationship between numerical data in a certain number of series and represents a pair of groups of numbers or numbers in the form of a single series of points in coordinates. The types of diagrams of this type display data clusters that are used for scientific purposes. In preliminary preparation for the construction of a scatter chart, all the data that you want to arrange along the x-axis should be placed in one row / column, and the values along the “axis” in the adjacent row / column.
Bar chart and graph
A bar chart describes a relationship between individual data. In this diagram, the values are located on the vertical axis, while the categories are located on the horizontal axis. It follows that such a diagram devotes more attention to comparing data than to changes that occur over time. This type of diagrams exists with the “accumulation” parameter, which allows you to show the contribution of individual parts to the overall end result.
The graph displays a sequence of changes in numerical values for absolutely equal time intervals.
These types of diagrams are most often used for plotting.
Area Charts
The main purpose of such a chart is to focus on the magnitude of the data change over a period of time, by showing the summation of the entered values. As well as displaying the proportion of individual values in the total.
Donut and Pie Charts
These types of diagrams are very similar in purpose. Both of them represent the role of each element in the total. Their difference lies only in the fact that the donut diagram has the ability to contain several rows with data. Each individual nested ring is an individual series of values / data.
Petal
Here, each category represents an individual coordinate axis, originating from a zero coordinate point. This type of diagram allows you to compare the total values from a certain amount of data entered.
Bubble
One of the varieties of punctata. The magnitude of the marker depends on the magnitude of the third variable. In preliminary preparation, the data should be located in the same way as in preparation for the construction of a scatter chart.
Stock chart
Using it is often an integral process when selling stocks or other securities. It is also possible to build it for the visual determination of changes in temperature conditions. For three and five values, this type of chart can contain a pair of axes: the first for columns that represent an interval of certain fluctuations, the second for changing the price category.
This is just a small part of the chart types you may need. The types of diagrams in Excel are very diverse. The choice always depends on the goals. So decide on what you want to get in the end, and the build wizard will help you decide!