Current location - Training Enrollment Network - Mathematics courses - How to make three-level statistical tables
How to make three-level statistical tables
About how to make three-level statistics, the contents are as follows

1. Open the file where you want to calculate the form.

For example, I want to calculate the length of this pipe.

3. Click on cell G5.

4. Enter the equal sign.

5. Click Formula-Insert Function-Find Evaluation Function.

6. After finding this function, the following activity box will pop up automatically.

7. Click the location shown in the figure below.

8. Select the corresponding formula position.

Excel insert statistical chart method:

1. Open the workbook where you want to insert the statistical chart.

2. Click Insert in the menu bar.

3. Click the chart in the drop-down menu.

4. The chart dialog box pops up.

5. Choose a stacked column chart (you can choose a suitable chart according to your own situation).

6. Select and click Next.

7. Click the button as shown.

8. Hold down the left mouse button and select the line with the scoring rate.

9. As shown, click the button.

10. Select a row. Of course, if you choose a column, you must choose a column.

1 1. Select it and click Next.

12. Click Next.

13. Click Finish.

14. You can see that the statistical chart has already appeared. Just move it to the appropriate location.

Making tables in ppt

1, arrow. (Or find the drawing toolbar, click the arrow and draw the arrow).

2. Click Insert, select the text box, and then select Horizontal.

3. Enter the text, press ctrl+c to copy the text box, and press ctrl+v to copy to complete the input of other text.

4. Select the text boxes on the horizontal axis and the horizontal axis, click the right mouse button and select "Custom Animation".

5. Click "Add Effect", select "Input", and then select "Erase".

6. Change the direction to "From the left".

7. Repeat the fifth step to set the vertical axis.

8. Select a rectangle in the drawing toolbar and draw a rectangle.

9. Double-click the selected rectangle to format the AutoShape. Under Fill, in the color drop-down menu, select Fill Effect.

10. In the fill effect box, under gradient, select "Double Color" as the color, gray as the color 1, white as the color 2, vertical as the shading style, click "OK" for the third variant, and select "Wireless Bar Color" as the offline color.

1 1. Select four rectangles, add an effect, select Enter, and then select Erase.

12. Repeat steps 8 to 10 to make four rectangles with different colors according to the data.

13. Select the small rectangle, add the effect, select Enter, and then select Erase.

14. Complete the animation of other rectangles.

15, that is, complete the statistical table in PPT.