Excel Smart Data Presentation 4, mini chart

In Excel 2013, the "Mini Chart" function allows you to draw beautiful charts in a cell and mine the potential commercial value of data. The procedure is as follows:

(1) switch to the "insert" tab in the Excel 2013 worksheet, click the "line chart" button in the "mini-graph" placement group, and in the "create mini-graph" dialog box that appears, set the correct data range and location range. Finally, click OK to close the dialog box. The mini Chart drawn based on the selected data is automatically displayed in the specified cell.

(2) At the same time, the "design" context tab of the "mini-graph tool" is displayed on the functional area, which allows you to perform rich formatting operations on the mini-graph. Select the check boxes for "high" and "low", and click "other" in the "style" style group to select a beautiful style in the pop-up mini image Style Library.

(3) drag down the filling handle in the lower-right corner of the cell where the mini-graph is located, just like the copy filling formula that the user often executes. This operation can replace the mini-graph with other cells, to form a set of mini images.

(4) using similar operations, you can also quickly create a set of bar mini charts and format them with the "Mini Chart Tool" to make them look beautiful.

Excel Smart Data Presentation 4, mini chart