ChartFormat Class

System Object
Spire.Xls.Core.Spreadsheet XlsObject
Spire.Xls.Core.Spreadsheet.Charts XlsChartFormat
Spire.Xls.Charts ChartFormat

C#

VB

C++

F#

ASP.NET

Copy

public class ChartFormat : XlsChartFormat

Public Class ChartFormat
	Inherits XlsChartFormat

public ref class ChartFormat : public XlsChartFormat

type ChartFormat =
class
inherit XlsChartFormat
end

	Name	Description
	AutoScaling	True if Microsoft Excel scales a 3-D chart so that it's closer in size to the equivalent 2-D chart.. (Inherited from XlsChartFormat .)
	BubbleScale	Percent of largest bubble compared to chart in general. ( 0 - 300 ) (Inherited from XlsChartFormat .)
	DataFormatOrNull	Returns dataformat or null; Read-only.
	Delimiter	Obsolete. Gets or sets the delimiter used to separate elements. (Inherited from XlsChartFormat .)
	DelimiterLength	Obsolete. Gets the length of the delimiter. (Inherited from XlsChartFormat .)
	DepthPercent	Returns or sets the depth of a 3-D chart as a percentage of the chart width (between 20 and 2000 percent). (Inherited from XlsChartFormat .)
	DoughnutHoleSize	Size of center hole in a doughnut chart (as a percentage).( 10 - 90 ) (Inherited from XlsChartFormat .)
	DrawingZOrder	Drawing order (0 = bottom of the z-order). (Inherited from XlsChartFormat .)
	Elevation	Gets or sets the elevation of the 3-D chart view, in degrees (0 to +90 degrees). (Inherited from XlsChartFormat .)
	FirstDropBar	Gets first drop bar.
	FirstSliceAngle	Angle of the first pie slice expressed in degrees. ( 0 - 360 ) (Inherited from XlsChartFormat .)
	Gap	Obsolete. Space between the first pie and the second. (Inherited from XlsChartFormat .)
	GapDepth	Returns or sets the distance between the data series in a 3-D chart, as a percentage of the marker width.( 0 - 500 ) (Inherited from XlsChartFormat .)
	GapWidth	Space between categories (percent of bar width), default = 50. (Inherited from XlsChartFormat .)
	HasRadarAxisLabels	True if a radar chart has axis labels. Applies only to radar charts. (Inherited from XlsChartFormat .)
	HasShadowBar	Indicates whether bar has a shadow. (Inherited from XlsChartFormat .)
	HasShadowBoppop	Indicates whether bar has a shadow. (Inherited from XlsChartFormat .)
	HasShadowLine	True if this line has a shadow. (Inherited from XlsChartFormat .)
	HasShadowPie	True if this pie has a shadow. (Inherited from XlsChartFormat .)
	HasShadowRadar	True if this radar series has a shadow. (Inherited from XlsChartFormat .)
	HasShadowScatter	True if bubble series has a shadow. (Inherited from XlsChartFormat .)
	HasValue	Obsolete. If true has value. (Inherited from XlsChartFormat .)
	HasWedgeCallout	Obsolete. Gets or sets a value indicating whether the wedge callout is present. (Inherited from XlsChartFormat .)
	HeightPercent	Returns or sets the height of a 3-D chart as a percentage of the chart width (Inherited from XlsChartFormat .)
	Is3D	If true - serie 3D; otherwise serie 2D. Read-only. (Inherited from XlsChartFormat .)
	Is3DPhongShade	True if this surface chart has shading. (Inherited from XlsChartFormat .)
	IsAreaShadowed	This area has a shadow. (Inherited from XlsChartFormat .)
	IsBubbles	Obsolete. True if this a bubble series. (Inherited from XlsChartFormat .)
	IsBubbleSize	Obsolete. If true buble has size. (Inherited from XlsChartFormat .)
	IsCategoryBrokenDown	Obsolete. Each category is broken down as a percentage. (Inherited from XlsChartFormat .)
	IsCategoryName	Obsolete. If true category has name. (Inherited from XlsChartFormat .)
	IsChartChartLine	Obsolete. If true - format contains chart chart line record. Read-only. (Inherited from XlsChartFormat .)
	IsChartLineFormat	If true - format contains series line. Read-only. (Inherited from XlsChartFormat .)
	IsClustered	Obsolete. 3D columns are clustered or stacked. (Inherited from XlsChartFormat .)
	IsDefaultElevation	Indicates whether elevation has default value. (Inherited from XlsChartFormat .)
	IsDefaultRotation	Indicates whether rotation has default value. (Inherited from XlsChartFormat .)
	IsDropBar	If true - format contains drop bar record. Read-only. (Inherited from XlsChartFormat .)
	IsFillSurface	Obsolete. True if chart contains color XlsFill for surface. (Inherited from XlsChartFormat .)
	IsHorizontalBar	Obsolete. True for horizontal bars (bar chart). False for vertical bars (column chart). (Inherited from XlsChartFormat .)
	IsLine	Obsolete. If true - format has line; otherwise false. Read-only. (Inherited from XlsChartFormat .)
	IsMarker	If true - format has marker; otherwise false. Read-only. (Inherited from XlsChartFormat .)
	IsPercentage	Obsolete. If true has percentage. (Inherited from XlsChartFormat .)
	IsPrimaryAxis	If true then belong to primary axis; otherwise to secondary axis. (Inherited from XlsChartFormat .)
	IsSeriesName	Obsolete. If true serie has name. (Inherited from XlsChartFormat .)
	IsShowLeaderLines	Obsolete. True to show leader lines to data labels. (Inherited from XlsChartFormat .)
	IsSmoothed	If true - format has smothed line; otherwise false. Read-only. (Inherited from XlsChartFormat .)
	IsStacked	Obsolete. Series in this group are stacked. (Inherited from XlsChartFormat .)
	IsVaryColor	Vary color for each data point. (Inherited from XlsChartFormat .)
	IsVeryColor	Vary color for each data point. (Inherited from XlsChartFormat .)
	LineStyle	Obsolete. Drop lines / hi-lo lines: 0 = drop lines 1 = hi-lo lines 2 = series lines (the lines that connect the columns in a stacked column chart) (Inherited from XlsChartFormat .)
	NumSplitValue	Obsolete. For split = 1, what values should go to the other pie / bar. (Inherited from XlsChartFormat .)
	Overlap	Space between bars ( -100 : 100 ). (Inherited from XlsChartFormat .)
	Parent	Reference to Parent object. Read-only. (Inherited from XlsObject .)
	Perspective	Returns or sets the perspective for the 3-D chart view.( 0 - 100 ) (Inherited from XlsChartFormat .)
	PieChartType	Obsolete. Chart pie type. (Inherited from XlsChartFormat .)
	PieSecondSize	Returns or sets the size of the secondary section of either a pie of pie chart or a bar of pie chart, as a percentage of the size of the primary pie. ( 5 - 200 ) (Inherited from XlsChartFormat .)
	PieSeriesLine	Represents series line properties. ( For pie of pie or pie of bar chart types only. ) Read only.
	ReferenceCount	Get quantity of instance references. (Inherited from XlsObject .)
	RightAngleAxes	True if the chart axes are at right angles, independent of chart rotation or elevation. (Inherited from XlsChartFormat .)
	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). (Inherited from XlsChartFormat .)
	SecondDropBar	Returns object that represents second drop bar.
	ShowAsPercentsBar	Obsolete. Each category is displayed as a percentage. (Inherited from XlsChartFormat .)
	ShowAsPercentsLine	Obsolete. Each category is broken down as a percentage. (Inherited from XlsChartFormat .)
	ShowNegativeBubbles	True to show negative bubbles. (Inherited from XlsChartFormat .)
	SizeRepresents	Returns or sets what the bubble size represents on a bubble chart. (Inherited from XlsChartFormat .)
	SplitPercent	Obsolete. For split = 2, what percentage should go to the other pie / bar. (Inherited from XlsChartFormat .)
	SplitType	Returns or sets the way the two sections of either a pie of pie chart or a bar of pie chart are split. (Inherited from XlsChartFormat .)
	SplitValue	Returns or sets the threshold value separating the two sections of either a pie of pie chart or a bar of pie chart. (Inherited from XlsChartFormat .)
	StackValuesBar	Obsolete. Stack the displayed values. (Inherited from XlsChartFormat .)
	StackValuesLine	Obsolete. Stack the displayed values. (Inherited from XlsChartFormat .)
	UseDefaultSplitValue	Obsolete. True to use default split value; otherwise False. (Inherited from XlsChartFormat .)
	WallsAndGridlines2D	Obsolete. True if gridlines are drawn two-dimensionally on a 3-D chart. (Inherited from XlsChartFormat .)

Top

	Name	Description
	AddReference	Increase the quantity of reference. User must use this method when new wrapper on object is created or reference on object stored. (Inherited from XlsObject .)
	CheckDisposed	Checks whether object was disposed and throws exception if it was. (Inherited from XlsObject .)
	Clone	Clones current object. (Inherited from XlsChartFormat .)
	Dispose	Dispose object and free resources. (Inherited from XlsObject .)
	Equals	Determines whether the specified object is equal to the current object. (Inherited from Object .)
	Finalize	Destructor. Call dispose method of current object. (Inherited from XlsObject .)
	FindParent(Type)	This method is used to find parent with specific type. (Inherited from XlsObject .)
	FindParent( Type )	Find parent of object. (Inherited from XlsObject .)
	FindParent(Type, Boolean)	This method is used to find parent with specific type. (Inherited from XlsObject .)
	FindParents	Finds parent objects. (Inherited from XlsObject .)
	GetHashCode	Serves as the default hash function. (Inherited from Object .)
	GetType	Gets the Type of the current instance. (Inherited from Object .)
	MemberwiseClone	Creates a shallow copy of the current Object . (Inherited from Object .)
	OnDispose	Method which can be overriden by users to take any specific actions when object is disposed. (Inherited from XlsObject .)
	ReleaseReference	Decrease quantity of Reference. User must call this method when freeing resources. (Inherited from XlsObject .)
	SetParent	Sets parent of the object. (Inherited from XlsObject .)
	ToString	Returns a string that represents the current object. (Inherited from Object .)

Top

	Name	Description
	m_bIsDisposed	Flag which indicates if the object was disposed or not. (Inherited from XlsObject .)

Top

Reference

Spire.Xls.Charts Namespace