Microsoft Office Tutorials and References
In Depth Information
21.3 Chart Types
21.3 Chart Types
Each Excel chart has either a standard chart type or a custom chart type. In addition, there are two
types of custom chart types: built-in and user-defined. All chart types are accessible by the user
through the Chart Type dialog box shown in Figure 21-7 ( right-click a chart and choose Chart
Type).
Figure 21-7. The Chart Type dialog
21.3.1 ChartType property
The ChartType property is a read-write property that can be set to any one of the XlChartType
constants in Table 21-1 .
Table 21-1. ChartType Con stants
Type
Description
Constant(Value)
D Area 3
xl3DArea(-4098)
Area
D Stacked Area 3
xl3DAreaStacked(78)
D 100% Stacked Area 3
xl3DAreaStacked100(79)
Area
xlArea(1)
Stacked Area
xlAreaStacked(76)
00% Stacked Area 1
xlAreaStacked100(77)
Bar
D Clustered Bar 3
xl3DBarClustered(60)
D Stacked Bar 3
xl3DBarStacked(61)
D 100% Stacked Bar 3
xl3DBarStacked100(62)
Clustered Bar
xlBarClustered(57)
 
 
 
Search JabSto ::




Custom Search