Interface IExcelChart

Namespace: OfficeOpenXml.Drawing.Chart

Assembly: EPPlus.dll

Syntax

public interface IExcelChart

Properties

Axis

An array containg all axis of all Charttypes

Declaration

ExcelChartAxis[] Axis { get; }

Property Value

Type	Description
ExcelChartAxis[]

Border

Border

Declaration

ExcelDrawingBorder Border { get; }

Property Value

Type	Description
ExcelDrawingBorder

ChartType

Type of chart

Declaration

eChartType ChartType { get; }

Property Value

Type	Description
eChartType

ChartXml

The chart xml document

Declaration

XmlDocument ChartXml { get; }

Property Value

Type	Description
System.Xml.XmlDocument

DisplayBlanksAs

Specifies the possible ways to display blanks

Declaration

eDisplayBlanksAs DisplayBlanksAs { get; set; }

Property Value

Type	Description
eDisplayBlanksAs

Font

Access to font properties

Declaration

ExcelTextFont Font { get; }

Property Value

Type	Description
ExcelTextFont

Grouping

Specifies the kind of grouping for a column, line, or area chart

Declaration

eGrouping Grouping { get; }

Property Value

Type	Description
eGrouping

HasLegend

If the chart has a legend

Declaration

bool HasLegend { get; }

Property Value

Type	Description
System.Boolean

HasTitle

True if the chart has a title

Declaration

bool HasTitle { get; }

Property Value

Type	Description
System.Boolean

Legend

Legend

Declaration

ExcelChartLegend Legend { get; }

Property Value

Type	Description
ExcelChartLegend

PivotTableSource

If the chart is a pivochart this is the pivotable used as source.

Declaration

ExcelPivotTable PivotTableSource { get; }

Property Value

Type	Description
ExcelPivotTable

PlotArea

Plotarea

Declaration

ExcelChartPlotArea PlotArea { get; }

Property Value

Type	Description
ExcelChartPlotArea

RoundedCorners

Border rounded corners

Declaration

bool RoundedCorners { get; set; }

Property Value

Type	Description
System.Boolean

Series

Chart series

Declaration

ExcelChartSeries<ExcelChartSerie> Series { get; }

Property Value

Type	Description
ExcelChartSeries<ExcelChartSerie>

ShowDataLabelsOverMaximum

Specifies data labels over the maximum of the chart shall be shown

Declaration

bool ShowDataLabelsOverMaximum { get; set; }

Property Value

Type	Description
System.Boolean

ShowHiddenData

Show data in hidden rows and columns

Declaration

bool ShowHiddenData { get; set; }

Property Value

Type	Description
System.Boolean

Style

The build-in chart styles.

Declaration

eChartStyle Style { get; }

Property Value

Type	Description
eChartStyle

StyleManager

Manage style settings for the chart

Declaration

ExcelChartStyleManager StyleManager { get; }

Property Value

Type	Description
ExcelChartStyleManager

TextBody

Access to text body properties

Declaration

ExcelTextBody TextBody { get; }

Property Value

Type	Description
ExcelTextBody

ThreeD

3D properties

Declaration

ExcelDrawing3D ThreeD { get; }

Property Value

Type	Description
ExcelDrawing3D

Title

Titel of the chart

Declaration

ExcelChartTitle Title { get; }

Property Value

Type	Description
ExcelChartTitle

UseSecondaryAxis

If true the charttype will use the secondary axis. The chart must contain a least one other charttype that uses the primary axis.

Declaration

bool UseSecondaryAxis { get; }

Property Value

Type	Description
System.Boolean

VaryColors

If the chart has only one serie this varies the colors for each point.

Declaration

bool VaryColors { get; }

Property Value

Type	Description
System.Boolean

View3D

3D-settings

Declaration

ExcelView3D View3D { get; }

Property Value

Type	Description
ExcelView3D

WorkSheet

Reference to the worksheet

Declaration

ExcelWorksheet WorkSheet { get; }

Property Value

Type	Description
ExcelWorksheet

XAxis

The X Axis

Declaration

ExcelChartAxis XAxis { get; }

Property Value

Type	Description
ExcelChartAxis

YAxis

The Y Axis

Declaration

ExcelChartAxis YAxis { get; }

Property Value

Type	Description
ExcelChartAxis

Methods

DeleteTitle()

Remove the title from the chart

Declaration

void DeleteTitle()