Continued
Name Description Value
xlLine Line 4
xlLineMarkers Line with markers 65
xlLineMarkersStacked Stacked line with markers 66
xlLineMarkersStacked100 100% stacked line with markers 67
xlLineStacked Stacked line 63
xlLineStacked100 100% stacked line 64
xlPie Pie 5
xlPieExploded Exploded pie 69
xlPieOfPie Pie of pie 68
xlPyramidBarClustered Clustered pyramid bar 109
xlPyramidBarStacked Stacked pyramid bar 110
xlPyramidBarStacked100 100% stacked pyramid bar 111
xlPyramidCol 3D pyramid column 112
xlPyramidColClustered Clustered pyramid column 106
xlPyramidColStacked Stacked pyramid column 107
xlPyramidColStacked100 100% stacked pyramid column 108
xlRadar Radar -4151
xlRadarFilled Filled radar 82
xlRadarMarkers Radar with data markers 81
xlStockHLC High-low-close 88
xlStockOHLC Open-high-low-close 89
xlStockVHLC Volume-high-low-close 90
xlStockVOHLC Volume-open-high-low-close 91
xlSurface 3D surface 83
xlSurfaceTopView Surface (top view) 85
xlSurfaceTopViewWireframe Surface (top view wireframe) 86
xlSurfaceWireframe 3D surface (wireframe) 84
xlXYScatter Scatter -4169
xlXYScatterLines Scatter with lines 74
xlXYScatterLinesNoMarkers Scatter with lines and no data markers 75
xlXYScatterSmooth Scatter with smoothed lines 72
xlXYScatterSmoothNoMarkers Scatter with smoothed lines and no data markers 73
The next line of code assigns the selected range of data to the chart??™s Source property:
ActiveChart.SetSourceData Source:=Range( ??
"'Monthly Total Sales Amount'!$A$1:$E$7")
CHAPTER 5 n CHARTING IN EXCEL 2007 200
The last line of the MakeBeverageSalesChart macro sets the type of chart directly using
the ChartType property of the ActiveChart object:
ActiveChart.
Pages:
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202