Class ExcelSparklineGroup

Represents a group of sparklines

Inheritance

object

XmlHelper

ExcelSparklineGroup

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

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
bool

DisplayXAxis

Displays the X axis

Declaration

public bool DisplayXAxis { get; set; }

Property Value

Type	Description
bool

First

Highlight the first point of data in the sparkline group

Declaration

public bool First { get; set; }

Property Value

Type	Description
bool

High

Highlight the highest point of data in the sparkline group

Declaration

public bool High { get; set; }

Property Value

Type	Description
bool

Last

Highlight the last point of data in the sparkline group

Declaration

public bool Last { get; set; }

Property Value

Type	Description
bool

LineWidth

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

Declaration

public double LineWidth { get; set; }

Property Value

Type	Description
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
bool

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
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
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
bool

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
bool

RightToLeft

Plot horizontal axis data right to left if true

Declaration

public bool RightToLeft { get; set; }

Property Value

Type	Description
bool

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