If you use sparklines Excel has some excellent features. Use Excel sparklines to analyze trends in your data.


  1. Open an existing Excel workbook. If you want, you can use our practice workbook.
  2. Create a sparkline on the first row of data. If you are using the example, create a sparkline for the first salesperson on row 3.
  3. Use the fill handle to create sparklines for the remaining rows.
  4. Create markers for the High Point and Low Point.
  5. Change the sparkline type.
  6. Change the display range to make the sparklines easier to compare.