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