Table of Contents

Interface IChart

Namespace
Spire.Xls.Core
Assembly
Spire.XLS.dll

Represents a chart sheet in the workbook.

public interface IChart

Properties

AutoScaling

True if Microsoft Excel scales a 3-D chart so that it's closer in size to the equivalent 2-D chart. The following code illustrates how to set auto scaling for charts:

//Create worksheet
Workbook workbook = new Workbook();
Worksheet worksheet = workbook.Worksheets[0];

//Add data
worksheet.Range["A1"].Text = "Jan";
      worksheet.Range["B1"].Text = "Feb";
      worksheet.Range["C1"].Text = "Mar";
      worksheet.Range["A2"].Text = "10";
      worksheet.Range["B2"].Text = "20";
      worksheet.Range["C2"].Text = "30";

//Create chart and range
Chart chart = worksheet.Charts.Add();
chart.DataRange = worksheet.Range["A1:C2"];

//Set auto scaling
chart.ChartType = ExcelChartType.Column3DClustered;
chart.HeightPercent = 50;
chart.AutoScaling = true;

//Save to file
workbook.SaveToFile("Chart.xlsx");
bool AutoScaling { get; set; }

Property Value

bool

ChartArea

Returns an object that represents the complete chart area for the chart. Read-only. The following code illustrates how to access IChartFrameFormat using ChartArea property and set foreground color for the ChartArea:

//Create worksheet
Workbook workbook = new Workbook();
Worksheet worksheet = workbook.Worksheets[0];

//Add data
worksheet.Range["A1"].Text = "Jan";
      worksheet.Range["B1"].Text = "Feb";
      worksheet.Range["C1"].Text = "Mar";
      worksheet.Range["A2"].Text = "10";
      worksheet.Range["B2"].Text = "20";
      worksheet.Range["C2"].Text = "30";

//Create chart and range
Chart chart = worksheet.Charts.Add();
chart.DataRange = worksheet.Range["A1:C2"];

//Set chart frame format
IChartFrameFormat frameFormat = chart.ChartArea;
//Set color
frameFormat.Fill.ForeColor = System.Drawing.Color.Red;

//Save to file
workbook.SaveToFile("Chart.xlsx");
IChartFrameFormat ChartArea { get; }

Property Value

IChartFrameFormat

ChartType

Type of the chart. The following code illustrates how to set ExcelChartType.PyramidBarStacked to ChartType property:

//Create worksheet
Workbook workbook = new Workbook();
Worksheet worksheet = workbook.Worksheets[0];

//Add data
worksheet.Range["A1"].Text = "Jan";
      worksheet.Range["B1"].Text = "Feb";
      worksheet.Range["C1"].Text = "Mar";
      worksheet.Range["A2"].Text = "10";
      worksheet.Range["B2"].Text = "20";
      worksheet.Range["C2"].Text = "30";

//Create chart and set chart type
IChart chart = workbook.Charts.Add();
chart.DataRange = worksheet.Range["A1:C2"];
chart.ChartType = ExcelChartType.PyramidBarStacked;

//Save to file
workbook.SaveToFile("Chart.xlsx");
ExcelChartType ChartType { get; set; }

Property Value

ExcelChartType

DataRange

DataRange for the chart series. The following code illustrates how to set the data range for the chart:

//Create worksheet
Workbook workbook = new Workbook();
Worksheet worksheet = workbook.Worksheets[0];

//Add data
worksheet.Range["A1"].Text = "Jan";
      worksheet.Range["B1"].Text = "Feb";
      worksheet.Range["C1"].Text = "Mar";
      worksheet.Range["A2"].Text = "10";
      worksheet.Range["B2"].Text = "20";
      worksheet.Range["C2"].Text = "30";

//Create chart and set range
IChart chart = workbook.Charts.Add();
chart.DataRange = worksheet.Range["A1:C2"];

//Save to file
workbook.SaveToFile("Chart.xlsx");
IXLSRange DataRange { get; set; }

Property Value

IXLSRange

DataTable

Represents charts dataTable object. The following code illustrates how to set HasDataTable to "true" to enable data table and set IChartDataTable.HasBorders to "false" to hide the borders of data table:

//Create worksheet
Workbook workbook = new Workbook();
Worksheet worksheet = workbook.Worksheets[0];

//Add data
worksheet.Range["A1"].Text = "Jan";
      worksheet.Range["B1"].Text = "Feb";
      worksheet.Range["C1"].Text = "Mar";
      worksheet.Range["A2"].Text = "10";
      worksheet.Range["B2"].Text = "20";
      worksheet.Range["C2"].Text = "30";

//Create chart and range
Chart chart = worksheet.Charts.Add();
chart.DataRange = worksheet.Range["A1:C2"];

//Set Chart data table
chart.HasDataTable = true;
IChartDataTable dataTable = chart.DataTable;
//Set border
dataTable.HasBorders = false;

//Save to file
workbook.SaveToFile("Chart.xlsx");
IChartDataTable DataTable { get; }

Property Value

IChartDataTable

DepthPercent

Returns or sets the depth of a 3-D chart as a percentage of the chart width (between 20 and 2000 percent). The following code illustrates how to set DepthPercent to a Column 3D chart:

//Create worksheet
Workbook workbook = new Workbook();
Worksheet worksheet = workbook.Worksheets[0];

//Add data
worksheet.Range["A1"].Text = "Jan";
      worksheet.Range["B1"].Text = "Feb";
      worksheet.Range["C1"].Text = "Mar";
      worksheet.Range["A2"].Text = "10";
      worksheet.Range["B2"].Text = "20";
      worksheet.Range["C2"].Text = "30";

//Create chart and range
Chart chart = worksheet.Charts.Add();
chart.DataRange = worksheet.Range["A1:C2"];

//Set Chart depth percent
chart.ChartType = ExcelChartType.Column3DClustered;
chart.DepthPercent = 500;

//Save to file
workbook.SaveToFile("Chart.xlsx");
int DepthPercent { get; set; }

Property Value

int

DisplayAxisFieldButtons

Gets or sets a value indicating whether [show axis field buttons].

bool DisplayAxisFieldButtons { get; set; }

Property Value

bool

true if [show axis field buttons]; otherwise, false.

DisplayBlanksAs

Represents the way that blank cells are plotted on a chart.

ChartPlotEmptyType DisplayBlanksAs { get; set; }

Property Value

ChartPlotEmptyType

DisplayEntireFieldButtons

Gets or sets a value indicating whether [show all field buttons].

bool DisplayEntireFieldButtons { get; set; }

Property Value

bool

true if [show all field buttons]; otherwise, false.

DisplayLegendFieldButtons

Gets or sets a value indicating whether [show legend field buttons].

bool DisplayLegendFieldButtons { get; set; }

Property Value

bool

true if [show legend field buttons]; otherwise, false.

DisplayValueFieldButtons

Gets or sets a value indicating whether [show value field buttons].

bool DisplayValueFieldButtons { get; set; }

Property Value

bool

true if [show value field buttons]; otherwise, false.

Elevation

Returns or sets the elevation of the 3-D chart view, in degrees (?0 to +90 degrees). The following code illustrates how to set Rotation for 3-D charts:

//Create worksheet
Workbook workbook = new Workbook();
Worksheet worksheet = workbook.Worksheets[0];

//Add data
worksheet.Range["A1"].Text = "Jan";
      worksheet.Range["B1"].Text = "Feb";
      worksheet.Range["C1"].Text = "Mar";
      worksheet.Range["A2"].Text = "10";
      worksheet.Range["B2"].Text = "20";
      worksheet.Range["C2"].Text = "30";

//Create chart and range
Chart chart = worksheet.Charts.Add();
chart.DataRange = worksheet.Range["A1:C2"];

//Set Chart elevation
chart.ChartType = ExcelChartType.Column3DClustered;
chart.Elevation = 50;

//Save to file
workbook.SaveToFile("Chart.xlsx");
int Elevation { get; set; }

Property Value

int

Floor

Represents chart floor. Read-only. The following code illustrates how to access IChartWallOrFloor using Floor property and set foreground color for the chart's Floor:

//Create worksheet
Workbook workbook = new Workbook();
workbook.LoadFromFile("Sample.xlsx");
Worksheet worksheet = workbook.Worksheets[0];

//Get chart
Chart chart = worksheet.Charts[0];

//Set chart wall
IChartWallOrFloor floor = chart.Floor;
//Set color
floor.Fill.FillType = ShapeFillType.SolidColor;
floor.Fill.ForeColor = System.Drawing.Color.Red;

//Save to file
workbook.SaveToFile("Chart.xlsx");
IChartWallOrFloor Floor { get; }

Property Value

IChartWallOrFloor

GapDepth

Returns or sets the distance between the data series in a 3-D chart, as a percentage of the marker width.( 0 - 500 ) The following code illustrates how to set GapDepth to a Column 3D chart:

//Create worksheet
Workbook workbook = new Workbook();
Worksheet worksheet = workbook.Worksheets[0];

//Add data
worksheet.Range["A1"].Text = "Jan";
      worksheet.Range["B1"].Text = "Feb";
      worksheet.Range["C1"].Text = "Mar";
      worksheet.Range["A2"].Text = "10";
      worksheet.Range["B2"].Text = "20";
      worksheet.Range["C2"].Text = "30";

//Create chart and range
Chart chart = worksheet.Charts.Add();
chart.DataRange = worksheet.Range["A1:C2"];

//Set gap depth
chart.ChartType = ExcelChartType.Column3DClustered;
chart.GapDepth = 450;

//Save to file
workbook.SaveToFile("Chart.xlsx");
int GapDepth { get; set; }

Property Value

int

HasDataTable

True if the chart has a data table. The following code illustrates how data table can be set for charts:

//Create worksheet
Workbook workbook = new Workbook();
Worksheet worksheet = workbook.Worksheets[0];

//Add data
worksheet.Range["A1"].Text = "Jan";
      worksheet.Range["B1"].Text = "Feb";
      worksheet.Range["C1"].Text = "Mar";
      worksheet.Range["A2"].Text = "10";
      worksheet.Range["B2"].Text = "20";
      worksheet.Range["C2"].Text = "30";

//Create chart and range
Chart chart = worksheet.Charts.Add();
chart.DataRange = worksheet.Range["A1:C2"];

//Set Chart data table
chart.HasDataTable = true;

//Save to file
workbook.SaveToFile("Chart.xlsx");
bool HasDataTable { get; set; }

Property Value

bool

HasLegend

True if the chart has a legend object. The following code illustrates how to set HasLegend property:

//Create worksheet
Workbook workbook = new Workbook();
Worksheet worksheet = workbook.Worksheets[0];

//Add data
worksheet.Range["A1"].Text = "Jan";
      worksheet.Range["B1"].Text = "Feb";
      worksheet.Range["C1"].Text = "Mar";
      worksheet.Range["A2"].Text = "10";
      worksheet.Range["B2"].Text = "20";
      worksheet.Range["C2"].Text = "30";

//Create chart and range
Chart chart = worksheet.Charts.Add();
chart.DataRange = worksheet.Range["A1:C2"];

//Set hasLegend
chart.HasLegend = false;

//Save to file
workbook.SaveToFile("Chart.xlsx");
bool HasLegend { get; set; }

Property Value

bool

HasPlotArea

Indicates whether chart has plot area.

bool HasPlotArea { get; set; }

Property Value

bool

Height

Height of the chart in points (1/72 inch).

double Height { get; set; }

Property Value

double

HeightPercent

Returns or sets the height of a 3-D chart as a percentage of the chart width (between 5 and 500 percent). The following code illustrates how to set HeightPercent to a Column 3D chart:

//Create worksheet
 Workbook workbook = new Workbook();
 Worksheet worksheet = workbook.Worksheets[0];

 //Add data
 worksheet.Range["A1"].Text = "Jan";
       worksheet.Range["B1"].Text = "Feb";
       worksheet.Range["C1"].Text = "Mar";
       worksheet.Range["A2"].Text = "10";
       worksheet.Range["B2"].Text = "20";
       worksheet.Range["C2"].Text = "30";

 //Create chart and range
 Chart chart = worksheet.Charts.Add();
 chart.DataRange = worksheet.Range["A1:C2"];

 //Set Chart height percent
 chart.ChartType = ExcelChartType.Column3DClustered;
 chart.AutoScaling = false;
 chart.HeightPercent = 50;

 //Save to file
 workbook.SaveToFile("Chart.xlsx");
int HeightPercent { get; set; }

Property Value

int

Legend

Represents chart legend. The following code illustrates how to access IChartLegend using IChart.Legend property and set IChartLegend.Position to LegendPositionType.Left:

//Create worksheet
Workbook workbook = new Workbook();
Worksheet worksheet = workbook.Worksheets[0];

//Add data
worksheet.Range["A1"].Text = "Jan";
      worksheet.Range["B1"].Text = "Feb";
      worksheet.Range["C1"].Text = "Mar";
      worksheet.Range["A2"].Text = "10";
      worksheet.Range["B2"].Text = "20";
      worksheet.Range["C2"].Text = "30";

//Create chart and range
Chart chart = worksheet.Charts.Add();
chart.DataRange = worksheet.Range["A1:C2"];

//Set chart legend and legend position
IChartLegend legend = chart.Legend;
legend.Position = LegendPositionType.Left;

//Save to file
workbook.SaveToFile("Chart.xlsx");
IChartLegend Legend { get; }

Property Value

IChartLegend

Name

Name of the chart's worksheet.

string Name { get; set; }

Property Value

string

PageSetup

Page setup for the chart. Read-only. The following code illustrates how to set paper size:

//Create worksheet
Workbook workbook = new Workbook();
Worksheet worksheet = workbook.Worksheets[0];

//Add data
worksheet.Range["A1"].Text = "Jan";
      worksheet.Range["B1"].Text = "Feb";
      worksheet.Range["C1"].Text = "Mar";
      worksheet.Range["A2"].Text = "10";
      worksheet.Range["B2"].Text = "20";
      worksheet.Range["C2"].Text = "30";

//Create chart and range
IChart chart = workbook.Charts.Add();
chart.DataRange = worksheet.Range["A1:C2"];

//Set chart page setup and paper size
IChartPageSetup pageSetup = chart.PageSetup;
pageSetup.PaperSize = PaperSizeType.A3TransversePaper;

//Save to file
workbook.SaveToFile("Chart.xlsx");
IChartPageSetup PageSetup { get; }

Property Value

IChartPageSetup

Perspective

Returns or sets the perspective for the 3-D chart view (0 to 100). The following code illustrates how to set Perspective for the charts:

//Create worksheet
Workbook workbook = new Workbook();
Worksheet worksheet = workbook.Worksheets[0];

//Add data
worksheet.Range["A1"].Text = "Jan";
      worksheet.Range["B1"].Text = "Feb";
      worksheet.Range["C1"].Text = "Mar";
      worksheet.Range["A2"].Text = "10";
      worksheet.Range["B2"].Text = "20";
      worksheet.Range["C2"].Text = "30";

//Create chart and range
Chart chart = worksheet.Charts.Add();
chart.DataRange = worksheet.Range["A1:C2"];

//Set Chart perspective
chart.ChartType = ExcelChartType.Column3DClustered;
chart.Perspective = 70;

//Save to file
workbook.SaveToFile("Chart.xlsx");
int Perspective { get; set; }

Property Value

int

PivotChartType

Gets or sets the type of the pivot chart.

ExcelChartType PivotChartType { get; set; }

Property Value

ExcelChartType

The type of the pivot chart.

PivotTable

Gets or sets the pivot source.

PivotTable PivotTable { get; set; }

Property Value

PivotTable

The pivot source.

PlotArea

Returns plot area frame format. Read-only. The following code illustrates how to access IChartFrameFormat using PlotArea property and set foreground color for the chart's PlotArea:

//Create worksheet
Workbook workbook = new Workbook();
Worksheet worksheet = workbook.Worksheets[0];

//Add data
worksheet.Range["A1"].Text = "Jan";
      worksheet.Range["B1"].Text = "Feb";
      worksheet.Range["C1"].Text = "Mar";
      worksheet.Range["A2"].Text = "10";
      worksheet.Range["B2"].Text = "20";
      worksheet.Range["C2"].Text = "30";

//Create chart and range
Chart chart = worksheet.Charts.Add();
chart.DataRange = worksheet.Range["A1:C2"];

//Set chart frame format
IChartFrameFormat frameFormat = chart.PlotArea;
//Set color
frameFormat.Fill.ForeColor = System.Drawing.Color.Red;

//Save to file
workbook.SaveToFile("Chart.xlsx");
IChartFrameFormat PlotArea { get; }

Property Value

IChartFrameFormat

PlotVisibleOnly

True if only visible cells are plotted. False if both visible and hidden cells are plotted. The following code illustrates how to set PlotVisibleOnly to "true" so that chart plots all the cells within the chart's DataRange:

//Create worksheet
Workbook workbook = new Workbook();
Worksheet worksheet = workbook.Worksheets[0];

//Add data
worksheet.Range["A1"].Text = "Jan";
      worksheet.Range["B1"].Text = "Feb";
      worksheet.Range["C1"].Text = "Mar";
      worksheet.Range["A2"].Text = "10";
      worksheet.Range["B2"].Text = "20";
      worksheet.Range["C2"].Text = "30";

//Hide column and create chart
worksheet.Columns[2].ColumnWidth = 0;
Chart chart = worksheet.Charts.Add();
chart.DataRange = worksheet.Range["A1:C2"];

//Set Plot visible only
chart.PlotVisibleOnly = true;

//Save to file
workbook.SaveToFile("Chart.xlsx");
bool PlotVisibleOnly { get; set; }

Property Value

bool

PrimaryCategoryAxis

Primary category axis. Read-only. The following code illustrates how to set the visibility of PrimaryCategoryAxis:

//Create worksheet
Workbook workbook = new Workbook();
Worksheet worksheet = workbook.Worksheets[0];

//Add data
worksheet.Range["A1"].Text = "Jan";
      worksheet.Range["B1"].Text = "Feb";
      worksheet.Range["C1"].Text = "Mar";
      worksheet.Range["A2"].Text = "10";
      worksheet.Range["B2"].Text = "20";
      worksheet.Range["C2"].Text = "30";

//Create chart and range
IChart chart = workbook.Charts.Add();
chart.DataRange = worksheet.Range["A1:C2"];

//Chart category axis
IChartCategoryAxis categoryAxis = chart.PrimaryCategoryAxis;
//Set visibility
categoryAxis.Visible = false;

//Save to file
workbook.SaveToFile("Chart.xlsx");
IChartCategoryAxis PrimaryCategoryAxis { get; }

Property Value

IChartCategoryAxis

PrimarySerieAxis

Primary serie axis. Read-only. The following code illustrates how to set the visibility of PrimarySerieAxis:

//Create worksheet
Workbook workbook = new Workbook();
Worksheet worksheet = workbook.Worksheets[0];

//Add data
worksheet.Range["A1"].Text = "Jan";
      worksheet.Range["B1"].Text = "Feb";
      worksheet.Range["C1"].Text = "Mar";
      worksheet.Range["A2"].Text = "10";
      worksheet.Range["B2"].Text = "20";
      worksheet.Range["C2"].Text = "30";

//Create chart and range
IChart chart = workbook.Charts.Add();
chart.DataRange = worksheet.Range["A1:C2"];

//Set chart type
chart.ChartType = ExcelChartType.Surface3D;
//Chart series axis
IChartSeriesAxis seriesAxis = chart.PrimarySerieAxis;
//Set visibility
seriesAxis.Visible = false;

//Save to file
workbook.SaveToFile("Chart.xlsx");
IChartSeriesAxis PrimarySerieAxis { get; }

Property Value

IChartSeriesAxis

PrimaryValueAxis

Primary value axis. Read-only. The following code illustrates how to set the visibility of PrimaryValueAxis:

//Create worksheet
Workbook workbook = new Workbook();
Worksheet worksheet = workbook.Worksheets[0];

//Add data
worksheet.Range["A1"].Text = "Jan";
      worksheet.Range["B1"].Text = "Feb";
      worksheet.Range["C1"].Text = "Mar";
      worksheet.Range["A2"].Text = "10";
      worksheet.Range["B2"].Text = "20";
      worksheet.Range["C2"].Text = "30";

//Create chart and range
IChart chart = workbook.Charts.Add();
chart.DataRange = worksheet.Range["A1:C2"];

//Chart value axis
IChartValueAxis valueAxis = chart.PrimaryValueAxis;
//Set visibility
valueAxis.Visible = false;

//Save to file
workbook.SaveToFile("Chart.xlsx");
IChartValueAxis PrimaryValueAxis { get; }

Property Value

IChartValueAxis

RightAngleAxes

True if the chart axes are at right angles, independent of chart rotation or elevation. The following code illustrates how RightAngleAxes can be set for charts:

//Create worksheet
Workbook workbook = new Workbook();
Worksheet worksheet = workbook.Worksheets[0];

//Add data
worksheet.Range["A1"].Text = "Jan";
      worksheet.Range["B1"].Text = "Feb";
      worksheet.Range["C1"].Text = "Mar";
      worksheet.Range["A2"].Text = "10";
      worksheet.Range["B2"].Text = "20";
      worksheet.Range["C2"].Text = "30";

//Create chart and range
Chart chart = worksheet.Charts.Add();
chart.DataRange = worksheet.Range["A1:C2"];

//Set Chart rotation and RightAngleAxes
chart.ChartType = ExcelChartType.Column3DClustered;
chart.Rotation = 50;
chart.RightAngleAxes = true;

//Save to file
workbook.SaveToFile("Chart.xlsx");
bool RightAngleAxes { get; set; }

Property Value

bool

Rotation

Returns or sets the rotation of the 3-D chart view (the rotation of the plot area around the z-axis, in degrees).(0 to 360 degrees). The following code illustrates how to set Rotation for 3-D charts:

//Create worksheet
Workbook workbook = new Workbook();
Worksheet worksheet = workbook.Worksheets[0];

//Add data
worksheet.Range["A1"].Text = "Jan";
      worksheet.Range["B1"].Text = "Feb";
      worksheet.Range["C1"].Text = "Mar";
      worksheet.Range["A2"].Text = "10";
      worksheet.Range["B2"].Text = "20";
      worksheet.Range["C2"].Text = "30";

//Create chart and range
Chart chart = worksheet.Charts.Add();
chart.DataRange = worksheet.Range["A1:C2"];

//Set Chart rotation
chart.ChartType = ExcelChartType.Column3DClustered;
chart.Rotation = 50;

//Save to file
workbook.SaveToFile("Chart.xlsx");
int Rotation { get; set; }

Property Value

int

SecondaryCategoryAxis

Secondary category axis. Read-only. The following code illustrates how to disable PrimaryCategoryAxis and set SecondaryCategoryAxis for charts:

//Create worksheet
Workbook workbook = new Workbook();
Worksheet worksheet = workbook.Worksheets[0];

//Add data
worksheet.Range["A1"].Text = "Jan";
      worksheet.Range["B1"].Text = "Feb";
      worksheet.Range["C1"].Text = "Mar";
      worksheet.Range["A2"].Text = "10";
      worksheet.Range["B2"].Text = "20";
      worksheet.Range["C2"].Text = "30";
      worksheet.Range["A3"].Value = "100";
      worksheet.Range["B3"].Value = "200";
      worksheet.Range["C3"].Value = "300";

//Create chart and range
Chart chart = worksheet.Charts.Add();
chart.DataRange = worksheet.Range["A1:C3"];

//Set secondary axis
IChartSerie serie = chart.Series[1];
serie.UsePrimaryAxis = false;
chart.SecondaryCategoryAxis.Visible = true;

//Save to file
workbook.SaveToFile("Chart.xlsx");
IChartCategoryAxis SecondaryCategoryAxis { get; }

Property Value

IChartCategoryAxis

SecondaryValueAxis

Secondary value axis. Read-only. The following code illustrates how to disable PrimaryValueAxis and set SecondaryValueAxis for charts:

//Create worksheet
Workbook workbook = new Workbook();
Worksheet worksheet = workbook.Worksheets[0];

//Add data
worksheet.Range["A1"].Text = "Jan";
      worksheet.Range["B1"].Text = "Feb";
      worksheet.Range["C1"].Text = "Mar";
      worksheet.Range["A2"].Text = "10";
      worksheet.Range["B2"].Text = "20";
      worksheet.Range["C2"].Text = "30";
      worksheet.Range["A3"].Value = "100";
      worksheet.Range["B3"].Value = "200";
      worksheet.Range["C3"].Value = "300";

//Create chart and range
Chart chart = worksheet.Charts.Add();
chart.DataRange = worksheet.Range["A1:C3"];

//Set secondary axis
IChartSerie serie = chart.Series[1];
serie.UsePrimaryAxis = false;
chart.SecondaryValueAxis.Visible = true;

//Save to file
workbook.SaveToFile("Chart.xlsx");
IChartValueAxis SecondaryValueAxis { get; }

Property Value

IChartValueAxis

SeriesDataFromRange

True if series are in rows in DataRange;False otherwise. The following code illustrates how to set SeriesDataFromRange property for charts:

//Create worksheet
Workbook workbook = new Workbook();
Worksheet worksheet = workbook.Worksheets[0];

//Add data
worksheet.Range["A1"].Text = "Jan";
      worksheet.Range["B1"].Text = "Feb";
      worksheet.Range["C1"].Text = "Mar";
      worksheet.Range["A2"].Text = "10";
      worksheet.Range["B2"].Text = "20";
      worksheet.Range["C2"].Text = "30";

//Create chart and set SeriesDataFromRange
IChart chart = workbook.Charts.Add();
chart.DataRange = worksheet.Range["A1:C2"];
chart.SeriesDataFromRange = false;

//Save to file
workbook.SaveToFile("Chart.xlsx");
bool SeriesDataFromRange { get; set; }

Property Value

bool

ShowReportFilterFieldButtons

Gets or sets a value indicating whether [show report filter field buttons].

bool ShowReportFilterFieldButtons { get; set; }

Property Value

bool

true if [show report filter field buttons]; otherwise, false.

SizeWithWindow

True if Microsoft Excel resizes the chart to match the size of the chart sheet window. False if the chart size isn't attached to the window size. Applies only to chart sheets.

bool SizeWithWindow { get; set; }

Property Value

bool

Walls

Represents chart walls. Read-only. The following code illustrates how to access IChartWallOrFloor using Walls property and set foreground color for the chart's Walls:

//Create worksheet
Workbook workbook = new Workbook();
workbook.LoadFromFile("Sample.xlsx");
Worksheet worksheet = workbook.Worksheets[0];

//Get chart
Chart chart = worksheet.Charts[0];

//Set chart wall
IChartWallOrFloor wall = chart.Walls;
//Set color
wall.Fill.FillType = ShapeFillType.SolidColor;
wall.Fill.ForeColor = System.Drawing.Color.Red;

//Save to file
workbook.SaveToFile("Chart.xlsx");
IChartWallOrFloor Walls { get; }

Property Value

IChartWallOrFloor

WallsAndGridlines2D

True if gridlines are drawn two-dimensionally on a 3-D chart.

bool WallsAndGridlines2D { get; set; }

Property Value

bool

Width

Width of the chart in points (1/72 inch).

double Width { get; set; }

Property Value

double

XPos

X coordinate of the upper-left corner of the chart in points (1/72 inch).

double XPos { get; set; }

Property Value

double

YPos

Y coordinate of the upper-left corner of the chart in points (1/72 inch).

double YPos { get; set; }

Property Value

double