Microsoft Office Tutorials and References
In Depth Information
Example 21-4. The ChartTypes.txt File
bPause = Not bPause
End Sub
This code contains three procedures. The main procedure is ScrollChartTypes , which sets the
chart type and adjusts the chart's title accordingly. The procedure uses a text file, ChartTypes.txt ,
that contains a list of all chart types and their names. The contents of that text file are shown in
Example 21-4 . This file will need to be in the same directory as the workbook.
Example 21-4. The ChartTypes.txt File
-4169 XYScatter
-4151 Radar
-4120 Doughnut
-4102 3DPie
-4101 3DLine
-4100 3DColumn
-4098 3DArea
1 Area
4 Line
5 Pie
15 Bubble
51 ColumnClustered
52 ColumnStacked
53 ColumnStacked100
54 3DColumnClustered
55 3DColumnStacked
56 3DColumnStacked100
57 BarClustered
58 BarStacked
59 BarStacked100
60 3DBarClustered
61 3DBarStacked
62 3DBarStacked100
63 LineStacked
64 LineStacked100
65 LineMarkers
66 LineMarkersStacked
67 LineMarkersStacked100
68 PieOfPie
69 PieExploded
70 3DPieExploded
71 BarOfPie
72 XYScatterSmooth
73 XYScatterSmoothNoMarkers
74 XYScatterLines
75 XYScatterLinesNoMarkers
76 AreaStacked
77 AreaStacked100
78 3DAreaStacked
79 3DAreaStacked100
80 DoughnutExploded
81 RadarMarkers
82 RadarFilled
83 Surface
84 SurfaceWireframe
85 SurfaceTopView
86 SurfaceTopViewWireframe
87 Bubble3DEffect
88 StockHLC
89 StockOHLC
 
Search JabSto ::




Custom Search