How to create a sparkline – Line
A sparkline is a visual representation of a data series in only one cell, the image above shows sparklines next to each team's performance data. There are no visible axes and axes values, only a line that quickly highlights the trend, min and max values.
How to build
- Press with mouse on a cell where you want the sparkline.
- Go to tab "Insert" on the ribbon.
- Press with left mouse button on "Line Sparkline" button to open the "Create Sparklines" dialog box.
- Select the cell range that contains the data.
- Press with left mouse button on OK button.
- Press and hold with left mouse button on the dot shown in above image, then drag down as far as necessary to create sparklines for each data series.
Sparkline category
A sparkline is a visual representation of a data series in only one cell, the image above shows sparklines next […]
A win/loss sparkline is a visual representation of a data series in only one cell, the image above shows a […]
Excel categories
Leave a Reply
How to comment
How to add a formula to your comment
<code>Insert your formula here.</code>
Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >
How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]
How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.