How to insert line sparklines in excel.

Have you ever considered putting a group trend line into your data table to show every row or column?The trend of each group will be shown in a table in excel with the help of the sparkline.

1.Click the cell you want to insert a sparkline from and then click the Insert tab to select the type you need from the group.You can see the screenshot.

2.Pick the data range you need to show in the line from the popped out dialog.You can see the screenshot.

3.To close the dialog, click OK.To fill the range, drag the fill handle.You can see the screenshot.

If you want to remove the sparkline, you can click Design > Clear to choose Clear Selected or ClearSelected.