1 10 1 10 0.5 8 1 0.25 1 False 6 Sparkline Properties dialog False vertical 12 False end _OK True True True True True True False True 1 _Close True True True True True False True 2 _Help True True True True False True 3 True False True end 2 True False True 12 12 True False 0 none True False 12 6 6 6 6 6 True True True Shrink 2 0 True True center True True 30 True Enter the cell range containing the data for the sparklines. 1 0 True True True Shrink 2 1 True True center True True 30 True Select the cell range to receive the sparkline. 1 1 True False Input range: True 0 0 0 True False Output range: True 0 0 1 True False Data 0 0 2 True False 0 none True False 12 6 3 6 True False Series: True 0 0 0 True True False start 0 True Select the main color for the sparklines. 1 0 Negative points: True True False True True Check and select the color for negative points. 0 1 True True False start 0 True Select the color for the negative points. 1 1 High points: True True False True True Check and select the color for high points. 0 2 True True False start 0 True Select the color for the high point. 1 2 Low points: True True False True True Check and select the color for low points. 0 3 True True False start 0 True Select the color for the low point. 1 3 Marker: True True False True True Check and select the color for data points (line type only). 0 4 True True False start 0 True Select the color for the data points markers. 1 4 First point: True True False True True Check and select the color for first point. 0 5 True True False start 0 True Select the color for the first point. 1 5 Last point: True True False True True Check and select the color for last point. 0 6 True True False start 0 True Select the color for the last point. 1 6 True False Colors 1 1 True False start True 0 none True False start 12 6 3 6 True False Line thickness: True seLineWidth 0 0 1 True True True 1,00 True adjustment-line-width 0.25 2 True True 1 Enter the line thickness number manually or use the spin button. 1 1 True False Display empty cells as: True cbEmptyCells 0 0 2 True False Gap Zero Span Display empty cells as: Gap - the missing data is not displayed. The line type discontinues in the gap and the column is not displayed. Zero - the missing data is displayed as value zero. Span - for line type only, draws a continuous line connecting the previous value to the next value. 1 2 Display hidden True True False True True Check to show all columns or stacks in the range even when the data is in hidden cells. If unchecked, the hidden data is ignored. 0 3 2 Right-to-left True True False True True Check to have the sparklines show the data in reverse order. 0 4 2 True False start Line Column Stacked Select the sparkline type in the drop-down list. Choices are: Line - draws a line between data values. Column - draws a bar for each data value. Stacked - also known as win/loss: displays equally sized bars indicating positive and negative values. 1 0 True False Type: True cbType 0 0 0 True False Properties 0 1 True False 0 none True False 12 6 3 6 True False 0 Individual Group Custom Individual: sets automatically the minimum value for each sparkline based on the sparkline data range values. Group: sets the minimum value based on the lower and higher values found in the group of sparklines. Custom: enter the minimum value for the sparkline group. 1 1 True True True 10 True adjustment-custom-min Spin or enter number to set the minimum value for the Y axis. 2 1 True False 0 Individual Group Custom Individual: sets automatically the maximum value for each sparkline based on the sparkline data range values. Group: sets the maximum value based on the lower and higher values found in the group of sparklines. Custom: enter the maximum value for the sparkline group. 1 2 True True True 10 True adjustment-custom-max Spin or enter number to set the maximum value for the Y axis. 2 2 True False start Vertical maximum: True cbMaxAxisType 0 0 2 True False start Vertical minimum: True cbMinAxisType 0 0 1 Display X axis True True False start True True Check to show the X axis for sparklines. 0 0 3 True False Axes 0 2 2 False True 1 ok cancel help