insertSparklines

1 Menu Information
2 Brief Information
3 Command Line Usage
4 Variables
5 Description
6 Related X-Functions

Menu Information

Insert Sparklines...

Brief Information

Insert sparklines into worksheet cells

Command Line Usage

1. insertSparklines irng:=col(2) orng:=col(3)[1];

2. insertSparklines irng:=col(2):col(4) name:=0 c2:=min c3:=max label:=0 size:=double orng:=col(5)[1];

3. insertSparklines irng:=col(2):col(4) name:=0 c2:=mean keepAspect:=1 endpts:=0 orng:=col(5)[5] xfrom:=0 xto:=500 yfrom:=0 yto:=200;

Variables

Display Name	Variable Name	I/O and Type	Default Value	Description
Data Columns	irng	Input Range	<>	Specifies the data columns for the sparklines.
Insert Direction	insertDir	Input int	vertical	Specifies the direction of the inserted cells. Option list: horizontal:Horizontal Horizontal vertical:Vertical Vertical
Long Name in 1st Column	name	Input int	1	Specifies whether or not to show the long names of the data columns in the first column.
Add 3rd Column	c2	Input int	none	Specifies whether or not to add a third column. If this column will be added, user can further specify its content. Option list: none:None Does not add the third column. comments:Comments Adds the comment of each data column. parameter1:Parameter 1 Adds the parameter1 of each data column. mean:Mean Adds the mean value of each data column. min:Min Adds the minimum value of each data column. max:Max Adds the maximum value of each data column.
Add 4th Column	c3	Input int	none	Specifies whether or not to add a fourth column. If this column will be added, user can further specify its content. Option list: none:None Does not add the fourth column. comments:Comments Adds the comment of each data column. parameter1:Parameter 1 Adds the parameter1 of each data column. mean:Mean Adds the mean value of each data column. min:Min Adds the minimum value of each data column. max:Max Adds the maximum value of each data column.
Add 5th Column	c4	Input int	none	Specifies whether or not to add a fifth column. If this column will be added, user can further specify its content. Option list: none:None Does not add the fifth column. comments:Comments Adds the comment of each data column. parameter1:Parameter 1 Adds the parameter1 of each data column. mean:Mean Adds the mean value of each data column. min:Min Adds the minimum value of each data column. max:Max Adds the maximum value of each data column.
Add 6th Column	c5	Input int	none	Specifies whether or not to add a sixth column. If this column will be added, user can further specify its content. Option list: none:None Does not add the sixth column. comments:Comments Adds the comment of each data column. parameter1:Parameter 1 Adds the parameter1 of each data column. mean:Mean Adds the mean value of each data column. min:Min' Adds the minimum value of each data column. max:Max Adds the maximum value of each data column.
Graph Template	template	Input string	sparkline_label	Specifies the graph template used to generate the sparklines.
Hide Annotations	label	Input int	1	Specifies whether or not to hide the annotation (text labels and legend) on the sparklines.
Keep Aspect Ratio	keepAspect	Input int	0	Specifies whether or not to keep the aspect ratio of the sparklines.
Sparkline Cell Height	size	Input int	normal	Specifies the height of the cells, into which the sparklines are inserted. Option list: normal:Normal Uses normal size. double:Double Uses double size.
Show First and Last Points	endpts	Input int	1	Specifies whether to show the first and last points for the sparklines.
Top Left Cell	orng	Output Range	<active>	Specifies the top left cell (the first cell) to insert. See the syntax here.
X From	xfrom	Input double	<unassigned>	Specifies the first X scale value for the sparklines.
X To	xto	Input double	<unassigned>	Specifies the last X scale value for the sparklines.
Y From	yfrom	Input double	<unassigned>	Specifies the first Y scale value for the sparklines.
Y To	yto	Input double	<unassigned>	Specifies the last Y scale value for the sparklines.

Description

This X-Function plots the sparklines for a range of data columns and inserts them into specified worksheet cells. It can also calculate the mean value, minimum value and maximum value of each data column. You can use it to generate a simple report for the data columns.

We can run it in script. And we can click the right key to open the popup menu, select Insert sparklines item.

Related X-Functions

insertGraph, insertNotes, insertImg, insertArrow, insertVar