Class ExcelSparklineGroup

Represents a group of sparklines

Inheritance

System.Object

XmlHelper

ExcelSparklineGroup

Inherited Members

System.Object.Equals(System.Object)

System.Object.Equals(System.Object, System.Object)

System.Object.GetHashCode()

System.Object.GetType()

System.Object.MemberwiseClone()

System.Object.ReferenceEquals(System.Object, System.Object)

System.Object.ToString()

Namespace: OfficeOpenXml.Sparkline

Assembly: EPPlus.dll

Syntax

public class ExcelSparklineGroup : XmlHelper

Properties

ColorAxis

Markercolor for the lowest negative point

Declaration

public ExcelSparklineColor ColorAxis { get; }

Property Value

Type	Description
ExcelSparklineColor

ColorFirst

The color of the first point

Declaration

public ExcelSparklineColor ColorFirst { get; }

Property Value

Type	Description
ExcelSparklineColor

ColorHigh

The color of the point with the highest value

Declaration

public ExcelSparklineColor ColorHigh { get; }

Property Value

Type	Description
ExcelSparklineColor

ColorLast

The color of the last point

Declaration

public ExcelSparklineColor ColorLast { get; }

Property Value

Type	Description
ExcelSparklineColor

ColorLow

The color of the point with the lowest value

Declaration

public ExcelSparklineColor ColorLow { get; }

Property Value

Type	Description
ExcelSparklineColor

ColorMarkers

Default marker color

Declaration

public ExcelSparklineColor ColorMarkers { get; }

Property Value

Type	Description
ExcelSparklineColor

ColorNegative

Markercolor for the lowest negative point

Declaration

public ExcelSparklineColor ColorNegative { get; }

Property Value

Type	Description
ExcelSparklineColor

ColorSeries

Sparkline color

Declaration

public ExcelSparklineColor ColorSeries { get; }

Property Value

Type	Description
ExcelSparklineColor

DataRange

The range containing the data from the sparklines

Declaration

public ExcelRangeBase DataRange { get; }

Property Value

Type	Description
ExcelRangeBase

DateAxisRange

The range containing the dateaxis from the sparklines. Set to Null to remove the dateaxis.

Declaration

public ExcelRangeBase DateAxisRange { get; set; }

Property Value

Type	Description
ExcelRangeBase

DisplayEmptyCellsAs

How to display empty cells in the series

Declaration

public eDispBlanksAs DisplayEmptyCellsAs { get; set; }

Property Value

Type	Description
eDispBlanksAs

DisplayHidden

Display hidden cells

Declaration

public bool DisplayHidden { get; set; }

Property Value

Type	Description
System.Boolean

DisplayXAxis

Displays the X axis

Declaration

public bool DisplayXAxis { get; set; }

Property Value

Type	Description
System.Boolean

First

Highlight the first point of data in the sparkline group

Declaration

public bool First { get; set; }

Property Value

Type	Description
System.Boolean

High

Highlight the highest point of data in the sparkline group

Declaration

public bool High { get; set; }

Property Value

Type	Description
System.Boolean

Last

Highlight the last point of data in the sparkline group

Declaration

public bool Last { get; set; }

Property Value

Type	Description
System.Boolean

LineWidth

The weight of the line. Applies to line sparklines only.

Declaration

public double LineWidth { get; set; }

Property Value

Type	Description
System.Double

LocationRange

The range containing the sparklines

Declaration

public ExcelRangeBase LocationRange { get; }

Property Value

Type	Description
ExcelRangeBase

Low

Highlight the lowest point of data in the sparkline group

Declaration

public bool Low { get; set; }

Property Value

Type	Description
System.Boolean

ManualMax

When MaxAxisType type is set to Custom, this value sets the maximum value MaxAxisType

Declaration

public double ManualMax { get; set; }

Property Value

Type	Description
System.Double

ManualMin

When MinAxisType type is set to Custom, this value sets the minimum value MinAxisType

Declaration

public double ManualMin { get; set; }

Property Value

Type	Description
System.Double

Markers

Highlight each point in each sparkline in the sparkline group. Applies to line sparklines only

Declaration

public bool Markers { get; set; }

Property Value

Type	Description
System.Boolean

MaxAxisType

Vertical axis maximum value options

Declaration

public eSparklineAxisMinMax MaxAxisType { get; set; }

Property Value

Type	Description
eSparklineAxisMinMax

MinAxisType

Vertical axis minimum value options

Declaration

public eSparklineAxisMinMax MinAxisType { get; set; }

Property Value

Type	Description
eSparklineAxisMinMax

Negative

Highlight negative points of data in the sparkline group with a different color or marker

Declaration

public bool Negative { get; set; }

Property Value

Type	Description
System.Boolean

RightToLeft

Plot horizontal axis data right to left if true

Declaration

public bool RightToLeft { get; set; }

Property Value

Type	Description
System.Boolean

Sparklines

The Sparklines for the sparklinegroup

Declaration

public ExcelSparklineCollection Sparklines { get; }

Property Value

Type	Description
ExcelSparklineCollection

Type

Type of sparkline

Declaration

public eSparklineType Type { get; set; }

Property Value

Type	Description
eSparklineType