Creating a sparkline from spreadsheet data Select Spreadsheet in the Sparkline Wizard. Select a sparkline type from the list at the top of the Wizard. Click Next. Specify the source of the data which the sparkline will represent. For example, B14:G14 or B14: B19. Specify the cell in which to display the sparkline.