Interface IExcelChart
Namespace: OfficeOpenXml.Drawing.Chart
Assembly: EPPlus.dll
Syntax
public interface IExcelChartProperties
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()