Name | Description | |
---|---|---|
ExcelSparklineSetting Constructor | Overloaded. |
The following tables list the members exposed by ExcelSparklineSetting.
Name | Description | |
---|---|---|
ExcelSparklineSetting Constructor | Overloaded. |
Name | Description | |
---|---|---|
AxisColor | Gets or sets the color of the axis. | |
DateAxis | Gets or sets a value that indicates whether the sparkline is using the date axis. | |
DisplayEmptyCellsAs | Gets or sets what to display empty cells as. | |
DisplayHidden | Gets or sets a value that indicates whether data in hidden cells is plotted for the sparklines in this sparkline group. | |
DisplayXAxis | Gets or sets a value that indicates whether the horizontal axis is displayed for each sparkline in this sparkline group. | |
FirstMarkerColor | Gets or sets the color of the first data point for each sparkline in this sparkline group. | |
Formula | Gets or sets a value that specifies the date range for the sparkline group. | |
HighMarkerColor | Gets or sets the color of the highest data point for each sparkline in this sparkline group. | |
LastMarkerColor | Gets or sets the color of the last data point for each sparkline in this sparkline group. | |
LineWeight | Gets or sets a value that specifies the line weight for each sparkline in the sparkline group, where the line weight is measured in points. The weight must be greater than or equal to zero, and must be less than or equal to 3 (LineSeries only supports a line weight value in the range of 0.0->3.0). | |
LowMarkerColor | Gets or sets the color of the lowest data point for each sparkline in this sparkline group. | |
ManualMax | Gets or sets a value that specifies the maximum for the vertical axis that is shared across all sparklines in this sparkline group. The value must be zero if maxAxisType does not equal custom. | |
ManualMin | Gets or sets a value that specifies the minimum for the vertical axis that is shared across all sparklines in this sparkline group. The value must be zero if minAxisType does not equal custom. | |
MarkersColor | Gets or sets a value that specifies the color of the data markers for each sparkline in this sparkline group. | |
MaxAxisType | Gets or sets a value that specifies how the vertical axis maximums for the sparklines in this sparkline group are calculated. | |
MinAxisType | Gets or sets a value that specifies how the vertical axis minimums for the sparklines in this sparkline group are calculated. | |
NegativeColor | Gets or sets a value that specifies the color of the negative data points for each sparkline in this sparkline group. | |
ReferenceError | Gets a value that indicates whether the current cell range is an invalid reference. | |
RightToLeft | Gets or sets a value that specifies whether each sparkline in the sparkline group is displayed in a right-to-left manner. | |
SeriesColor | Gets or sets a value that specifies the color for each sparkline in this sparkline group. | |
ShowFirst | Gets or sets a value that indicates whether the first data point is formatted differently for each sparkline in this sparkline group. | |
ShowHigh | Gets or sets a value that specifies whether the data points with the highest value are formatted differently for each sparkline in this sparkline group. | |
ShowLast | Gets or sets a value that indicates whether the last data point is formatted differently for each sparkline in this sparkline group. | |
ShowLow | Gets or sets a value that specifies whether the data points with the lowest value are formatted differently for each sparkline in this sparkline group. | |
ShowMarkers | Gets or sets a value that specifies whether data markers are displayed for each sparkline in this sparkline group. | |
ShowNegative | Gets or sets a value that specifies whether the negative data points are formatted differently for each sparkline in this sparkline group. |
Name | Description | |
---|---|---|
Clone | Creates a new object that is a copy of the current instance. | |
Deserialize | Loads the object from XML. | |
Dispose | Performs application-defined tasks associated with freeing, releasing, or resetting unmanaged resources. | |
GetObjectData | Populates a System.Runtime.Serialization.SerializationInfo with the data needed to serialize the target object. | |
ReLoadFormula | Reevaluates the formula. | |
Serialize | Saves the object to XML. |
Name | Description | |
---|---|---|
FireChanged | Fires the changed event. | |
FireUpdated | Fires the updated event. | |
OnPropertyChanged | Raises the PropertyChanged event. | |
OnUpdated | Raises the Updated event. | |
ShouldSerializeAxisColor | Sets whether to serialize the axis color. | |
ShouldSerializeDateAxis | Sets whether to serialize the date axis. | |
ShouldSerializeDisplayEmptyCellsAs | Sets whether to serialize the display empty cells as option. | |
ShouldSerializeDisplayHidden | Sets whether to serialize the display hidden option. | |
ShouldSerializeDisplayXAxis | Sets whether to serialize the display X axis option. | |
ShouldSerializeFirstMarkerColor | Sets whether to serialize the first marker color. | |
ShouldSerializeFormula | Sets whether to serialize the formula. | |
ShouldSerializeHighMarkerColor | Sets whether to serialize the high marker color. | |
ShouldSerializeLastMarkerColor | Sets whether to serialize the last marker color. | |
ShouldSerializeLineWeight | Sets whether to serialize line weight. | |
ShouldSerializeLowMarkerColor | Sets whether to serialize the low marker color. | |
ShouldSerializeManualMax | Sets whether to serialize the manual max setting. | |
ShouldSerializeManualMin | Sets whether to serialize the manual min setting. | |
ShouldSerializeMarkersColor | Sets whether to serialize the markers color. | |
ShouldSerializeMaxAxisType | Sets whether to serialize the maximum axis type setting. | |
ShouldSerializeMinAxisType | Sets whether to serialize the minimum axis type setting. | |
ShouldSerializeNegativeColor | Sets whether to serialize the negative color. | |
ShouldSerializeRightToLeft | Sets whether to serialize the right to left setting. | |
ShouldSerializeSeriesColor | Sets whether to serialize the series color. | |
ShouldSerializeShowFirst | Sets whether to serialize the show first option. | |
ShouldSerializeShowHigh | Sets whether to serialize the show high option. | |
ShouldSerializeShowLast | Sets whether to serialize the show last option. | |
ShouldSerializeShowLow | Sets whether to serialize the show low option. | |
ShouldSerializeShowMarkers | Sets whether to serialize show markers. | |
ShouldSerializeShowNegative | Sets whether to serialize the show negative setting. |
Name | Description | |
---|---|---|
FormulaChanged | Occurs when the formula is changed. | |
PropertyChanged | Occurs when a property value changes. | |
Updated | Occurs when data has been updated. |