Excel2010 in the application of Mini chart production trend table

The new "Sparkline" feature, added in Excel version 2010, allows you to create a chart in one cell. The case illustrates how each month's data moves through a variety of "mini graphs" in a cell through a "sparkline".

① start Excel2010, import the spreadsheet you want to work with, select the H3:h11 area, and click the menu bar-Insert-sparkline-column chart.

② The Create Sparkline dialog box, select the range of data, and place the mini chart, click OK.

③ Sparkline Insert Complete, we select, click the Design tab under the Color button to change the color to blue.

④ continue in the Design tab, select "High".

⑤ Select the I3:i11 area and click the menu bar-insert-mini-line chart.

⑥ the same, set it to "high".

⑦ Finally, the H column shows the Sparkline, I column shows the trend chart, which makes use of the mini chart to complete the production of the trend map.

Note : More wonderful tutorials Please pay attention to the triple computer Tutorials section, triple Office group: 185219299 welcome you to join