Graph Element (Microsoft Excel)

Contains the definition of a graph within the plot area of a chart.

Contained In

PlotArea

Subelements

Blank, Border, BubbleScale, CustomSplit, DBSeries, DataLabels, DataSource, DropLines, FirstSliceAngle, GapDepth, GapWidth, HiLowLines, HoleSize, Interior, Line, NegativeBubbles, Overlap, Pie2HasShadow, Pie2Size, PlotVisible, ScaleID, Series, Shade3D, SizeRepresents, SplitPos, SplitType, SplitValue, SubType, Type, VaryColors, WaterLevel

Remarks

The SubType, Type, and at least two ScaleID subelements are required, but all other subelements are optional. The Type and SubType subelements specify the chart type. If more than one Series subelement is specified, each subelement corresponds to a series in the order specified.

Each graph contains two or more ScaleID subelements specifying the horizontal and vertical layout and scale format properties, such as for color or transparencies. The first two ScaleID subelements correspond to the graph's horizontal and vertical (or r and θ for radar) scalings, respectively.

The following table lists the subelements that can be specified for each type of chart.

Chart Type Subelements
Column
Bar
Overlap (2-D only)
GapWidth
GapDepth (3-D only)
VaryColors
Line DropLines
HiLowLines
GapDepth (3-D only)
VaryColors
Stock HiLowLines
DropLines
Area DropLines
GapDepth (3-D only)
Pie FirstSliceAngle
Explode
VaryColors
Radar CatLabels
VaryColors
Surface Shade3D
Scatter
Polar
VaryColors
Doughnut FirstSliceAngle
Explode
HoleSize
VaryColors
Bubble SizeRepresents
BubbleScale
NegativeBubble
VaryColors
Pie of Pie
Bar of Pie
SplitType
SplitPos
Pie2Size
Pie2HasShadow
GapWidth
CustomSplit
VaryColors

Example

See the example in the WebChart element topic.