Microsoft Office Tutorials and References
In Depth Information
21.3.1.1 ApplyCustomType method
00% Stacked Pyramid Column 1
xlPyramidColStacked100(108)
Radar
xlRadar(-4151)
Radar
Filled Radar
xlRadarFilled(82)
Radar with Data Markers
xlRadarMarkers(81)
Stock
Quotes
High-Low-Close
xlStockHLC(88)
Open-High-Low-Close
xlStockOHLC(89)
Volume-High-Low-Close
xlStockVHLC(90)
Volume-Open-High-Low-Close
xlStockVOHLC(91)
Surface
D Surface 3
xlSurface(83)
Surface (Top View)
xlSurfaceTopView(85)
Surface (Top View) wireframe)
xlSurfaceTopViewWireframe(86)
D Surface (wireframe) 3
xlSurfaceWireframe(84)
XY (Scatter) Scatter
xlXYScatter(-4169)
Scatter with Lines
xlXYScatterLines(74)
Scatter with Lines and No Data Markers
xlXYScatterLinesNoMarkers(75)
Scatter with Smoothed Lines
xlXYScatterSmooth(72)
Scatter with Smoothed Lines and No Data
Markers
xlXYScatterSmoothNoMarkers(73)
In Example 21-3 , at the end of the chapter, we present a macro that scrolls through the chart types
in Table 21-1 , allowing you to determine which chart type is appropriate for a particular purpose.
Note that it is possible that the return value of the ChartType property may not be one of the
values in Table 21-1 . For instance, the code:
MsgBox ActiveChart.ChartType
returns -4111 when applied to a chart with a particular user-defined chart type. This value
actually occurs only once in the Excel object model. It is part of the Constants enum and is
assigned the symbolic name xlCombination . (Since this seems not to be documented, I cannot
say that this is the only value of ChartType that is not in Table 21-1 . )
Note that each individual data series can have a chart type; that is, the Series object also has a
ChartType property. In this way, if a chart has two data series, each series can have a different
chart type. For instance, one series can be plotted as a line graph and the other as a column graph.
(We will discuss Series objects later in the chapter.)
21.3.1.1 ApplyCustomType method
Contrary to its name, the ApplyCustomType method can apply either a standard or a custom chart
type to a chart. The syntax is:
ChartObject .ApplyCustomType( ChartType , TypeName )
The ChartType parameter is either a standard chart type constant from Table 21-1 or one of the
following XlChartGallery constants:
Enum XlChartGallery
xlBuiltIn = 21
xlUserDefined = 22
 
 
Search JabSto ::




Custom Search