Select the data you want to visualize as Sparklines. If you want the Sparklines to appear in empty cells, ensure that there are empty cells to the right of your selection2. The Quick Analysis Tool button appears near the lower right corner of the selected range. Click theQuick Analysis Tool button, and then click the Sparklines tab.3. Click the button for the Sparkline type you want.OR1. Select the data range with the data points for the Sparklines.2. On the Insert tab, in the Sparklines group, click the button for the type of Sparkline you want to insert:Line, Column, or Win/Loss.3. The Create Sparklines dialog opens with the selected range added to the Data Range box.4. In the Location Range box, enter the cell range where you want the Sparklines to appear. You can type the cell range or click and drag in the worksheet to select the cells.5. Click OK to insert the Sparklines.