Everyone is using excel, and everyone knows its importance. If we are familiar with its function and master the skills of using it, it is very convenient to use. So how to make a chart with the data calculated in excel? Or scale chart, or histogram, let me introduce it below.

Methods/steps

1, first you have to call an excel worksheet to calculate the data that should be calculated, or the ratio, or the pass rate or something like that. In any case, you must have data to make a table.

2. Use various excel skills and methods, or formula functions to calculate the data you want to calculate, and then put your calculated data aside. At this time, you need to select the data to make the corresponding chart.

3. Then select the data you calculated, click Insert in the top menu bar, and then find the "Table" option. Then click on the small triangle and more icon structures will pop up.

4. Next, choose the table form, histogram, three-dimensional diagram, three-dimensional diagram and so on that you like or need. According to the format you need, click OK to complete the icon setting.

5. After that, the icon you made will pop up on this page. Of course, it should be removed. At this point, click "Move Table" as shown in the figure. Then just choose the position you want to move, and the chart of a worksheet is completed.

Matters needing attention

As long as there are no mistakes in the calculation.

The above is the introduction of the method of making charts with excel data, hoping to help everyone!