XlsChartShape Properties

	Name	Description
	AlternativeText	Returns or sets the descriptive (alternative) text string for a Shape object when the object is saved to a Web page. Read/write String (Inherited from XlsShape .)
	AlternativeTextTitle	Returns or sets the descriptive (alternative) text title string for a Shape object when the object is saved to a Web page. Read/write String (Inherited from XlsShape .)
	AutoScaling	True if Microsoft Excel scales a 3-D chart so that it's closer in size to the equivalent 2-D chart.
	AutoSize	True if the size of the specified object is changed automatically to fit text within its boundaries. (Inherited from XlsShape .)
	BottomRow	Bottom row of the chart in the worksheet.
	BottomRowOffset	Bottom row offset. (Inherited from XlsShape .)
	CategoryAxisTitle	Title of the category axis.
	ChartArea	Returns an object that represents the complete chart area for the chart. Read-only.
	ChartSubTitle	Gets the chart's sub-title. Only for ODS format file.
	ChartTitle	Represents the title of the specified chart.
	ChartTitleArea	Gets title text area. Read-only.
	ChartType	Type of the chart.
	CheckBoxes	Returns collection with all checkboxes inside this worksheet. Read-only.
	CodeName	Gets code name of the chart.
	ComboBoxes	Returns collection with all comboboxes inside this worksheet. Read-only.
	DataRange	DataRange for the chart series.
	DataTable	Represents charts dataTable object.
	DepthPercent	Returns or sets the depth of a 3-D chart as a percentage of the chart width (between 20 and 2000 percent).
	DisplayAxisFieldButtons	Gets or sets a value indicating whether [show axis field buttons].
	DisplayBlanksAs	Represents the way that blank cells are plotted on a chart.
	DisplayEntireFieldButtons	Gets or sets a value indicating whether [show all field buttons].
	DisplayLegendFieldButtons	Gets or sets a value indicating whether [show legend field buttons].
	DisplayValueFieldButtons	Gets or sets a value indicating whether [show value field buttons].
	Elevation	Returns or sets the elevation of the 3-D chart view, in degrees (?0 to +90 degrees). Examples The following code illustrates how to set Rotation for 3-D charts: Copy <para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Add data</para><para>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";</para><para>//Create chart and range</para><para>Chart chart = worksheet.Charts.Add();</para><para>chart.DataRange = worksheet.Range["A1:C2"];</para><para>//Set Chart elevation</para><para>chart.ChartType = ExcelChartType.Column3DClustered;</para><para>chart.Elevation = 50;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
	Fill	Represents fill properties. (Inherited from XlsShape .)
	Floor	Represents chart floor. Read-only.
	GapDepth	Returns or sets the distance between the data series in a 3-D chart, as a percentage of the marker width.( 0 - 500 )
	Glow	Gets the glow properties. (Inherited from XlsShape .)
	HasChartArea	Indicates whether chart has chart area.
	HasChartTitle	Indicates wheather the chart has title
	HasDataTable	True if the chart has a data table. Examples The following code illustrates how data table can be set for charts: Copy <para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Add data</para><para>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";</para><para>//Create chart and range</para><para>Chart chart = worksheet.Charts.Add();</para><para>chart.DataRange = worksheet.Range["A1:C2"];</para><para>//Set Chart data table</para><para>chart.HasDataTable = true;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
	HasFill	Indicates whether XlsFill item was created. Read-only. (Inherited from XlsShape .)
	HasFloor	Gets value indicating whether floor object was created.
	HasLegend	True if the chart has a legend object. Examples The following code illustrates how to set HasLegend property: Copy <para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Add data</para><para>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";</para><para>//Create chart and range</para><para>Chart chart = worksheet.Charts.Add();</para><para>chart.DataRange = worksheet.Range["A1:C2"];</para><para>//Set hasLegend</para><para>chart.HasLegend = false;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
	HasLineFormat	Indicates whether line item was created. Read-only. (Inherited from XlsShape .)
	HasPivotTable	Indicates whether contains pivot table.
	HasPlotArea	Indicates whether chart has plot area.
	HasWalls	Gets value indicating whether floor object was created.
	Height	Height of object. (Inherited from XlsShape .)
	HeightPercent	Returns or sets the height of a 3-D chart as a percentage of the chart width (between 5 and 500 percent).
	HtmlString	Gets and sets the html string which contains data and some formattings in this shape. (Inherited from XlsShape .)
	ID	ID of object. (Inherited from XlsShape .)
	Instance	Obsolete. Returns instance value. Read-only. (Inherited from XlsShape .)
	IsFlipH	Returns or sets if the shape flips Horizontal.false is default; (Inherited from XlsShape .)
	IsFlipV	Returns or sets if the shape flips Vertical.false is default; (Inherited from XlsShape .)
	IsGroup	This shape is group shape. (Inherited from XlsShape .)
	IsInGroup	This shape is child shape of group shape. (Inherited from XlsShape .)
	IsLockAspectRatio	True means that don't allow changes in aspect ratio. (Inherited from XlsShape .)
	IsLocked	Gets or sets a value indicating whether the shape is locked. (Inherited from XlsShape .)
	IsMoveWithCell	Determines whether the object moves with the cell it is associated with. (Inherited from XlsShape .)
	IsPrintable	Gets or sets a value indicating whether the shape is printable. (Inherited from XlsShape .)
	IsRelative	Gets or sets a value indicating whether the shape is relative. (Inherited from XlsShape .)
	IsRelativeResize	True means that is relative to original size of picture. (Inherited from XlsShape .)
	IsRightToLeft	Indicates whether chart is displayed right to left.
	IsShortVersion	Obsolete. Indiicates whether it is short version of the shape (without obj and maybe some other properties). (Inherited from XlsShape .)
	IsSizeWithCell	Determines whether the size is calculated based on the cell dimensions. (Inherited from XlsShape .)
	IsSmartArt	Determines whether the shape is a SmartArt graphic based on the presence of a linked drawing. (Inherited from XlsShape .)
	Left	X of object (Inherited from XlsShape .)
	LeftColumn	Left column of the chart in the worksheet.
	LeftColumnOffset	Left column offset. 1024 means whole column offset (Inherited from XlsShape .)
	Legend	Represents chart legend.
	Line	Represents line format properties. Read only. (Inherited from XlsShape .)
	LinkedCell	Gets or sets the linked cell for the shape. (Inherited from XlsShape .)
	Name	Name of object. (Inherited from XlsShape .)
	OnAction	Gets or sets macro-command that is called when action happens. (Inherited from XlsShape .)
	PageSetup	Page setup for the chart. Read-only.
	Parent	Reference to Parent object. Read-only. (Inherited from XlsObject .)
	Perspective	Returns or sets the perspective for the 3-D chart view (0 to 100). Examples The following code illustrates how to set Perspective for the charts: Copy <para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Add data</para><para>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";</para><para>//Create chart and range</para><para>Chart chart = worksheet.Charts.Add();</para><para>chart.DataRange = worksheet.Range["A1:C2"];</para><para>//Set Chart perspective</para><para>chart.ChartType = ExcelChartType.Column3DClustered;</para><para>chart.Perspective = 70;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
	PivotChartType	Gets or sets the type of the pivot chart.
	PivotTable	Gets or sets the pivot source.
	PlotArea	Returns plot area frame format. Read-only.
	PlotVisibleOnly	True if only visible cells are plotted. False if both visible and hidden cells are plotted.
	PrimaryCategoryAxis	Primary category axis. Read-only.
	PrimaryFormats	Returns chart format collection in primary axis.
	PrimarySerieAxis	Primary serie axis. Read-only.
	PrimaryValueAxis	Primary value axis. Read-only.
	ReferenceCount	Get quantity of instance references. (Inherited from XlsObject .)
	Reflection	Gets the reflection effect applied to the shape. (Inherited from XlsShape .)
	ResizeBehave	Specifies all possible settings for how drawing object shall be resized when the rows and columns between its start and ending anchor are resized or inserted(ComboBoxShape and CheckBoxShape and RadioButtonShape set MoveAndResize type value is invalid) (Inherited from XlsShape .)
	RichText	Gets the rich text string associated with the current object. If the rich text string has not been initialized, it creates a new instance of RichTextShape. (Inherited from XlsShape .)
	RightAngleAxes	True if the chart axes are at right angles, independent of chart rotation or elevation.
	RightColumn	Right column of the chart in the worksheet.
	RightColumnOffset	Right column offset. (Inherited from XlsShape .)
	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). Examples The following code illustrates how to set Rotation for 3-D charts: Copy <para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Add data</para><para>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";</para><para>//Create chart and range</para><para>Chart chart = worksheet.Charts.Add();</para><para>chart.DataRange = worksheet.Range["A1:C2"];</para><para>//Set Chart rotation</para><para>chart.ChartType = ExcelChartType.Column3DClustered;</para><para>chart.Rotation = 50;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>
	SecondaryCategoryAxis	Secondary category axis. Read-only.
	SecondaryCategoryAxisTitle	Title of the secondary category axis.
	SecondaryFormats	Returns chart format collection in secondary axis.
	SecondaryValueAxis	Secondary value axis. Read-only.
	SecondaryValueAxisTitle	Title of the secondary value axis.
	SeriesAxisTitle	Title of the series axis.
	SeriesDataFromRange	True if series are in rows in DataRange; False otherwise.
	Shadow	Gets the shadow properties. (Inherited from XlsShape .)
	ShapeCount	Obsolete. Returns number of shapes contained by this shape (1 means no sub shapes). Read-only. (Inherited from XlsShape .)
	ShapeId	Gets / sets shape id. (Inherited from XlsShape .)
	Shapes	Returns chart shapes.
	ShapeType	Type of shape , Read Only. (Inherited from XlsShape .)
	ShowReportFilterFieldButtons	Gets or sets a value indicating whether [show report filter field buttons].
	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.
	SupportWallsAndFloor	Indicates whether this chart supports walls and floor. Read-only.
	TextBoxes	Returns collection with all textboxes inside this worksheet. Read-only.
	TextFrame	Gets the text frame associated with the shape. (Inherited from XlsShape .)
	TextVerticalAlignment	Get or set Text Vertical Alignment in shape. (Inherited from XlsShape .)
	ThreeD	Gets the chart3 D properties. (Inherited from XlsShape .)
	Top	Top of object. (Inherited from XlsShape .)
	TopRow	Top row of the chart in the worksheet.
	TopRowOffset	Top row offset.256 means whole row offset (Inherited from XlsShape .)
	UpdatePositions	Indicates whether we have to update absolute positions after setting TopRow, BottomRow, LeftColumn, RightColumn. (Inherited from XlsShape .)
	ValueAxisTitle	Title of the value axis.
	Visible	Gets or sets the visibility of the shape. When set to true, the shape is visible; when set to false, the shape is hidden. (Inherited from XlsShape .)
	VmlShape	Indicates whether this is vml shape or not. (Inherited from XlsShape .)
	Walls	Represents chart walls. Read-only.
	WallsAndGridlines2D	True if gridlines are drawn two-dimensionally on a 3-D chart.
	Width	Width of object. (Inherited from XlsShape .)
	XPos	X coordinate of the upper-left corner of the chart in points (1/72 inch).
	YPos	Y coordinate of the upper-left corner of the chart in points (1/72 inch).

Name

Description

Returns or sets the descriptive (alternative) text string for a Shape object when the object is saved to a Web page. Read/write String

(Inherited from XlsShape .)

AlternativeTextTitle

Returns or sets the descriptive (alternative) text title string for a Shape object when the object is saved to a Web page. Read/write String

(Inherited from XlsShape .)

AutoScaling

True if Microsoft Excel scales a 3-D chart so that it's closer in size to the equivalent 2-D chart.

AutoSize

True if the size of the specified object is changed automatically to fit text within its boundaries.

(Inherited from XlsShape .)

BottomRow

Bottom row of the chart in the worksheet.

BottomRowOffset

Bottom row offset.

(Inherited from XlsShape .)

CategoryAxisTitle

Title of the category axis.

ChartArea

Returns an object that represents the complete chart area for the chart. Read-only.

ChartSubTitle

Gets the chart's sub-title. Only for ODS format file.

ChartTitle

Represents the title of the specified chart.

ChartTitleArea

Gets title text area. Read-only.

ChartType

Type of the chart.

CheckBoxes

Returns collection with all checkboxes inside this worksheet. Read-only.

CodeName

Gets code name of the chart.

ComboBoxes

Returns collection with all comboboxes inside this worksheet. Read-only.

DataRange

DataRange for the chart series.

DataTable

Represents charts dataTable object.

DepthPercent

Returns or sets the depth of a 3-D chart as a percentage of the chart width (between 20 and 2000 percent).

DisplayAxisFieldButtons

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

DisplayBlanksAs

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

DisplayEntireFieldButtons

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

DisplayLegendFieldButtons

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

DisplayValueFieldButtons

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

Elevation

Returns or sets the elevation of the 3-D chart view, in degrees (?0 to +90 degrees).

Examples

The following code illustrates how to set Rotation for 3-D charts:

Copy

<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Add data</para><para>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";</para><para>//Create chart and range</para><para>Chart chart = worksheet.Charts.Add();</para><para>chart.DataRange = worksheet.Range["A1:C2"];</para><para>//Set Chart elevation</para><para>chart.ChartType = ExcelChartType.Column3DClustered;</para><para>chart.Elevation = 50;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>

Fill

Represents fill properties.

(Inherited from XlsShape .)

Floor

Represents chart floor. Read-only.

GapDepth

Returns or sets the distance between the data series in a 3-D chart, as a percentage of the marker width.( 0 - 500 )

Glow

Gets the glow properties.

(Inherited from XlsShape .)

HasChartArea

Indicates whether chart has chart area.

HasChartTitle

Indicates wheather the chart has title

HasDataTable

True if the chart has a data table.

Examples

The following code illustrates how data table can be set for charts:

Copy

<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Add data</para><para>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";</para><para>//Create chart and range</para><para>Chart chart = worksheet.Charts.Add();</para><para>chart.DataRange = worksheet.Range["A1:C2"];</para><para>//Set Chart data table</para><para>chart.HasDataTable = true;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>

HasFill

Indicates whether XlsFill item was created. Read-only.

(Inherited from XlsShape .)

HasFloor

Gets value indicating whether floor object was created.

HasLegend

True if the chart has a legend object.

Examples

The following code illustrates how to set HasLegend property:

Copy

<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Add data</para><para>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";</para><para>//Create chart and range</para><para>Chart chart = worksheet.Charts.Add();</para><para>chart.DataRange = worksheet.Range["A1:C2"];</para><para>//Set hasLegend</para><para>chart.HasLegend = false;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>

HasLineFormat

Indicates whether line item was created. Read-only.

(Inherited from XlsShape .)

HasPivotTable

Indicates whether contains pivot table.

HasPlotArea

Indicates whether chart has plot area.

HasWalls

Gets value indicating whether floor object was created.

Height

Height of object.

(Inherited from XlsShape .)

HeightPercent

Returns or sets the height of a 3-D chart as a percentage of the chart width (between 5 and 500 percent).

HtmlString

Gets and sets the html string which contains data and some formattings in this shape.

(Inherited from XlsShape .)

ID of object.

(Inherited from XlsShape .)

Instance

Obsolete.

Returns instance value. Read-only.

(Inherited from XlsShape .)

IsFlipH

Returns or sets if the shape flips Horizontal.false is default;

(Inherited from XlsShape .)

IsFlipV

Returns or sets if the shape flips Vertical.false is default;

(Inherited from XlsShape .)

IsGroup

This shape is group shape.

(Inherited from XlsShape .)

IsInGroup

This shape is child shape of group shape.

(Inherited from XlsShape .)

IsLockAspectRatio

True means that don't allow changes in aspect ratio.

(Inherited from XlsShape .)

IsLocked

Gets or sets a value indicating whether the shape is locked.

(Inherited from XlsShape .)

IsMoveWithCell

Determines whether the object moves with the cell it is associated with.

(Inherited from XlsShape .)

IsPrintable

Gets or sets a value indicating whether the shape is printable.

(Inherited from XlsShape .)

IsRelative

Gets or sets a value indicating whether the shape is relative.

(Inherited from XlsShape .)

IsRelativeResize

True means that is relative to original size of picture.

(Inherited from XlsShape .)

IsRightToLeft

Indicates whether chart is displayed right to left.

IsShortVersion

Obsolete.

Indiicates whether it is short version of the shape (without obj and maybe some other properties).

(Inherited from XlsShape .)

IsSizeWithCell

Determines whether the size is calculated based on the cell dimensions.

(Inherited from XlsShape .)

IsSmartArt

Determines whether the shape is a SmartArt graphic based on the presence of a linked drawing.

(Inherited from XlsShape .)

Left

X of object

(Inherited from XlsShape .)

LeftColumn

Left column of the chart in the worksheet.

LeftColumnOffset

Left column offset. 1024 means whole column offset

(Inherited from XlsShape .)

Legend

Represents chart legend.

Line

Represents line format properties. Read only.

(Inherited from XlsShape .)

LinkedCell

Gets or sets the linked cell for the shape.

(Inherited from XlsShape .)

Name

Name of object.

(Inherited from XlsShape .)

OnAction

Gets or sets macro-command that is called when action happens.

(Inherited from XlsShape .)

PageSetup

Page setup for the chart. Read-only.

Parent

Reference to Parent object. Read-only.

(Inherited from XlsObject .)

Perspective

Returns or sets the perspective for the 3-D chart view (0 to 100).

Examples

The following code illustrates how to set Perspective for the charts:

Copy

<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Add data</para><para>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";</para><para>//Create chart and range</para><para>Chart chart = worksheet.Charts.Add();</para><para>chart.DataRange = worksheet.Range["A1:C2"];</para><para>//Set Chart perspective</para><para>chart.ChartType = ExcelChartType.Column3DClustered;</para><para>chart.Perspective = 70;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>

PivotChartType

Gets or sets the type of the pivot chart.

PivotTable

Gets or sets the pivot source.

PlotArea

Returns plot area frame format. Read-only.

PlotVisibleOnly

True if only visible cells are plotted. False if both visible and hidden cells are plotted.

PrimaryCategoryAxis

Primary category axis. Read-only.

PrimaryFormats

Returns chart format collection in primary axis.

PrimarySerieAxis

Primary serie axis. Read-only.

PrimaryValueAxis

Primary value axis. Read-only.

ReferenceCount

Get quantity of instance references.

(Inherited from XlsObject .)

Reflection

Gets the reflection effect applied to the shape.

(Inherited from XlsShape .)

ResizeBehave

Specifies all possible settings for how drawing object shall be resized when the rows and columns between its start and ending anchor are resized or inserted(ComboBoxShape and CheckBoxShape and RadioButtonShape set MoveAndResize type value is invalid)

(Inherited from XlsShape .)

RichText

Gets the rich text string associated with the current object. If the rich text string has not been initialized, it creates a new instance of RichTextShape.

(Inherited from XlsShape .)

RightAngleAxes

True if the chart axes are at right angles, independent of chart rotation or elevation.

RightColumn

Right column of the chart in the worksheet.

RightColumnOffset

Right column offset.

(Inherited from XlsShape .)

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).

Examples

The following code illustrates how to set Rotation for 3-D charts:

Copy

<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Add data</para><para>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";</para><para>//Create chart and range</para><para>Chart chart = worksheet.Charts.Add();</para><para>chart.DataRange = worksheet.Range["A1:C2"];</para><para>//Set Chart rotation</para><para>chart.ChartType = ExcelChartType.Column3DClustered;</para><para>chart.Rotation = 50;</para><para>//Save to file</para><para>workbook.SaveToFile("Chart.xlsx");</para>

SecondaryCategoryAxis

Secondary category axis. Read-only.

SecondaryCategoryAxisTitle

Title of the secondary category axis.

SecondaryFormats

Returns chart format collection in secondary axis.

SecondaryValueAxis

Secondary value axis. Read-only.

SecondaryValueAxisTitle

Title of the secondary value axis.

SeriesAxisTitle

Title of the series axis.

SeriesDataFromRange

True if series are in rows in DataRange; False otherwise.

Shadow

Gets the shadow properties.

(Inherited from XlsShape .)

ShapeCount

Obsolete.

Returns number of shapes contained by this shape (1 means no sub shapes). Read-only.

(Inherited from XlsShape .)

ShapeId

Gets / sets shape id.

(Inherited from XlsShape .)

Shapes

Returns chart shapes.

ShapeType

Type of shape , Read Only.

(Inherited from XlsShape .)

ShowReportFilterFieldButtons

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

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.

SupportWallsAndFloor

Indicates whether this chart supports walls and floor. Read-only.

TextBoxes

Returns collection with all textboxes inside this worksheet. Read-only.

TextFrame

Gets the text frame associated with the shape.

(Inherited from XlsShape .)

TextVerticalAlignment

Get or set Text Vertical Alignment in shape.

(Inherited from XlsShape .)

ThreeD

Gets the chart3 D properties.