What are Microsoft Excel Sparklines?: An Excel Sparkline is a tiny graph with no axis or labels displayed in a cell that can help you visualize and analyze data trends.
How to insert Excel sparklines in a spreadsheet?: Using Microsoft Excel Sparklines is very easy. Here’s the procedure:
- Select the data from which you want to make a sparkline.
- Go to Insert > Sparkline and select the type of Sparkline you’d like to add to your spreadsheet. You’ll notice there are three types of Sparklines, Line, Column, and Win/Loss. We’ll select Line for our example.
- Specify a target cell where you want the sparkline to be placed.
You will see your Sparklines appear in the desired cells.
How To Customize Excel Sparklines
Select the sparklines you want to customize to show the Sparkline Tools on the ribbon.
What all you can do?
- You can select the style of sparkline from additional pre-defined styles.
- You can mark all value points by selecting Markers.
- You can select Sparkline Color or Marker Color options to fully customize your Sparklines.
- The Axis options allow additional options such as Date Axis Type, Plotting Data Left to Right, and displaying an axis point to represent the zero line in your data with Show Axis.
- You can easily switch between different Sparkline types by simply selecting the current cells (individually or the entire group), and then clicking the desired type on the Design tab.
- If you select one cell, you can always copy a sparkline to other cells in a column or row later by dragging or using Fill Down (Ctrl+D).
- If data has blanks, sparkline shows blanks too.
- If data has some hidden rows / columns, the values are neglected (unless you enable “Show data in hidden cells” option).
- When you adjust row-height or column-width of the cell containing sparkline, the size of sparkline changes too.
- If you want to copy a sparkline over to a ppt or document, you can use “copy as picture” option.
- The sparklines feature is disabled whenever you open a workbook in “compatibility mode”. (Sparklines option is available for Microsoft Excel 2010 & above)