Excel, as an effective tool for financial personnel, can be said that a lot of work needs Excel to complete. Moreover, Excel is powerful, which can complete many tasks such as table input and statistical analysis, and can generate beautiful and intuitive tables and charts. Of course, these tables and charts contain a lot of content, for example, reports are also a kind of charts. The following is a tutorial on how Excel tables generate charts from data, that is, the operation method of automatically generating reports. If you want to learn more Excel chart tutorials, you can go to. There is a special video tutorial on Excel chart operation, which is very suitable for self-study.

How to automatically generate charts from Excel tables;

1. Open the Excel table, select the cell in column A, and enter IF(E8= query table! ￥B￥2, max (A 1: A7)+ 1, ""), as shown in the figure.

2. Select B2 cell = offset (basic data table! A 1, J 1), adjust the last number to change the name.

3. Borrow control J, select 1 display name, and select 2 display name, as shown in the figure.

4. Click to open the tool, click Insert, select the list box (form control), draw the list box, select the list box, right-click to set the control format, click the data source area, and select the name, as shown in the figure.

5. Click the unit connection, select the unit M 1, click OK, and select the name to get the unit number M 1, as shown in the figure.

6. Select a cell and use the VLOOKUP formula, the formula = VLOOKUP (Row (1: 1), data source! $A$2:$I$ 1000, COLUMN(B 1), 0), =VLOOKUP (search value, search area, return search, search method).

7. Select a cell and enter = if error (vlookup (row (1:1)), the data source! $ a $2: $ a $2: $ i $ 1000, column (b 1), 0), ""), and then press =IFERROR (formula, ""), as shown in the figure.

8. Select cell I5 and enter = row (1: 1) to get 1, which belongs to the search value, as shown in the figure.

9. Select cell I6 and enter =column(h 1) to get 8, as shown in the figure.

10. In the column, the document number is 3, the product name is 4, the purchasing unit is 5, the unit is 6, the quantity is 7, the unit price is 8, and the sales amount is 9, as shown in the figure.

1 1. When switching the query table, the formula of the query table remains unchanged, but the auxiliary serial number is changed, and the formula of the header is B2 &；; "Transaction detail report", as shown.

12. Select A5 cell, click Conditional Format, click Manage Rules, click Edit Format Rules, select the applicable formula to determine the cell to be formatted, and enter the formula ISNUMBER($A5), as shown in the figure.

13. Set the color to red, select the area, and click OK, as shown in the figure.

Excel generates charts in this way. Does the automatically generated statement look very simple and easy to understand? Although the basic function of Excel is to record, calculate and analyze data, when we need to make some slightly difficult tables, we should also find the right method and use it reasonably, that is, we need to learn more skills to complete the corresponding work comprehensively.