Contents |
Add sparklines
Add thumbnail size plots of each Y column above the data
1. sparklines;
2. sparklines sel:=0 c1:=4 c2:=6;
3. sparklines iw:=[Book1]Sheet1! sel:=0 c1:=2 c2:=5;
4. sparklines iw:=[Book1]Sheet1! sel:=0 c1:=6 c2:=8 template:=tabel;
5. sparklines iw:=[Book1]Sheet1! sel:=0 c1:=6 c2:=8 template:=tabel row_height:=300 keepAspect:=0 label:=0 endpts:=0;
| Display Name | Variable Name | I/O and Type | Default Value | Description |
|---|---|---|---|---|
| Input Worksheet | iw |
Input Worksheet | |
This specify the worksheet to manipulate, the default worksheet is the active worksheet. |
| Selected Columns | sel |
Input int | |
If sel is set to false, then you should specify c1 and c2. if sel is set to true, then sparklines will be added for the selected columns. By default, sel is set to true. |
| Column From | c1 |
Input int | |
Specify from which column to be manipulated. |
| Column To | c2 |
Input int | |
Specify to which column to be manipulated. |
| Graph Template | template |
Input string | |
Specify the template that will be used for the sparkline. You can select a template from Tools: Template Organizer. |
| Row Height (percent) | row_height |
Input int | |
The height of the row which shows the sparklines. By default it is double of the original cell. |
| Keep Aspect Ratio | keepAspect |
Input int | |
Specify whether to keep aspect ratio of the sparklines. If it is set to true, the x and y axes will be changed with same ratio, if it is set to false, then they will be changed respectively. By default it is set to false. |
| Hide Annotations | label |
Input int | |
If this variable is set to true, then any annotation in the graph will not show in the sparkline, if it is set to false, the annotation will show. By default it is set to true. |
| Show First and Last Points | endpts |
Input int | |
If this variable is set to true, the first and last points will be marked in the sparklines, if it is set to false, there will not be marks. |
| Plot Y Against X | xy |
Input int | |
Specify whether to plot the Y data against the associated X dataset. If this is set to false, all data will be plotted against the row umbers. |
The sparklines function can display the profile of the data in any Y column as a small graphical image that does not show associated x, y axes and labels etc. This feature is implemented according to the definition of sparklines by Edward Tufte. It gives the user a way to quickly view the shape of the data across many Y columns in a sheet without having to create graph windows. Each Sparkline object is in fact an embedded graph which can be brought up for editing by double-clicking on the sparkline.
In the command window, enter the following script:
sparklines row_height:=300 keepAspect:=0 label:=0 endpts:=0
This will add sparkline to the active column.