API Reference

Class

ExcelChart

Edit on GitHub

Namespace OfficeIMO.Excel

Assembly OfficeIMO.Excel

Source OfficeIMO.Excel/ExcelChart.cs:50

Modifiers sealed

Represents a chart on a worksheet.

Inheritance

Object
ExcelChart

Methods

ApplyStylePreset 2 overloads

public ExcelChart ApplyStylePreset(Int32 styleId = 251, Int32 colorStyleId = 10) #

OfficeIMO.Excel/ExcelChart.cs:210

Returns: ExcelChart

Applies a built-in chart style/color preset.

Parameters

styleId System.Int32 = 251 optionalposition: 0
colorStyleId System.Int32 = 10 optionalposition: 1

public ExcelChart ApplyStylePreset(ExcelChartStylePreset preset) #

OfficeIMO.Excel/ExcelChart.cs:220

Returns: ExcelChart

Applies a chart style/color preset.

Parameters

preset OfficeIMO.Excel.ExcelChartStylePreset requiredposition: 0

ClearSeriesTrendline 2 overloads

public ExcelChart ClearSeriesTrendline(Int32 seriesIndex) #

OfficeIMO.Excel/ExcelChart.cs:2059

Returns: ExcelChart

Removes trendlines from a chart series by index.

Parameters

seriesIndex System.Int32 requiredposition: 0

public ExcelChart ClearSeriesTrendline(String seriesName, Boolean ignoreCase = true) #

OfficeIMO.Excel/ExcelChart.cs:2079

Returns: ExcelChart

Removes trendlines from a chart series by name.

Parameters

seriesName System.String requiredposition: 0
ignoreCase System.Boolean = true optionalposition: 1

public ExcelChart ClearTitle() #

OfficeIMO.Excel/ExcelChart.cs:141

Returns: ExcelChart

Removes the chart title.

public ExcelChart ClearValueAxisDisplayUnits(ExcelChartAxisGroup axisGroup = Primary) #

OfficeIMO.Excel/ExcelChart.cs:1346

Returns: ExcelChart

Clears display units from the value axis.

Parameters

axisGroup OfficeIMO.Excel.ExcelChartAxisGroup = Primary optionalposition: 0

public ExcelChart HideLegend() #

OfficeIMO.Excel/ExcelChart.cs:200

Returns: ExcelChart

Hides the chart legend.

public ExcelChart SetCategoryAxisCrossing(CrossesValues crosses, Nullable<Double> crossesAt = null, ExcelChartAxisGroup axisGroup = Primary)

OfficeIMO.Excel/ExcelChart.cs:1115

Returns: ExcelChart

Sets where the category axis crosses the value axis.

Parameters

crosses DocumentFormat.OpenXml.Drawing.Charts.CrossesValues requiredposition: 0
crossesAt System.Nullable{System.Double} = null optionalposition: 1
axisGroup OfficeIMO.Excel.ExcelChartAxisGroup = Primary optionalposition: 2

public ExcelChart SetCategoryAxisGridlines(Boolean showMajor = true, Boolean showMinor = false, String lineColor = null, Nullable<Double> lineWidthPoints = null, ExcelChartAxisGroup axisGroup = Primary)

OfficeIMO.Excel/ExcelChart.cs:1027

Returns: ExcelChart

Sets category axis gridlines visibility and optional styling.

Parameters

showMajor System.Boolean = true optionalposition: 0
showMinor System.Boolean = false optionalposition: 1
lineColor System.String = null optionalposition: 2
lineWidthPoints System.Nullable{System.Double} = null optionalposition: 3
axisGroup OfficeIMO.Excel.ExcelChartAxisGroup = Primary optionalposition: 4

public ExcelChart SetCategoryAxisLabelRotation(Double rotationDegrees, ExcelChartAxisGroup axisGroup = Primary) #

OfficeIMO.Excel/ExcelChart.cs:1062

Returns: ExcelChart

Sets the category axis label rotation in degrees (-90..90).

Parameters

rotationDegrees System.Double requiredposition: 0
axisGroup OfficeIMO.Excel.ExcelChartAxisGroup = Primary optionalposition: 1

public ExcelChart SetCategoryAxisLabelTextStyle(Nullable<Double> fontSizePoints = null, Nullable<Boolean> bold = null, Nullable<Boolean> italic = null, String color = null, String fontName = null, ExcelChartAxisGroup axisGroup = Primary)

OfficeIMO.Excel/ExcelChart.cs:1045

Returns: ExcelChart

Sets the category axis label text style.

Parameters

fontSizePoints System.Nullable{System.Double} = null optionalposition: 0
bold System.Nullable{System.Boolean} = null optionalposition: 1
italic System.Nullable{System.Boolean} = null optionalposition: 2
color System.String = null optionalposition: 3
fontName System.String = null optionalposition: 4
axisGroup OfficeIMO.Excel.ExcelChartAxisGroup = Primary optionalposition: 5

SetCategoryAxisNumberFormat 2 overloads

public ExcelChart SetCategoryAxisNumberFormat(String formatCode, Boolean sourceLinked = false) #

OfficeIMO.Excel/ExcelChart.cs:1438

Returns: ExcelChart

Sets the category axis number format.

Parameters

formatCode System.String requiredposition: 0
sourceLinked System.Boolean = false optionalposition: 1

public ExcelChart SetCategoryAxisNumberFormat(String formatCode, Boolean sourceLinked, ExcelChartAxisGroup axisGroup) #

OfficeIMO.Excel/ExcelChart.cs:1445

Returns: ExcelChart

Sets the category axis number format for the selected axis group.

Parameters

formatCode System.String requiredposition: 0
sourceLinked System.Boolean requiredposition: 1
axisGroup OfficeIMO.Excel.ExcelChartAxisGroup requiredposition: 2

public ExcelChart SetCategoryAxisReverseOrder(Boolean reverseOrder = true, ExcelChartAxisGroup axisGroup = Primary) #

OfficeIMO.Excel/ExcelChart.cs:1367

Returns: ExcelChart

Sets the category axis orientation (normal or reversed order).

Parameters

reverseOrder System.Boolean = true optionalposition: 0
axisGroup OfficeIMO.Excel.ExcelChartAxisGroup = Primary optionalposition: 1

public ExcelChart SetCategoryAxisTickLabelPosition(TickLabelPositionValues position, ExcelChartAxisGroup axisGroup = Primary)

OfficeIMO.Excel/ExcelChart.cs:1078

Returns: ExcelChart

Sets the category axis tick label position.

Parameters

position DocumentFormat.OpenXml.Drawing.Charts.TickLabelPositionValues requiredposition: 0
axisGroup OfficeIMO.Excel.ExcelChartAxisGroup = Primary optionalposition: 1

SetCategoryAxisTitle 2 overloads

public ExcelChart SetCategoryAxisTitle(String title) #

OfficeIMO.Excel/ExcelChart.cs:979

Returns: ExcelChart

Sets the category axis title.

Parameters

title System.String requiredposition: 0

public ExcelChart SetCategoryAxisTitle(String title, ExcelChartAxisGroup axisGroup) #

OfficeIMO.Excel/ExcelChart.cs:986

Returns: ExcelChart

Sets the category axis title for the selected axis group.

Parameters

title System.String requiredposition: 0
axisGroup OfficeIMO.Excel.ExcelChartAxisGroup requiredposition: 1

public ExcelChart SetCategoryAxisTitleTextStyle(Nullable<Double> fontSizePoints = null, Nullable<Boolean> bold = null, Nullable<Boolean> italic = null, String color = null, String fontName = null, ExcelChartAxisGroup axisGroup = Primary)

OfficeIMO.Excel/ExcelChart.cs:1009

Returns: ExcelChart

Sets the category axis title text style.

Parameters

fontSizePoints System.Nullable{System.Double} = null optionalposition: 0
bold System.Nullable{System.Boolean} = null optionalposition: 1
italic System.Nullable{System.Boolean} = null optionalposition: 2
color System.String = null optionalposition: 3
fontName System.String = null optionalposition: 4
axisGroup OfficeIMO.Excel.ExcelChartAxisGroup = Primary optionalposition: 5

public ExcelChart SetChartAreaStyle(String fillColor = null, String lineColor = null, Nullable<Double> lineWidthPoints = null, Boolean noFill = false, Boolean noLine = false)

OfficeIMO.Excel/ExcelChart.cs:1967

Returns: ExcelChart

Sets chart area fill/line styling.

Parameters

fillColor System.String = null optionalposition: 0
lineColor System.String = null optionalposition: 1
lineWidthPoints System.Nullable{System.Double} = null optionalposition: 2
noFill System.Boolean = false optionalposition: 3
noLine System.Boolean = false optionalposition: 4

public ExcelChart SetDataLabelCallouts(Boolean enabled = true, Nullable<DataLabelPositionValues> position = null, String lineColor = null, Nullable<Double> lineWidthPoints = null)

OfficeIMO.Excel/ExcelChart.cs:499

Returns: ExcelChart

Enables callout-style labels by positioning labels outside with leader lines.

Parameters

enabled System.Boolean = true optionalposition: 0
position System.Nullable{DocumentFormat.OpenXml.Drawing.Charts.DataLabelPositionValues} = null optionalposition: 1
lineColor System.String = null optionalposition: 2
lineWidthPoints System.Nullable{System.Double} = null optionalposition: 3

public ExcelChart SetDataLabelLeaderLines(Boolean showLeaderLines = true, String lineColor = null, Nullable<Double> lineWidthPoints = null)

OfficeIMO.Excel/ExcelChart.cs:417

Returns: ExcelChart

Configures data label leader lines for all chart labels.

Parameters

showLeaderLines System.Boolean = true optionalposition: 0
lineColor System.String = null optionalposition: 1
lineWidthPoints System.Nullable{System.Double} = null optionalposition: 2

SetDataLabels 2 overloads

public ExcelChart SetDataLabels(Boolean showValue = true, Boolean showCategoryName = false, Boolean showSeriesName = false, Boolean showLegendKey = false, Boolean showPercent = false)

OfficeIMO.Excel/ExcelChart.cs:234

Returns: ExcelChart

Configures data labels for all supported chart series.

Parameters

showValue System.Boolean = true optionalposition: 0
showCategoryName System.Boolean = false optionalposition: 1
showSeriesName System.Boolean = false optionalposition: 2
showLegendKey System.Boolean = false optionalposition: 3
showPercent System.Boolean = false optionalposition: 4

public ExcelChart SetDataLabels(Boolean showValue, Boolean showCategoryName, Boolean showSeriesName, Boolean showLegendKey, Boolean showPercent, Nullable<DataLabelPositionValues> position, String numberFormat, Boolean sourceLinked = false)

OfficeIMO.Excel/ExcelChart.cs:243

Returns: ExcelChart

Configures data labels for all supported chart series with optional formatting.

Parameters

showValue System.Boolean requiredposition: 0
showCategoryName System.Boolean requiredposition: 1
showSeriesName System.Boolean requiredposition: 2
showLegendKey System.Boolean requiredposition: 3
showPercent System.Boolean requiredposition: 4
position System.Nullable{DocumentFormat.OpenXml.Drawing.Charts.DataLabelPositionValues} requiredposition: 5
numberFormat System.String requiredposition: 6
sourceLinked System.Boolean = false optionalposition: 7

public ExcelChart SetDataLabelSeparator(String separator) #

OfficeIMO.Excel/ExcelChart.cs:801

Returns: ExcelChart

Sets the separator for all data labels.

Parameters

separator System.String requiredposition: 0

public ExcelChart SetDataLabelShapeStyle(String fillColor = null, String lineColor = null, Nullable<Double> lineWidthPoints = null, Boolean noFill = false, Boolean noLine = false)

OfficeIMO.Excel/ExcelChart.cs:335

Returns: ExcelChart

Sets data label shape styling for all chart labels.

Parameters

fillColor System.String = null optionalposition: 0
lineColor System.String = null optionalposition: 1
lineWidthPoints System.Nullable{System.Double} = null optionalposition: 2
noFill System.Boolean = false optionalposition: 3
noLine System.Boolean = false optionalposition: 4

public ExcelChart SetDataLabelTextStyle(Nullable<Double> fontSizePoints = null, Nullable<Boolean> bold = null, Nullable<Boolean> italic = null, String color = null, String fontName = null)

OfficeIMO.Excel/ExcelChart.cs:296

Returns: ExcelChart

Sets data label text style for all chart labels.

Parameters

fontSizePoints System.Nullable{System.Double} = null optionalposition: 0
bold System.Nullable{System.Boolean} = null optionalposition: 1
italic System.Nullable{System.Boolean} = null optionalposition: 2
color System.String = null optionalposition: 3
fontName System.String = null optionalposition: 4

public ExcelChart SetLegend(LegendPositionValues position, Boolean overlay = false) #

OfficeIMO.Excel/ExcelChart.cs:152

Returns: ExcelChart

Sets the legend position and visibility.

Parameters

position DocumentFormat.OpenXml.Drawing.Charts.LegendPositionValues requiredposition: 0
overlay System.Boolean = false optionalposition: 1

public ExcelChart SetLegendTextStyle(Nullable<Double> fontSizePoints = null, Nullable<Boolean> bold = null, Nullable<Boolean> italic = null, String color = null, String fontName = null)

OfficeIMO.Excel/ExcelChart.cs:183

Returns: ExcelChart

Sets the legend text style.

Parameters

fontSizePoints System.Nullable{System.Double} = null optionalposition: 0
bold System.Nullable{System.Boolean} = null optionalposition: 1
italic System.Nullable{System.Boolean} = null optionalposition: 2
color System.String = null optionalposition: 3
fontName System.String = null optionalposition: 4

public ExcelChart SetPlotAreaStyle(String fillColor = null, String lineColor = null, Nullable<Double> lineWidthPoints = null, Boolean noFill = false, Boolean noLine = false)

OfficeIMO.Excel/ExcelChart.cs:1990

Returns: ExcelChart

Sets plot area fill/line styling.

Parameters

fillColor System.String = null optionalposition: 0
lineColor System.String = null optionalposition: 1
lineWidthPoints System.Nullable{System.Double} = null optionalposition: 2
noFill System.Boolean = false optionalposition: 3
noLine System.Boolean = false optionalposition: 4

public ExcelChart SetScatterXAxisCrossing(CrossesValues crosses, Nullable<Double> crossesAt = null) #

OfficeIMO.Excel/ExcelChart.cs:1165

Returns: ExcelChart

Sets where the scatter X-axis crosses the Y-axis.

Parameters

crosses DocumentFormat.OpenXml.Drawing.Charts.CrossesValues requiredposition: 0
crossesAt System.Nullable{System.Double} = null optionalposition: 1

public ExcelChart SetScatterXAxisScale(Nullable<Double> minimum = null, Nullable<Double> maximum = null, Nullable<Double> majorUnit = null, Nullable<Double> minorUnit = null, Nullable<Boolean> reverseOrder = null, Nullable<Boolean> logScale = null, Nullable<Double> logBase = null)

OfficeIMO.Excel/ExcelChart.cs:1392

Returns: ExcelChart

Sets scatter chart X-axis scale (value axis on the bottom).

Parameters

minimum System.Nullable{System.Double} = null optionalposition: 0
maximum System.Nullable{System.Double} = null optionalposition: 1
majorUnit System.Nullable{System.Double} = null optionalposition: 2
minorUnit System.Nullable{System.Double} = null optionalposition: 3
reverseOrder System.Nullable{System.Boolean} = null optionalposition: 4
logScale System.Nullable{System.Boolean} = null optionalposition: 5
logBase System.Nullable{System.Double} = null optionalposition: 6

public ExcelChart SetScatterYAxisCrossing(CrossesValues crosses, Nullable<Double> crossesAt = null) #

OfficeIMO.Excel/ExcelChart.cs:1190

Returns: ExcelChart

Sets where the scatter Y-axis crosses the X-axis.

Parameters

crosses DocumentFormat.OpenXml.Drawing.Charts.CrossesValues requiredposition: 0
crossesAt System.Nullable{System.Double} = null optionalposition: 1

public ExcelChart SetScatterYAxisScale(Nullable<Double> minimum = null, Nullable<Double> maximum = null, Nullable<Double> majorUnit = null, Nullable<Double> minorUnit = null, Nullable<Boolean> reverseOrder = null, Nullable<Boolean> logScale = null, Nullable<Double> logBase = null)

OfficeIMO.Excel/ExcelChart.cs:1416

Returns: ExcelChart

Sets scatter chart Y-axis scale (value axis on the left).

Parameters

minimum System.Nullable{System.Double} = null optionalposition: 0
maximum System.Nullable{System.Double} = null optionalposition: 1
majorUnit System.Nullable{System.Double} = null optionalposition: 2
minorUnit System.Nullable{System.Double} = null optionalposition: 3
reverseOrder System.Nullable{System.Boolean} = null optionalposition: 4
logScale System.Nullable{System.Boolean} = null optionalposition: 5
logBase System.Nullable{System.Double} = null optionalposition: 6

SetSeriesDataLabelCallouts 2 overloads

public ExcelChart SetSeriesDataLabelCallouts(Int32 seriesIndex, Boolean enabled = true, Nullable<DataLabelPositionValues> position = null, String lineColor = null, Nullable<Double> lineWidthPoints = null)

OfficeIMO.Excel/ExcelChart.cs:510

Returns: ExcelChart

Enables callout-style labels for a series by index.

Parameters

seriesIndex System.Int32 requiredposition: 0
enabled System.Boolean = true optionalposition: 1
position System.Nullable{DocumentFormat.OpenXml.Drawing.Charts.DataLabelPositionValues} = null optionalposition: 2
lineColor System.String = null optionalposition: 3
lineWidthPoints System.Nullable{System.Double} = null optionalposition: 4

public ExcelChart SetSeriesDataLabelCallouts(String seriesName, Boolean enabled = true, Nullable<DataLabelPositionValues> position = null, String lineColor = null, Nullable<Double> lineWidthPoints = null, Boolean ignoreCase = true)

OfficeIMO.Excel/ExcelChart.cs:524

Returns: ExcelChart

Enables callout-style labels for a series by name.

Parameters

seriesName System.String requiredposition: 0
enabled System.Boolean = true optionalposition: 1
position System.Nullable{DocumentFormat.OpenXml.Drawing.Charts.DataLabelPositionValues} = null optionalposition: 2
lineColor System.String = null optionalposition: 3
lineWidthPoints System.Nullable{System.Double} = null optionalposition: 4
ignoreCase System.Boolean = true optionalposition: 5

SetSeriesDataLabelForPoint 2 overloads

public ExcelChart SetSeriesDataLabelForPoint(Int32 seriesIndex, Int32 pointIndex, Nullable<Boolean> showValue = null, Nullable<Boolean> showCategoryName = null, Nullable<Boolean> showSeriesName = null, Nullable<Boolean> showLegendKey = null, Nullable<Boolean> showPercent = null, Nullable<Boolean> showBubbleSize = null, Nullable<DataLabelPositionValues> position = null, String numberFormat = null, Boolean sourceLinked = false)

OfficeIMO.Excel/ExcelChart.cs:632

Returns: ExcelChart

Configures a single data label point by series index and point index.

Parameters

seriesIndex System.Int32 requiredposition: 0
pointIndex System.Int32 requiredposition: 1
showValue System.Nullable{System.Boolean} = null optionalposition: 2
showCategoryName System.Nullable{System.Boolean} = null optionalposition: 3
showSeriesName System.Nullable{System.Boolean} = null optionalposition: 4
showLegendKey System.Nullable{System.Boolean} = null optionalposition: 5
showPercent System.Nullable{System.Boolean} = null optionalposition: 6
showBubbleSize System.Nullable{System.Boolean} = null optionalposition: 7
position System.Nullable{DocumentFormat.OpenXml.Drawing.Charts.DataLabelPositionValues} = null optionalposition: 8
numberFormat System.String = null optionalposition: 9
sourceLinked System.Boolean = false optionalposition: 10

public ExcelChart SetSeriesDataLabelForPoint(String seriesName, Int32 pointIndex, Nullable<Boolean> showValue = null, Nullable<Boolean> showCategoryName = null, Nullable<Boolean> showSeriesName = null, Nullable<Boolean> showLegendKey = null, Nullable<Boolean> showPercent = null, Nullable<Boolean> showBubbleSize = null, Nullable<DataLabelPositionValues> position = null, String numberFormat = null, Boolean sourceLinked = false, Boolean ignoreCase = true)

OfficeIMO.Excel/ExcelChart.cs:664

Returns: ExcelChart

Configures a single data label point by series name and point index.

Parameters

seriesName System.String requiredposition: 0
pointIndex System.Int32 requiredposition: 1
showValue System.Nullable{System.Boolean} = null optionalposition: 2
showCategoryName System.Nullable{System.Boolean} = null optionalposition: 3
showSeriesName System.Nullable{System.Boolean} = null optionalposition: 4
showLegendKey System.Nullable{System.Boolean} = null optionalposition: 5
showPercent System.Nullable{System.Boolean} = null optionalposition: 6
showBubbleSize System.Nullable{System.Boolean} = null optionalposition: 7
position System.Nullable{DocumentFormat.OpenXml.Drawing.Charts.DataLabelPositionValues} = null optionalposition: 8
numberFormat System.String = null optionalposition: 9
sourceLinked System.Boolean = false optionalposition: 10
ignoreCase System.Boolean = true optionalposition: 11

SetSeriesDataLabelLeaderLines 2 overloads

public ExcelChart SetSeriesDataLabelLeaderLines(Int32 seriesIndex, Boolean showLeaderLines = true, String lineColor = null, Nullable<Double> lineWidthPoints = null)

OfficeIMO.Excel/ExcelChart.cs:455

Returns: ExcelChart

Configures data label leader lines for a series by index.

Parameters

seriesIndex System.Int32 requiredposition: 0
showLeaderLines System.Boolean = true optionalposition: 1
lineColor System.String = null optionalposition: 2
lineWidthPoints System.Nullable{System.Double} = null optionalposition: 3

public ExcelChart SetSeriesDataLabelLeaderLines(String seriesName, Boolean showLeaderLines = true, String lineColor = null, Nullable<Double> lineWidthPoints = null, Boolean ignoreCase = true)

OfficeIMO.Excel/ExcelChart.cs:477

Returns: ExcelChart

Configures data label leader lines for a series by name.

Parameters

seriesName System.String requiredposition: 0
showLeaderLines System.Boolean = true optionalposition: 1
lineColor System.String = null optionalposition: 2
lineWidthPoints System.Nullable{System.Double} = null optionalposition: 3
ignoreCase System.Boolean = true optionalposition: 4

SetSeriesDataLabels 2 overloads

public ExcelChart SetSeriesDataLabels(Int32 seriesIndex, Boolean showValue = true, Boolean showCategoryName = false, Boolean showSeriesName = false, Boolean showLegendKey = false, Boolean showPercent = false, Nullable<DataLabelPositionValues> position = null, String numberFormat = null, Boolean sourceLinked = false)

OfficeIMO.Excel/ExcelChart.cs:928

Returns: ExcelChart

Configures data labels for a single series by index.

Parameters

seriesIndex System.Int32 requiredposition: 0
showValue System.Boolean = true optionalposition: 1
showCategoryName System.Boolean = false optionalposition: 2
showSeriesName System.Boolean = false optionalposition: 3
showLegendKey System.Boolean = false optionalposition: 4
showPercent System.Boolean = false optionalposition: 5
position System.Nullable{DocumentFormat.OpenXml.Drawing.Charts.DataLabelPositionValues} = null optionalposition: 6
numberFormat System.String = null optionalposition: 7
sourceLinked System.Boolean = false optionalposition: 8

public ExcelChart SetSeriesDataLabels(String seriesName, Boolean showValue = true, Boolean showCategoryName = false, Boolean showSeriesName = false, Boolean showLegendKey = false, Boolean showPercent = false, Nullable<DataLabelPositionValues> position = null, String numberFormat = null, Boolean sourceLinked = false, Boolean ignoreCase = true)

OfficeIMO.Excel/ExcelChart.cs:955

Returns: ExcelChart

Configures data labels for a single series by name.

Parameters

seriesName System.String requiredposition: 0
showValue System.Boolean = true optionalposition: 1
showCategoryName System.Boolean = false optionalposition: 2
showSeriesName System.Boolean = false optionalposition: 3
showLegendKey System.Boolean = false optionalposition: 4
showPercent System.Boolean = false optionalposition: 5
position System.Nullable{DocumentFormat.OpenXml.Drawing.Charts.DataLabelPositionValues} = null optionalposition: 6
numberFormat System.String = null optionalposition: 7
sourceLinked System.Boolean = false optionalposition: 8
ignoreCase System.Boolean = true optionalposition: 9

SetSeriesDataLabelSeparator 2 overloads

public ExcelChart SetSeriesDataLabelSeparator(Int32 seriesIndex, String separator) #

OfficeIMO.Excel/ExcelChart.cs:837

Returns: ExcelChart

Sets the separator for data labels in a series by index.

Parameters

seriesIndex System.Int32 requiredposition: 0
separator System.String requiredposition: 1

public ExcelChart SetSeriesDataLabelSeparator(String seriesName, String separator, Boolean ignoreCase = true) #

OfficeIMO.Excel/ExcelChart.cs:857

Returns: ExcelChart

Sets the separator for data labels in a series by name.

Parameters

seriesName System.String requiredposition: 0
separator System.String requiredposition: 1
ignoreCase System.Boolean = true optionalposition: 2

SetSeriesDataLabelSeparatorForPoint 2 overloads

public ExcelChart SetSeriesDataLabelSeparatorForPoint(Int32 seriesIndex, Int32 pointIndex, String separator) #

OfficeIMO.Excel/ExcelChart.cs:877

Returns: ExcelChart

Sets the separator for a specific data label point by series index.

Parameters

seriesIndex System.Int32 requiredposition: 0
pointIndex System.Int32 requiredposition: 1
separator System.String requiredposition: 2

public ExcelChart SetSeriesDataLabelSeparatorForPoint(String seriesName, Int32 pointIndex, String separator, Boolean ignoreCase = true)

OfficeIMO.Excel/ExcelChart.cs:902

Returns: ExcelChart

Sets the separator for a specific data label point by series name.

Parameters

seriesName System.String requiredposition: 0
pointIndex System.Int32 requiredposition: 1
separator System.String requiredposition: 2
ignoreCase System.Boolean = true optionalposition: 3

SetSeriesDataLabelShapeStyle 2 overloads

public ExcelChart SetSeriesDataLabelShapeStyle(Int32 seriesIndex, String fillColor = null, String lineColor = null, Nullable<Double> lineWidthPoints = null, Boolean noFill = false, Boolean noLine = false)

OfficeIMO.Excel/ExcelChart.cs:374

Returns: ExcelChart

Sets data label shape styling for a series by index.

Parameters

seriesIndex System.Int32 requiredposition: 0
fillColor System.String = null optionalposition: 1
lineColor System.String = null optionalposition: 2
lineWidthPoints System.Nullable{System.Double} = null optionalposition: 3
noFill System.Boolean = false optionalposition: 4
noLine System.Boolean = false optionalposition: 5

public ExcelChart SetSeriesDataLabelShapeStyle(String seriesName, String fillColor = null, String lineColor = null, Nullable<Double> lineWidthPoints = null, Boolean noFill = false, Boolean noLine = false, Boolean ignoreCase = true)

OfficeIMO.Excel/ExcelChart.cs:396

Returns: ExcelChart

Sets data label shape styling for a series by name.

Parameters

seriesName System.String requiredposition: 0
fillColor System.String = null optionalposition: 1
lineColor System.String = null optionalposition: 2
lineWidthPoints System.Nullable{System.Double} = null optionalposition: 3
noFill System.Boolean = false optionalposition: 4
noLine System.Boolean = false optionalposition: 5
ignoreCase System.Boolean = true optionalposition: 6

SetSeriesDataLabelShapeStyleForPoint 2 overloads

public ExcelChart SetSeriesDataLabelShapeStyleForPoint(Int32 seriesIndex, Int32 pointIndex, String fillColor = null, String lineColor = null, Nullable<Double> lineWidthPoints = null, Boolean noFill = false, Boolean noLine = false)

OfficeIMO.Excel/ExcelChart.cs:748

Returns: ExcelChart

Sets data label shape styling for a specific point by series index.

Parameters

seriesIndex System.Int32 requiredposition: 0
pointIndex System.Int32 requiredposition: 1
fillColor System.String = null optionalposition: 2
lineColor System.String = null optionalposition: 3
lineWidthPoints System.Nullable{System.Double} = null optionalposition: 4
noFill System.Boolean = false optionalposition: 5
noLine System.Boolean = false optionalposition: 6

public ExcelChart SetSeriesDataLabelShapeStyleForPoint(String seriesName, Int32 pointIndex, String fillColor = null, String lineColor = null, Nullable<Double> lineWidthPoints = null, Boolean noFill = false, Boolean noLine = false, Boolean ignoreCase = true)

OfficeIMO.Excel/ExcelChart.cs:776

Returns: ExcelChart

Sets data label shape styling for a specific point by series name.

Parameters

seriesName System.String requiredposition: 0
pointIndex System.Int32 requiredposition: 1
fillColor System.String = null optionalposition: 2
lineColor System.String = null optionalposition: 3
lineWidthPoints System.Nullable{System.Double} = null optionalposition: 4
noFill System.Boolean = false optionalposition: 5
noLine System.Boolean = false optionalposition: 6
ignoreCase System.Boolean = true optionalposition: 7

SetSeriesDataLabelTemplate 2 overloads

public ExcelChart SetSeriesDataLabelTemplate(Int32 seriesIndex, ExcelChartDataLabelTemplate template) #

OfficeIMO.Excel/ExcelChart.cs:582

Returns: ExcelChart

Applies a reusable data label template to a series by index.

Parameters

seriesIndex System.Int32 requiredposition: 0
template OfficeIMO.Excel.ExcelChartDataLabelTemplate requiredposition: 1

public ExcelChart SetSeriesDataLabelTemplate(String seriesName, ExcelChartDataLabelTemplate template, Boolean ignoreCase = true)

OfficeIMO.Excel/ExcelChart.cs:606

Returns: ExcelChart

Applies a reusable data label template to a series by name.

Parameters

seriesName System.String requiredposition: 0
template OfficeIMO.Excel.ExcelChartDataLabelTemplate requiredposition: 1
ignoreCase System.Boolean = true optionalposition: 2

SetSeriesDataLabelTextStyle 2 overloads

public ExcelChart SetSeriesDataLabelTextStyle(Int32 seriesIndex, Nullable<Double> fontSizePoints = null, Nullable<Boolean> bold = null, Nullable<Boolean> italic = null, String color = null, String fontName = null)

OfficeIMO.Excel/ExcelChart.cs:539

Returns: ExcelChart

Sets data label text style for a series by index.

Parameters

seriesIndex System.Int32 requiredposition: 0
fontSizePoints System.Nullable{System.Double} = null optionalposition: 1
bold System.Nullable{System.Boolean} = null optionalposition: 2
italic System.Nullable{System.Boolean} = null optionalposition: 3
color System.String = null optionalposition: 4
fontName System.String = null optionalposition: 5

public ExcelChart SetSeriesDataLabelTextStyle(String seriesName, Nullable<Double> fontSizePoints = null, Nullable<Boolean> bold = null, Nullable<Boolean> italic = null, String color = null, String fontName = null, Boolean ignoreCase = true)

OfficeIMO.Excel/ExcelChart.cs:561

Returns: ExcelChart

Sets data label text style for a series by name.

Parameters

seriesName System.String requiredposition: 0
fontSizePoints System.Nullable{System.Double} = null optionalposition: 1
bold System.Nullable{System.Boolean} = null optionalposition: 2
italic System.Nullable{System.Boolean} = null optionalposition: 3
color System.String = null optionalposition: 4
fontName System.String = null optionalposition: 5
ignoreCase System.Boolean = true optionalposition: 6

SetSeriesDataLabelTextStyleForPoint 2 overloads

public ExcelChart SetSeriesDataLabelTextStyleForPoint(Int32 seriesIndex, Int32 pointIndex, Nullable<Double> fontSizePoints = null, Nullable<Boolean> bold = null, Nullable<Boolean> italic = null, String color = null, String fontName = null)

OfficeIMO.Excel/ExcelChart.cs:694

Returns: ExcelChart

Sets data label text style for a specific point by series index.

Parameters

seriesIndex System.Int32 requiredposition: 0
pointIndex System.Int32 requiredposition: 1
fontSizePoints System.Nullable{System.Double} = null optionalposition: 2
bold System.Nullable{System.Boolean} = null optionalposition: 3
italic System.Nullable{System.Boolean} = null optionalposition: 4
color System.String = null optionalposition: 5
fontName System.String = null optionalposition: 6

public ExcelChart SetSeriesDataLabelTextStyleForPoint(String seriesName, Int32 pointIndex, Nullable<Double> fontSizePoints = null, Nullable<Boolean> bold = null, Nullable<Boolean> italic = null, String color = null, String fontName = null, Boolean ignoreCase = true)

OfficeIMO.Excel/ExcelChart.cs:721

Returns: ExcelChart

Sets data label text style for a specific point by series name.

Parameters

seriesName System.String requiredposition: 0
pointIndex System.Int32 requiredposition: 1
fontSizePoints System.Nullable{System.Double} = null optionalposition: 2
bold System.Nullable{System.Boolean} = null optionalposition: 3
italic System.Nullable{System.Boolean} = null optionalposition: 4
color System.String = null optionalposition: 5
fontName System.String = null optionalposition: 6
ignoreCase System.Boolean = true optionalposition: 7

SetSeriesFillColor 2 overloads

public ExcelChart SetSeriesFillColor(Int32 seriesIndex, String color) #

OfficeIMO.Excel/ExcelChart.cs:1812

Returns: ExcelChart

Sets the fill color for a chart series by index.

Parameters

seriesIndex System.Int32 requiredposition: 0
color System.String requiredposition: 1

public ExcelChart SetSeriesFillColor(String seriesName, String color, Boolean ignoreCase = true) #

OfficeIMO.Excel/ExcelChart.cs:1836

Returns: ExcelChart

Sets the fill color for a chart series by name.

Parameters

seriesName System.String requiredposition: 0
color System.String requiredposition: 1
ignoreCase System.Boolean = true optionalposition: 2

SetSeriesLineColor 2 overloads

public ExcelChart SetSeriesLineColor(Int32 seriesIndex, String color, Nullable<Double> widthPoints = null) #

OfficeIMO.Excel/ExcelChart.cs:1860

Returns: ExcelChart

Sets the line color for a chart series by index.

Parameters

seriesIndex System.Int32 requiredposition: 0
color System.String requiredposition: 1
widthPoints System.Nullable{System.Double} = null optionalposition: 2

public ExcelChart SetSeriesLineColor(String seriesName, String color, Nullable<Double> widthPoints = null, Boolean ignoreCase = true)

OfficeIMO.Excel/ExcelChart.cs:1884

Returns: ExcelChart

Sets the line color for a chart series by name.

Parameters

seriesName System.String requiredposition: 0
color System.String requiredposition: 1
widthPoints System.Nullable{System.Double} = null optionalposition: 2
ignoreCase System.Boolean = true optionalposition: 3

SetSeriesMarker 2 overloads

public ExcelChart SetSeriesMarker(Int32 seriesIndex, MarkerStyleValues style, Nullable<Int32> size = null, String fillColor = null, String lineColor = null, Nullable<Double> lineWidthPoints = null)

OfficeIMO.Excel/ExcelChart.cs:1908

Returns: ExcelChart

Sets the marker style for a chart series by index.

Parameters

seriesIndex System.Int32 requiredposition: 0
style DocumentFormat.OpenXml.Drawing.Charts.MarkerStyleValues requiredposition: 1
size System.Nullable{System.Int32} = null optionalposition: 2
fillColor System.String = null optionalposition: 3
lineColor System.String = null optionalposition: 4
lineWidthPoints System.Nullable{System.Double} = null optionalposition: 5

public ExcelChart SetSeriesMarker(String seriesName, MarkerStyleValues style, Nullable<Int32> size = null, String fillColor = null, String lineColor = null, Nullable<Double> lineWidthPoints = null, Boolean ignoreCase = true)

OfficeIMO.Excel/ExcelChart.cs:1937

Returns: ExcelChart

Sets the marker style for a chart series by name.

Parameters

seriesName System.String requiredposition: 0
style DocumentFormat.OpenXml.Drawing.Charts.MarkerStyleValues requiredposition: 1
size System.Nullable{System.Int32} = null optionalposition: 2
fillColor System.String = null optionalposition: 3
lineColor System.String = null optionalposition: 4
lineWidthPoints System.Nullable{System.Double} = null optionalposition: 5
ignoreCase System.Boolean = true optionalposition: 6

SetSeriesTrendline 2 overloads

public ExcelChart SetSeriesTrendline(Int32 seriesIndex, TrendlineValues type, Nullable<Int32> order = null, Nullable<Int32> period = null, Nullable<Double> forward = null, Nullable<Double> backward = null, Nullable<Double> intercept = null, Boolean displayEquation = false, Boolean displayRSquared = false, String lineColor = null, Nullable<Double> lineWidthPoints = null)

OfficeIMO.Excel/ExcelChart.cs:2014

Returns: ExcelChart

Adds or replaces a trendline for a chart series by index.

Parameters

seriesIndex System.Int32 requiredposition: 0
type DocumentFormat.OpenXml.Drawing.Charts.TrendlineValues requiredposition: 1
order System.Nullable{System.Int32} = null optionalposition: 2
period System.Nullable{System.Int32} = null optionalposition: 3
forward System.Nullable{System.Double} = null optionalposition: 4
backward System.Nullable{System.Double} = null optionalposition: 5
intercept System.Nullable{System.Double} = null optionalposition: 6
displayEquation System.Boolean = false optionalposition: 7
displayRSquared System.Boolean = false optionalposition: 8
lineColor System.String = null optionalposition: 9
lineWidthPoints System.Nullable{System.Double} = null optionalposition: 10

public ExcelChart SetSeriesTrendline(String seriesName, TrendlineValues type, Nullable<Int32> order = null, Nullable<Int32> period = null, Nullable<Double> forward = null, Nullable<Double> backward = null, Nullable<Double> intercept = null, Boolean displayEquation = false, Boolean displayRSquared = false, String lineColor = null, Nullable<Double> lineWidthPoints = null, Boolean ignoreCase = true)

OfficeIMO.Excel/ExcelChart.cs:2038

Returns: ExcelChart

Adds or replaces a trendline for a chart series by name.

Parameters

seriesName System.String requiredposition: 0
type DocumentFormat.OpenXml.Drawing.Charts.TrendlineValues requiredposition: 1
order System.Nullable{System.Int32} = null optionalposition: 2
period System.Nullable{System.Int32} = null optionalposition: 3
forward System.Nullable{System.Double} = null optionalposition: 4
backward System.Nullable{System.Double} = null optionalposition: 5
intercept System.Nullable{System.Double} = null optionalposition: 6
displayEquation System.Boolean = false optionalposition: 7
displayRSquared System.Boolean = false optionalposition: 8
lineColor System.String = null optionalposition: 9
lineWidthPoints System.Nullable{System.Double} = null optionalposition: 10
ignoreCase System.Boolean = true optionalposition: 11

public ExcelChart SetTitle(String title) #

OfficeIMO.Excel/ExcelChart.cs:90

Returns: ExcelChart

Sets the chart title text.

Parameters

title System.String requiredposition: 0

public ExcelChart SetTitleTextStyle(Nullable<Double> fontSizePoints = null, Nullable<Boolean> bold = null, Nullable<Boolean> italic = null, String color = null, String fontName = null)

OfficeIMO.Excel/ExcelChart.cs:119

Returns: ExcelChart

Sets the chart title text style.

Parameters

fontSizePoints System.Nullable{System.Double} = null optionalposition: 0
bold System.Nullable{System.Boolean} = null optionalposition: 1
italic System.Nullable{System.Boolean} = null optionalposition: 2
color System.String = null optionalposition: 3
fontName System.String = null optionalposition: 4

public ExcelChart SetValueAxisCrossBetween(CrossBetweenValues between, ExcelChartAxisGroup axisGroup = Primary) #

OfficeIMO.Excel/ExcelChart.cs:1094

Returns: ExcelChart

Sets how the value axis crosses between categories.

Parameters

between DocumentFormat.OpenXml.Drawing.Charts.CrossBetweenValues requiredposition: 0
axisGroup OfficeIMO.Excel.ExcelChartAxisGroup = Primary optionalposition: 1

public ExcelChart SetValueAxisCrossing(CrossesValues crosses, Nullable<Double> crossesAt = null, ExcelChartAxisGroup axisGroup = Primary)

OfficeIMO.Excel/ExcelChart.cs:1140

Returns: ExcelChart

Sets where the value axis crosses the category axis.

Parameters

crosses DocumentFormat.OpenXml.Drawing.Charts.CrossesValues requiredposition: 0
crossesAt System.Nullable{System.Double} = null optionalposition: 1
axisGroup OfficeIMO.Excel.ExcelChartAxisGroup = Primary optionalposition: 2

SetValueAxisDisplayUnits 4 overloads

public ExcelChart SetValueAxisDisplayUnits(Double customUnit, Boolean showLabel = true, ExcelChartAxisGroup axisGroup = Primary)

OfficeIMO.Excel/ExcelChart.cs:1278

Returns: ExcelChart

Sets display units for the value axis.

Parameters

arg1 DocumentFormat.OpenXml.Drawing.Charts.BuiltInUnitValues requiredposition: 0
arg2 System.Boolean = true optionalposition: 1
arg3 OfficeIMO.Excel.ExcelChartAxisGroup = Primary optionalposition: 2

public ExcelChart SetValueAxisDisplayUnits(Double customUnit, String labelText, Boolean showLabel = true, ExcelChartAxisGroup axisGroup = Primary)

OfficeIMO.Excel/ExcelChart.cs:1311

Returns: ExcelChart

Sets display units for the value axis with custom label text.

Parameters

arg1 DocumentFormat.OpenXml.Drawing.Charts.BuiltInUnitValues requiredposition: 0
arg2 System.String requiredposition: 1
arg3 System.Boolean = true optionalposition: 2
arg4 OfficeIMO.Excel.ExcelChartAxisGroup = Primary optionalposition: 3

SetValueAxisDisplayUnits(System.Double customUnit, System.Boolean showLabel, OfficeIMO.Excel.ExcelChartAxisGroup axisGroup)

Sets custom display units for the value axis.

Parameters

customUnit System.Double required
showLabel System.Boolean required
axisGroup OfficeIMO.Excel.ExcelChartAxisGroup required

SetValueAxisDisplayUnits(System.Double customUnit, System.String labelText, System.Boolean showLabel, OfficeIMO.Excel.ExcelChartAxisGroup axisGroup)

Sets custom display units for the value axis with custom label text.

Parameters

customUnit System.Double required
labelText System.String required
showLabel System.Boolean required
axisGroup OfficeIMO.Excel.ExcelChartAxisGroup required

public ExcelChart SetValueAxisGridlines(Boolean showMajor = true, Boolean showMinor = false, String lineColor = null, Nullable<Double> lineWidthPoints = null, ExcelChartAxisGroup axisGroup = Primary)

OfficeIMO.Excel/ExcelChart.cs:1036

Returns: ExcelChart

Sets value axis gridlines visibility and optional styling.

Parameters

showMajor System.Boolean = true optionalposition: 0
showMinor System.Boolean = false optionalposition: 1
lineColor System.String = null optionalposition: 2
lineWidthPoints System.Nullable{System.Double} = null optionalposition: 3
axisGroup OfficeIMO.Excel.ExcelChartAxisGroup = Primary optionalposition: 4

public ExcelChart SetValueAxisLabelRotation(Double rotationDegrees, ExcelChartAxisGroup axisGroup = Primary) #

OfficeIMO.Excel/ExcelChart.cs:1070

Returns: ExcelChart

Sets the value axis label rotation in degrees (-90..90).

Parameters

rotationDegrees System.Double requiredposition: 0
axisGroup OfficeIMO.Excel.ExcelChartAxisGroup = Primary optionalposition: 1

public ExcelChart SetValueAxisLabelTextStyle(Nullable<Double> fontSizePoints = null, Nullable<Boolean> bold = null, Nullable<Boolean> italic = null, String color = null, String fontName = null, ExcelChartAxisGroup axisGroup = Primary)

OfficeIMO.Excel/ExcelChart.cs:1054

Returns: ExcelChart

Sets the value axis label text style.

Parameters

fontSizePoints System.Nullable{System.Double} = null optionalposition: 0
bold System.Nullable{System.Boolean} = null optionalposition: 1
italic System.Nullable{System.Boolean} = null optionalposition: 2
color System.String = null optionalposition: 3
fontName System.String = null optionalposition: 4
axisGroup OfficeIMO.Excel.ExcelChartAxisGroup = Primary optionalposition: 5

SetValueAxisNumberFormat 2 overloads

public ExcelChart SetValueAxisNumberFormat(String formatCode, Boolean sourceLinked = false) #

OfficeIMO.Excel/ExcelChart.cs:1452

Returns: ExcelChart

Sets the value axis number format.

Parameters

formatCode System.String requiredposition: 0
sourceLinked System.Boolean = false optionalposition: 1

public ExcelChart SetValueAxisNumberFormat(String formatCode, Boolean sourceLinked, ExcelChartAxisGroup axisGroup) #

OfficeIMO.Excel/ExcelChart.cs:1459

Returns: ExcelChart

Sets the value axis number format for the selected axis group.

Parameters

formatCode System.String requiredposition: 0
sourceLinked System.Boolean requiredposition: 1
axisGroup OfficeIMO.Excel.ExcelChartAxisGroup requiredposition: 2

public ExcelChart SetValueAxisScale(Nullable<Double> minimum = null, Nullable<Double> maximum = null, Nullable<Double> majorUnit = null, Nullable<Double> minorUnit = null, Nullable<Double> logBase = null, Nullable<Boolean> reverseOrder = null, ExcelChartAxisGroup axisGroup = Primary, Nullable<Boolean> logScale = null)

OfficeIMO.Excel/ExcelChart.cs:1468

Returns: ExcelChart

Sets value axis scale parameters for the selected axis group.

Parameters

minimum System.Nullable{System.Double} = null optionalposition: 0
maximum System.Nullable{System.Double} = null optionalposition: 1
majorUnit System.Nullable{System.Double} = null optionalposition: 2
minorUnit System.Nullable{System.Double} = null optionalposition: 3
logBase System.Nullable{System.Double} = null optionalposition: 4
reverseOrder System.Nullable{System.Boolean} = null optionalposition: 5
axisGroup OfficeIMO.Excel.ExcelChartAxisGroup = Primary optionalposition: 6
logScale System.Nullable{System.Boolean} = null optionalposition: 7

public ExcelChart SetValueAxisTickLabelPosition(TickLabelPositionValues position, ExcelChartAxisGroup axisGroup = Primary)

OfficeIMO.Excel/ExcelChart.cs:1086

Returns: ExcelChart

Sets the value axis tick label position.

Parameters

position DocumentFormat.OpenXml.Drawing.Charts.TickLabelPositionValues requiredposition: 0
axisGroup OfficeIMO.Excel.ExcelChartAxisGroup = Primary optionalposition: 1

SetValueAxisTitle 2 overloads

public ExcelChart SetValueAxisTitle(String title) #

OfficeIMO.Excel/ExcelChart.cs:993

Returns: ExcelChart

Sets the value axis title.

Parameters

title System.String requiredposition: 0

public ExcelChart SetValueAxisTitle(String title, ExcelChartAxisGroup axisGroup) #

OfficeIMO.Excel/ExcelChart.cs:1000

Returns: ExcelChart

Sets the value axis title for the selected axis group.

Parameters

title System.String requiredposition: 0
axisGroup OfficeIMO.Excel.ExcelChartAxisGroup requiredposition: 1

public ExcelChart SetValueAxisTitleTextStyle(Nullable<Double> fontSizePoints = null, Nullable<Boolean> bold = null, Nullable<Boolean> italic = null, String color = null, String fontName = null, ExcelChartAxisGroup axisGroup = Primary)

OfficeIMO.Excel/ExcelChart.cs:1018

Returns: ExcelChart

Sets the value axis title text style.

Parameters

fontSizePoints System.Nullable{System.Double} = null optionalposition: 0
bold System.Nullable{System.Boolean} = null optionalposition: 1
italic System.Nullable{System.Boolean} = null optionalposition: 2
color System.String = null optionalposition: 3
fontName System.String = null optionalposition: 4
axisGroup OfficeIMO.Excel.ExcelChartAxisGroup = Primary optionalposition: 5

public ExcelChart UpdateData<T>(IEnumerable<T> items, Func<T, String> categorySelector, params ExcelChartSeriesDefinition<T>[] seriesDefinitions)

OfficeIMO.Excel/ExcelChart.cs:82

Returns: ExcelChart

Updates the chart data (series and categories).

Type Parameters

T

Parameters

data OfficeIMO.Excel.ExcelChartData requiredposition: 0
dataRange OfficeIMO.Excel.ExcelChartDataRange = null requiredposition: 1
writeToSheet System.Boolean = true requiredposition: 2

UpdateData``1(System.Collections.Generic.IEnumerable{``0} items, System.Func{``0,System.String} categorySelector, OfficeIMO.Excel.ExcelChartSeriesDefinition{``0}[] seriesDefinitions)

Updates the chart data using selectors.

Parameters

items System.Collections.Generic.IEnumerable{``0} required
categorySelector System.Func{``0,System.String} required
seriesDefinitions OfficeIMO.Excel.ExcelChartSeriesDefinition{``0}[] required

Inherited Methods

Properties

public String Name { get; set; } #

OfficeIMO.Excel/ExcelChart.cs:32

Gets or sets the chart name (non-visual drawing name).

public ExcelChartDataRange DataRange { get; } #

OfficeIMO.Excel/ExcelChart.cs:44

Gets the chart data range when it is known.