Sparklines are small and compact charts with high data density, and serve to display the trends and variations of associated data area in figures. SpreadsheetWEB converts them to web as long as they are correctly formed within the spreadsheet. There are 8 types of sparkline charts that SpreadsheetWEB currently supports.
The basic formula setting for SparklineLine chart is
Input Cells: It is the cell range that will make the sparkline line chart. (e.g. A1:C1, B1:N:5, C1:C22)
MaxMin: This paremeter defines the maximum and minimum points of the line chart. Sample values can be either 'True' or 'False'. If you want to mark the maximum and minimum points in the sparkline, write 'True' into the cell, otherwise write 'False'.
MaxMin = True
FirstLast: This option helps to point out the first and last points of the sparkline. If you enter 'True' into the cell, then the sparkline will be shown with edges at the beginning and end of the line. Write in 'False' for no edges.
FirstLast = True
AllPoints: In order to show multiple points on a sparkline, set this paremeter to 'True'. Otherwise set it to 'False'.
AllPoints = True
Finally the formula should be something like:
SparklineDiscreet gives a discreet look to the sparklines. The basic formula setting for SparklineDiscreet is:
InputCells: It is again the cell range you have to select in order to make a chart out of the data in those cells. (e.g. A1:D1, C1:E1, F1:G16)
Threshold: This paremeter changes the linear alignment of a bar by assigning two different colours (black and blue) to different sets of data values.
Threshold = 0
Let us assume that we have a set of numbers including 1, 7, -5, 0, 9, 12, -11 and 2. Their look when arranged in a row will change according to the threshold. Results for thresholds 0, 10 or -20 will be different for sure.
All in all, the formula should be like:
The basic formula setting for SparklineBar chart is:
The configuration of SparklineBar is same as that of SparklineDiscreet bar (see above), but the outcome is favorably different. SparklineBar charts look like the smaller copies of Excel bar graphs. Depending on the variance of the threshold value, appearance of the chart will change.
Threshold = 5
The formula you have entered should consequently be similar to:
The basic formula setting for SparklineArea chart is:
InputCells: Select the data range. (e.g. B3:I5)
Border: Default SparklineArea appears with no borders on the web application. If you want borders to the figure, simply write 'True' into the cell next to the cell range. The area will look framed in black. Enter 'False' for no borders.
Points: Just like the AllPoints parameter in SparklineLine, type in 'True' to get several points on the area highlighted. Again, type in 'False' for a plain area.
Color: This parameter gives you the opportunity to change the color of the chart. Write in "Red", "Orange" or "Blue", or use the RGB values like #DEFC11.
Color = "Orange"
Color = "Red"
In the end, the formula should look like:
The basic formula setting for SparklinePie chart is:
InputCells: Select the data set you want to display as a SparklinePie. (e.g. D1:E15)
Color: You can change the color of your charts. Simply write the name of the color or the RGB value into the relevant cell. (e.g. "Red" or #35CFA6)
Color = "Green"
Color = "Red"
Note that the formula cell should be something akin to:
The basic formula to make a SparklineIcon chart is:
Range1: Select the data set you want to apply one or more icons to. (e.g. A1:C1, D2:F7)
fltDataPlace: Since the formula is applicable to a single cell, you need to apply conditional formatting to the other cells as well, and write down the index interval of the other cells to this part of formula. (e.g. A1, B2, C3...)
strIconType: Choose the icons from the list of icon sets below i.e. "3 Arrows Colored".
Range2: You have to define these cells to adjust the border values for icon types. Since icons feature conditional formatting, those associated cells are very important and need to be supported by InputCells2. Also see the SortType parameter.
strSortType: This parameter requires three extra values (the "Percent", "Percentile", and "Number") to distribute the icons successfully. You are empowered to choose one of the three sort types. The formula will look into the InputCells, Index, and the InputCells2 respectively to determine if the sort type you have entered fits the requirements. Please see the examples for SparklineIcon.
Your formula should be similar to the following:
To understand the implementation of icons more clearly, please read the following examples:
|Example 1: "Number"|
Assume that there are the names of employees listed in your spreadsheet, and you want to apply an icon to each employee according to their salaries per year.
IconType = "3 Arrows Grey"
InputCells2 = "10000" and "50000"
SortType = "Number"
Then, the distribution of icons will most likely be as follows:
Employees whose salary per year is lower than 10000.
Employees whose salary per year is between 10000 and 50000.
Employees whose salary per year is higher than 50000.
|Example 2: "Percent"|
Assume that you need to icon 300 numbers with their values ratio.
IconType = "3 Signs"
InputCells2 = "50" and "70"
SortType = "Percent"
The formula detected that the highest number in the InputCells is 3215, so our icons will be distributed like;
Numbers that are smaller than (3215/100)*50
Numbers that are between (3215/100)*50 and (3215/100)*70
Numbers that are higher than (3215/100)*70
The chart formula for SparklineBullet is:
=SparklineBullet(InputCells, InputCells2, Color)
InputCells: Select the cells and write their range to this part. (e.g. A1:A11, B2:B13...)
InputCells2: This part is necessary for indicating the actual and target values of the bullet. It retains two cells: Actual and target values. Actual value means the cell that you want the bullet to capture. Starting from that value, the bullet chart stretches further enclosing the target value. However, it is optional to set a target value.
Color: Write the color name or the RGB value into the formula box. (e.g. "Green", #00FF00)
InputCells without target value and Color = "#00FF00"
Vertical Bullet Chart
Note that SpreadsheetWEB determines that a bullet chart should be Vertical or Horizontal based on the shape of the cell the formula is placed. If the width is larger than height, then chart becomes horizontal.
Your formula should be something like this:
The chart formula for SparklineScale is:
InputCells: The configuration of input cells for SparklineScale is different than the other sparkline charts. Input cells for scale entails three distinct cells: "Start Number", "Finish Number", and "Interval". Arrange them, for example, in such order: "A1:C1, B5:B7, C1:C3"
TopBottom: Set the parameter to 'False' if you want the scale to be upside down. Type in 'True' for an upward look.
TopBottom = True
TopBottom = False
Overall formula should look like: