Excel 2010 introduced the ability to insert sparklines. Sparklines are graphs that fit in one cell and give a visual representation of the data in question.
Insert sparklines
To insert sparklines, do the following:
- Select the cells where the sparklines should be placed. In our example, we have selected a range G2: G4.
- On the Advanced tab Insert (Insert) in section Sparklines (Sparklines) click Timetable (Line).
- Click in the field Data range (Data Range) and select (or enter manually) the range A2: F4.
- Press OK.Result:
- Change cell value F3 to 0. Excel will automatically update the sparkline.
Setting up sparklines
To configure sparklines settings, follow these steps:
- Select sparklines. A tab will appear on the Menu Ribbon Working with sparklines (Sparkline Tools).
- Check the options Maximum point (High Point) и Minimum point (Low Point).Result:
- In section A type (Type) click bar chart (Column).Result:
- To remove a sparkline, select it and click the button Clean (Clear).
Result:
Result:
