On the Insert tab, in the Sparklines group, click Line. Click in the Data Range box and select the range A2:F4. Change the value of cell F3 to 0. Excel automatically updates the sparkline. Customize Sparklines To customize sparklines, execute the following steps.
To create sparklines, you must select the data range that you want to analyze, and then select where you want to put the sparklines. The data range for the sparklines. The location for the sparklines. Column sparklines that display year-to-date sales for Portland, San Francisco, and New York.
Select the sparklines. On the Design tab, in the Show group, check High Point and Low point. On the Design tab, in the Type group, click Column. Result: To delete a sparkline, execute the following steps. Select 1 or more sparklines. On the Design tab, in the Group group, click Clear.