XlsChartFormat Properties

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

Percent of largest bubble compared to chart in general. ( 0 - 300 )

Returns dataformat or null; Read-only.

Gets or sets the delimiter used to separate elements.

Gets the length of the delimiter.

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

Size of center hole in a doughnut chart (as a percentage).( 10 - 90 )

Drawing order (0 = bottom of the z-order).

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

Returns object that represents first drop bar.

Angle of the first pie slice expressed in degrees. ( 0 - 360 )

Space between the first pie and the second.

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

Space between categories (percent of bar width), default = 50.

True if a radar chart has axis labels. Applies only to radar charts.

Indicates whether bar has a shadow.

Indicates whether bar has a shadow.

True if this line has a shadow.

True if this pie has a shadow.

True if this radar series has a shadow.

True if bubble series has a shadow.

If true has value.

Gets or sets a value indicating whether the wedge callout is present.

Returns or sets the height of a 3-D chart as a percentage of the chart width

If true - serie 3D; otherwise serie 2D. Read-only.

True if this surface chart has shading.

This area has a shadow.

True if this a bubble series.

If true buble has size.

Each category is broken down as a percentage.

If true category has name.

If true - format contains chart chart line record. Read-only.

If true - format contains series line. Read-only.

3D columns are clustered or stacked.

Indicates whether elevation has default value.

Indicates whether rotation has default value.

If true - format contains drop bar record. Read-only.

True if chart contains color XlsFill for surface.

True for horizontal bars (bar chart). False for vertical bars (column chart).

If true - format has line; otherwise false. Read-only.

If true - format has marker; otherwise false. Read-only.

If true has percentage.

If true then belong to primary axis; otherwise to secondary axis.

If true serie has name.

True to show leader lines to data labels.

If true - format has smothed line; otherwise false. Read-only.

Series in this group are stacked.

Vary color for each data point.

Vary color for each data point.

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)

For split = 1, what values should go to the other pie / bar.

Space between bars ( -100 : 100 ).

Reference to Parent object. Read-only.

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

Chart pie type.

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 )

Represents series line properties. ( For pie of pie or pie of bar chart types only. ) Read only.

Get quantity of instance references.

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

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

Returns object that represents second drop bar.

Each category is displayed as a percentage.

Each category is broken down as a percentage.

True to show negative bubbles.

Returns or sets what the bubble size represents on a bubble chart.

For split = 2, what percentage should go to the other pie / bar.

Returns or sets the way the two sections of either a pie of pie chart or a bar of pie chart are split.

Returns or sets the threshold value separating the two sections of either a pie of pie chart or a bar of pie chart.

Stack the displayed values.

Stack the displayed values.

True to use default split value; otherwise False.

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