Represents a group of s
Inheritance
object
Properties
Section titled "Properties"ColorAxis
Section titled "ColorAxis"Determines the color of the axis
public WorkbookColorInfo ColorAxis { get; set; }ColorFirstPoint
Section titled "ColorFirstPoint"Determines the color of the first point
public WorkbookColorInfo ColorFirstPoint { get; set; }ColorHighPoint
Section titled "ColorHighPoint"Determines the color of the high point
public WorkbookColorInfo ColorHighPoint { get; set; }ColorLastPoint
Section titled "ColorLastPoint"Determines the color of the last point
public WorkbookColorInfo ColorLastPoint { get; set; }ColorLowPoint
Section titled "ColorLowPoint"Determines the color of the low point
public WorkbookColorInfo ColorLowPoint { get; set; }ColorMarkers
Section titled "ColorMarkers"Determines the color of the markers
public WorkbookColorInfo ColorMarkers { get; set; }ColorNegativePoints
Section titled "ColorNegativePoints"Determines the color of the negative point
public WorkbookColorInfo ColorNegativePoints { get; set; }ColorSeries
Section titled "ColorSeries"Determines the default color for the series
public WorkbookColorInfo ColorSeries { get; set; }DateAxis
Section titled "DateAxis"Determines whether to use a date axis
public bool DateAxis { get; set; }DateRange
Section titled "DateRange"The date range (read-only)
public WorksheetRegion DateRange { get; }DateRangeFormula
Section titled "DateRangeFormula"The date range formula (read-only)
public Formula DateRangeFormula { get; }DisplayBlanksAs
Section titled "DisplayBlanksAs"Determines how blanks will be displayed
public SparklineDisplayBlanksAs DisplayBlanksAs { get; set; }DisplayHidden
Section titled "DisplayHidden"Determines whether values from cells that are hidden will be displayed
public bool DisplayHidden { get; set; }DisplayXAxis
Section titled "DisplayXAxis"Determines if the x-axis will be displayed
public bool DisplayXAxis { get; set; }FirstPoint
Section titled "FirstPoint"Determines if the first point is displayed differently.
public bool FirstPoint { get; set; }A unique identifier for this group (read-only).
public Guid? Guid { get; }HighPoint
Section titled "HighPoint"Determines if the high point is displayed differently.
public bool HighPoint { get; set; }LastPoint
Section titled "LastPoint"Determines if the last point is displayed differently.
public bool LastPoint { get; set; }LineWeight
Section titled "LineWeight"Determines the weight of a line in points.
public double LineWeight { get; set; }LowPoint
Section titled "LowPoint"Determines if the low point is displayed differently.
public bool LowPoint { get; set; }Markers
Section titled "Markers"Determines if markers are displayed.
public bool Markers { get; set; }NegativePoints
Section titled "NegativePoints"Determines if the negative points are displayed differently.
public bool NegativePoints { get; set; }RightToLeft
Section titled "RightToLeft"Determines if the sparkline goes from right to left.
public bool RightToLeft { get; set; }Sparklines
Section titled "Sparklines"The collection of sparklines in the group (read-only)
public SparklineCollection Sparklines { get; }The type of sparkline
public SparklineType Type { get; set; }VerticalAxisMax
Section titled "VerticalAxisMax"A custom maximum value for the Y axis.
public double VerticalAxisMax { get; set; }VerticalAxisMaxType
Section titled "VerticalAxisMaxType"Determines how the maximum value for the Y axis is calculated.
public SparklineAxisMinMax VerticalAxisMaxType { get; set; }VerticalAxisMin
Section titled "VerticalAxisMin"A custom minimum value for the Y axis.
public double VerticalAxisMin { get; set; }VerticalAxisMinType
Section titled "VerticalAxisMinType"Determines how the minimum value for the Y axis is calculated.
public SparklineAxisMinMax VerticalAxisMinType { get; set; }Workbook
Section titled "Workbook"Returns a reference to the associated workbook.
public Workbook Workbook { get; }Worksheet
Section titled "Worksheet"Returns a reference to the associated worksheet.
public Worksheet Worksheet { get; }Methods
Section titled "Methods"SetDateRange(string, CellReferenceMode?)
Section titled "SetDateRange(string, CellReferenceMode?)"Assigns a new .
public void SetDateRange(string dateRange, CellReferenceMode? cellReferenceMode = null)Parameters
- dateRange:
string - cellReferenceMode:
CellReferenceMode?