Sparklines In Excel 2013
Basics About Sparklines in Excel 2013
There are three distinct sorts of sparklines: Line, Column, and Win/Loss. Line and Column work the same as line and segment charts. Win/Loss is comparable to Column, aside from it just shows whether each esteem is positive or negative rather than how high or low the values are. Every one of the three kinds can display markers at essential focuses, for example, the highest and lowest points, to make them less demanding to peruse.
Why use sparklines?
Sparkline has certain focal points over outlines. For instance, suppose you have 1,000 lines of information. A conventional diagram would have 1,000 information arrangement to speak to the majority of the columns, making applicable information hard to discover. In any case, on the off chance that you put a sparkline on each line, it will be appropriate by its source information, making it simple to see relationships and trends for numerous information arrangement in the meantime.
In the picture underneath, the outline is to a great degree jumbled and hard to take after, yet the sparkline enables you to unmistakably take after every salesman’s information.
Sparklines are ideal for situations when you need a clear overview of the data at a glance and when you don’t need all of the features of a full chart. On the other hand, charts are ideal for situations when you want to represent the data in greater detail, and they are often better for comparing different data series.
To create sparklines:
Generally, you will have one sparkline for each row, but you can create as many as you want in any location. Just like formulas, it’s usually easiest to create a single sparkline and then uses the fill handle to create sparkline for the adjacent rows. In our example, we’ll create sparkline to help visualize trends in sales over time for each salesperson.
- Select the cells that will serve as the source data for the first sparkline. In our example, we’ll select the cell range B2:G2.
- Select the Insert tab, then choose the desired Sparkline from the Sparklines group. In our example, we’ll choose Line.
- The Create Sparklines dialog box will appear. Use the mouse to select the cell where the sparkline will appear, then click OK. In our example, we’ll select cell H2, and the cell reference will appear in the Location Range: field.
- The sparkline will appear in the specified cell.
- Click, hold, and drag the fill handle to create sparklines in adjacent cells.
- Sparklines will be created for the selected cells. In our example, the sparklines show clear trends in sales over time for each salesperson in our worksheet.
To read more about Office Products visit WWW.OFFICE.COM/SETUP