Appendix A
Gallery of Graph Types and
3D Preset Viewing Angles
|
This appendix describes: |
|
|
|
|
|
|
|
The following tables lists each of the possible graph types that can be selected using the GraphType property: |
|
# |
GraphType= |
|
0 |
3D Bars |
|
1 |
3D Pyramids |
|
2 |
3D Octagons |
|
3 |
Reserved |
|
4 |
3D Floating Cubes |
|
5 |
3D Floating Pyramids |
|
6 |
3D Connected Series Area |
|
7 |
3D Connected Series Ribbon |
|
8 |
Reserved for future use |
|
9 |
3D Connected Group Area |
|
10 |
3D Connected Group Ribbon |
|
11 |
Reserved for future use |
|
12 |
3D Surface |
|
13 |
3D Surface with Sides |
|
14 |
3D Honeycomb Surface |
|
15 |
Reserved for future use |
|
16 |
Reserved for future use |
|
17 |
Vertical Clustered Bars |
|
18 |
Vertical Stacked Bars |
|
19 |
Vertical Dual-Axis Clustered Bars |
|
20 |
Vertical Dual-Axis Stacked Bars |
|
21 |
Vertical Bi-Polar Clustered Bars |
|
22 |
Vertical Bi-Polar Stacked Bars |
|
23 |
Vertical Percent Bars |
|
24 |
Horizontal Clustered Bars |
|
25 |
Horizontal Stacked Bars |
|
26 |
Horizontal Dual-Axis Clustered Bars |
|
27 |
Horizontal Dual-Axis Stacked Bars |
|
28 |
Horizontal Bi-Polar Clustered Bars |
|
29 |
Horizontal Bi-Polar Stacked Bars |
|
30 |
Horizontal Percent Bars |
|
31 |
Vertical Absolute Area |
|
32 |
Vertical Stacked Area |
|
33 |
Vertical Bi-Polar Absolute Area |
|
34 |
Vertical Bi-Polar Stacked Area |
|
35 |
Vertical Percent Area |
|
36 |
Horizontal Absolute Area |
|
37 |
Horizontal Stacked Area |
|
38 |
Horizontal Bi-Polar Absolute Area |
|
39 |
Horizontal Bi-Polar Stacked Area |
|
40 |
Horizontal Percent Area |
|
41 |
Vertical Absolute Line |
|
42 |
Vertical Stacked Line |
|
43 |
Vertical Dual-Axis Absolute Line |
|
44 |
Vertical Dual-Axis Stacked Line |
|
45 |
Vertical Bi-Polar Absolute Line |
|
46 |
Vertical Bi-Polar Stacked Line |
|
47 |
Vertical Percent Line |
|
48 |
Horizontal Absolute Line |
|
49 |
Horizontal Stacked Line |
|
50 |
Horizontal Dual-Axis Absolute Line |
|
51 |
Horizontal Dual-Axis Stacked Line |
|
52 |
Horizontal Bi-Polar Absolute Line |
|
53 |
Horizontal Bi-Polar Stacked Line |
|
54 |
Horizontal Percent Line |
|
55 |
Pie |
|
56 |
Ring Pie |
|
57 |
Multi Pie |
|
58 |
Multi Ring Pie |
|
59 |
Multi Proportional Pie |
|
60 |
Multi Proportional Ring Pie |
|
61 |
XY Scatter |
|
62 |
XY Scatter Dual-Axis |
|
63 |
XY Scatter with Labels |
|
64 |
XY Scatter with Labels Dual-Axis |
|
65 |
Polar |
|
66 |
Polar Dual-Axis |
|
67 |
Radar Line |
|
68 |
Radar Area |
|
69 |
Radar Line Dual-Axis |
|
70 |
Open-Hi-Lo-Close Candle Stock Chart |
|
71 |
Open-Hi-Lo-Close Candle Stock Chart with Volume |
|
72 |
Candle Stock Hi-Lo Open-Close |
|
73 |
Stock Hi-Lo |
|
74 |
Stock Hi-Lo Dual-Axis |
|
75 |
Stock Hi-Lo Bi-Polar |
|
76 |
Stock Hi-Lo Close |
|
77 |
Stock Hi-Lo Close Dual-Axis |
|
78 |
Stock Hi-Lo Bi-Polar |
|
79 |
Stock Hi-Lo Open-Close |
|
80 |
Stock Hi-Lo Open-Close Dual-Axis |
|
81 |
Stock Hi-Lo Open-Close Bi-Polar |
|
82 |
Stock Hi-Lo with Volume |
|
83 |
Stock Hi-Lo Open-Close with Volume |
|
84 |
Candle Stock Hi-Lo Open-Close with Volume |
|
85 |
Vertical Histogram |
|
86 |
Horizontal Histogram |
|
87 |
Spectral Map |
|
88 |
Stock Hi-Lo Close with Volume |
|
89 |
Bubble Chart |
|
90 |
Bubble Chart with Labels |
|
91 |
Bubble Chart Dual-Axes |
|
92 |
Bubble Chart with Labels Dual-Axes |
|
93 |
Pie-Bar Chart |
|
94 |
Ring Pie-Bar Chart |
|
See Chapter 7 for information about selecting and using the GraphType property. |
3D Bars (GraphType=0): Standard 3D chart. Displays a bar for each value in the data set. |
|
3D Pyramid (GraphType=1): Pyramids are a good type for showing volume information, like an amount of some item. |
|
3D Octagon (GraphType=2): Octagons drawn in 3D. Can be made elliptical or more perfectly columnar. |
|
3D Floating Cubes (GraphType=4): Excellent 3D type for data values that are close to each other. You can see under and around the cubes. |
|
3D Floating Pyramids (GraphType=5): Pretty, diamond-like pyramids floating in air trace out your data points. |
|
3D Connected Series Area (GraphType=6): Good for showing trend information along the series dimension. |
|
3D Connected Series Ribbon (GraphType=7): Good for showing trend information along the series dimension. |
|
3D Connected Group Area (GraphType=9): Good for showing trend information along the groups dimension. |
|
3D Connected Group Ribbon (GraphType=10): Good for showing trend information along the groups dimension. |
|
3D Surface (GraphType=12): Graphs all data points as a 3D surface, like a rolling wave. |
|
3D Surface with Sides (GraphType=13): Graph all data points as a 3D surface, with solid sides. |
|
3D Honeycomb Surface (GraphType=14): Graphs all data points as a 3D surface using a "honeycomb" effect. |
|
|
The following illustrations show the vertical bar graphs. All of the illustrations were done without 2.5D depth applied (i.e., DepthRadius = 0). |
|
Vertical Clustered Bars (GraphType=17): Side by side groups of bars. The standard type of two-dimensional bar chart. |
|
|
Vertical Stacked Bars (GraphType=18): Stacked groups of bars. Each stack is comprised of all series in this group, added up to get a total. The axis is the total value of the cumulative points. |
|
|
Vertical Dual-Axis Clustered Bars (GraphType=19): Also called a Dual-Y chart. Any series can be assigned to either of the two axis. |
|
|
Vertical Dual-Axis Stacked Bars (GraphType=20): Also called a Dual-Y stacked chart. Separate stacks will be created for the data on each of the two axis. |
|
|
Vertical Bi-Polar Clustered Bars (GraphType=21): A Dual-Y chart with the two axis physically split into separate sections, so that each can be seen independently of the other. |
|
|
Vertical Bi-Polar Stacked Bars (GraphType=22): A Stacked Dual-Y chart with the two axis physically split into separate sections, so that each can be seen independently of the other. |
|
|
Vertical Percent Bars (GraphType=23): A bar version of a pie chart. Each group calculates the percent of the total required for each series. The axis goes from 0 to 100%. |
|
|
The following illustrations show the horizontal bar graphs. All of the illustrations were done without 2.5D depth applied (i.e., DepthRadius = 0). |
|
Horizontal Clustered Bars (GraphType=24): Side by side groups of bars. The standard type of two-dimensional bar chart. |
|
|
Horizontal Stacked Bars (GraphType=25): Stacked groups of bars. Each stack is comprised of all series in this group, added up to get a total. The axis is the total value of the cumulative points. |
|
|
Horizontal Dual-Axis Clustered Bars (GraphType=26): Also called a Dual-Y chart. Any series can be assigned to either of the two axis. |
|
|
Horizontal Dual-Axis Stacked Bars (GraphType=27): Also called a Dual-Y stacked chart. Separate stacks will be created for the data on each of the two axis. |
|
|
Horizontal Bi-Polar Clustered Bars (GraphType=28): A Dual-Y chart with the two axis physically split into separate sections, so that each can be seen independently of the other. |
|
|
Horizontal Bi-Polar Stacked Bars (GraphType=29): A Stacked Dual-Y chart with the two axis physically split into separate sections, so that each can be seen independently of the other. |
|
|
Horizontal Percent Bars (GraphType=30): A bar version of a pie chart. Each group calculates the percent of the total required for each series. The axis goes from 0 to 100%. |
|
|
The following illustrations show the vertical area graphs. All of the illustrations were done without 2.5D depth applied (i.e., DepthRadius = 0). |
|
Vertical Absolute Area (GraphType=31): Areas draw on top of each other to show the absolute relationships between data series. Use when some data "pokes up" behind other. |
|
|
Vertical Stacked Area (GraphType=32): Areas stack on top of each other. The axis is the cumulative total of all the groups. |
|
|
Vertical Bi-Polar Absolute Area (GraphType=33): A Dual-Y chart with the two axis physically split into separate sections, so that each can be seen independently of the other. |
|
|
Vertical Bi-Polar Stacked Area (GraphType=34): A Stacked Dual-Y chart with the two axis physically split into separate sections, so that each can be seen independently of the other. |
|
|
Vertical Percent Area (GraphType=35): An area version of a pie chart. Each group calculates the percent of the total required for each series. The axis goes from 0 to 100%. |
|
|
The following illustrations show the horizontal area graphs. All of the illustrations were done without 2.5D depth applied (i.e., DepthRadius = 0). |
|
Horizontal Absolute Area (GraphType=36): Areas draw on top of each other to show the absolute relationships between data series. Use when some data "pokes up" behind other. |
|
|
Horizontal Stacked Area (GraphType=37): Areas stack on top of each other. The axis is the cumulative total of all the groups. |
|
|
Horizontal Bi-Polar Absolute Area (GraphType=38): A Dual-Y chart with the two axis physically split into separate sections, so that each can be seen independently of the other. |
|
|
Horizontal Bi-Polar Stacked Area (GraphType=39): A Stacked Dual-Y chart with the two axis physically split into separate sections, so that each can be seen independently of the other. |
|
|
Horizontal Percent Area (GraphType=40): An area version of a pie chart. Each group calculates the percent of the total required for each series. The axis goes from 0 to 100%. |
|
Vertical Absolute Line (GraphType=41): Lines draw on top and under each other to show the absolute relationships between data series. |
|
Vertical Stacked Line (GraphType=42): Lines stack on top of each other. The axis is the cumulative total of all the groups. |
|
Vertical Dual-Axis Absolute Line (GraphType=43): Also called a Dual-Y line chart. Any series can be assigned to either of the two axis. |
|
Vertical Dual-Axis Stacked Line (GraphType=44): Also called a Dual-Y stacked line chart. Separate stacks will be created for the data on each of the two axis. |
|
Vertical Bi-Polar Absolute Line (GraphType=45): A Dual-Y chart with the two axis physically split into separate sections, so that each can be seen independently of the other. |
|
Vertical Bi-Polar Stacked Line (GraphType=46): A Stacked Dual-Y chart with the two axis physically split into separate sections, so that each can be seen independently of the other. |
|
Vertical Percent Line (GraphType=47): A line version of a pie chart. Each group calculates the percent of the total required for each series. The axis goes from 0 to 100%. |
|
Horizontal Absolute Line (GraphType=48): Lines draw on top and under each other to show the absolute relationships between data series. |
|
Horizontal Stacked Line (GraphType=49): Lines stack on top of each other. The axis is the cumulative total of all the groups. |
|
Horizontal Dual-Axis Absolute Line (GraphType=50): Also called a Dual-Y line chart. Any series can be assigned to either of the two axis. |
|
Horizontal Dual-Axis Stacked Line (GraphType=51): Also called a Dual-Y stacked line chart. Separate stacks will be created for the data on each of the two axis. |
|
Horizontal Bi-Polar Absolute Line (GraphType=52): A Dual-Y chart with the two axis physically split into separate sections, so that each can be seen independently of the other. |
|
Horizontal Bi-Polar Stacked Line (GraphType=53): A Stacked Dual-Y chart with the two axis physically split into separate sections, so that each can be seen independently of the other. |
|
Horizontal Percent Line (GraphType=54): A line version of a pie chart. Each group calculates the percent of the total required for each series. The axis goes from 0 to 100%. |
|
Pie (GraphType=55): The most widely used chart for displaying percentages of a total. |
|
Ring Pie (GraphType=56): A ring variant of a pie chart. The total of all slices is placed in the center. Very popular in Asian countries. |
|
Multi Pie (GraphType=57): A separate pie is drawn for each group in the data set. A pie variation on Percent Bars. |
|
Multi Ring Pie (GraphType=58): A separate ring pie is drawn for each group in the data set. |
|
Multi Proportional Pie (GraphType=59): Each pie is sized in proportion to its total across the entire data set. |
|
Multi Proportional Ring Pie (GraphType=60): Each ring pie is sized in proportion to its total across the entire data set. |
|
Pie-Bar Chart (GraphType=93) |
|
Ring Pie-Bar Chart (GraphType=94) |
|
|
The following illustrations show the scatter charts. All of the illustrations were done MarkerSizeDefault set to 90 and UseSeriesShapes set to True. |
|
XY Scatter (GraphType=61): TWO values per marker, X and Y, in that order. A standard X-Y plot. |
|
|
XY Scatter Dual-Axis (GraphType=62): Dual-Y scatter chart. TWO values per marker, X and Y, in that order. |
|
|
XY Scatter with Labels (GraphType=63): THREE values per maker, X, Y and text label, in that order. Each XY point is discreetly labeled. |
|
|
XY Scatter with Labels Dual-Axis (GraphType=64): A Dual-Y scatter chart with labeled markers. Requires THREE values per marker, X, Y, and text label, in that order. |
|
XY Polar (GraphType=65): A polar coordinate scatter chart. Requires TWO values per marker in the following order: X (degree) and Y (distance from the center). |
|
XY Polar Dual-Axis (GraphType=66): A Dual-Y polar coordinate scatter chart. Requires TWO values per marker in the following order: X (degree) and Y (distance from the center). |
|
Radar Line (GraphType=67): A circular line chart. Excellent for cyclical data, such as hourly or monthly figures. |
|
Radar Area (GraphType=68): A circular area chart. Excellent for comparisons or cyclical data sets. |
|
Radar Line Dual-Axis (GraphType=69): A Dual-Y variation on Radar Line. Excellent for two sets of cyclical data. |
|
Open-Hi-Lo-Close Candle Stock Chart (GraphType=70): Requires FOUR values per marker: Open, High, Low, and Close, in that order. |
|
Open-Hi-Lo-Close Candle Stock Chart with Volume (GraphType=71): Requires FIVE values per marker: Open, High, Low, Close and Volume. |
|
Candle Stock Hi-Lo Open-Close (GraphType=72): FOUR values per marker: Open, High, Low, and Close. A "Candle" financial equity chart. |
|
Stock Hi-Lo (GraphType=73): Requires TWO values per maker: High and Low, in that order. A standard financial equity chart. |
|
Stock Hi-Lo Dual-Axis (GraphType=74): Dual-Y HiLo chart. TWO values per marker: High and Low. |
|
Stock Hi-Lo Bi-Polar (GraphType=75): Dual-Y chart with axis split into separate sections. TWO values per marker: High and Low. |
|
Stock Hi-Lo Close (GraphType=76): THREE values per marker: High, Low and Close, in that order. A standard financial equity chart. |
|
Stock Hi-Lo Close Dual-Axis (GraphType=77): Dual-Y version of HiLoClose chart. Requires THREE values per marker: High, Low, and Close. |
|
Stock Hi-Lo Close Bi-Polar (GraphType=78): Dual-Y chart with axis split into separate sections. THREE values per marker: High, Low, and Close. |
|
Stock Hi-Lo Open-Close (GraphType=79): FOUR values per marker: Open, High, Low, and Close. A standard financial equity chart. |
|
Stock Hi-Lo Open-Close Dual-Axis (GraphType=80): Dual-Y version of OpenHiLoClose chart. FOUR values per marker: Open, High, Low, and Close. A standard financial equity chart. |
|
Stock Hi-Lo Open-Close Bi-Polar (GraphType=81): Dual-Y chart with two axis split into separate sections. FOUR values per marker: Open, High, Low, and Close. |
|
Stock Hi-Lo with Volume (GraphType=82): Display stock performance along with volume. Requires THREE values per marker: High, Low and Volume. |
|
Stock Hi-Lo Open-Close with Volume (GraphType=83): Display stock performance along with volume. Requires FIVE values per marker: Open, High, Low, Close, and Volume. |
|
Candle Stock Hi-Lo Open-Close with Volume (GraphType=84): Display "Candle" stock performance along with volume. FIVE values per marker: Open, High, Low, Close, and Volume. |
|
Stock Hi-Lo Close with Volume (GraphType=88): Display stock performance along with volume. Requires FOUR values per marker: High, Low, Close, and Volume. |
|
Vertical Histogram (GraphType=85): Standard histogram. Groups all of the data together and assigns it to "buckets" based on value. There are no series or groups in this chart type. |
|
Horizontal Histogram (GraphType=86): Groups all of the data together and assigns it to "buckets" based on value. There are no series or groups in this chart type. |
|
Spectral Map (GraphType=87): Row or column matrix of markers that are colored according to data values. |
|
Bubble Chart (GraphType=89): Three values per marker -- X, Y, and Z, in that order. An X-Y plot where marker size depends on Z. |
|
Bubble Chart with Labels (GraphType=90): Four values per marker -- X, Y, Z, and text label, in that order. An X-Y plot where marker size depends on Z, with labels. |
|
Bubble Chart Dual-Axis (GraphType=91): Three values per marker -- X, Y, and Z, in that order. An X-Y plot where marker size depends on Z. |
|
Bubble Chart with Labels Dual-Axis (GraphType=92): Four values per marker -- X, Y, Z, and text label, in that order. An X-Y plot where marker size depends on Z, with labels. |
|
|
The Viewing3DAnglePreset property selects an entry in a table of "preset" viewing angles for 3D graphs. It can be set to one of the following: |
||
|
-1 = |
Custom (as set by CubeViewerX/Y/Z, CubeWallThickX/Y/Z, etc.) |
|
|
0= |
Standard |
|
|
1= |
Tall and Skinny |
|
|
2= |
From the Top |
|
|
3= |
Distorted |
|
|
4= |
Short and Fat |
|
|
5= |
Groups Eye |
|
|
6= |
Group Emphasis |
|
|
7= |
Few Series |
|
|
8= |
Few Groups |
|
|
9= |
Distorted Standard |
|
|
10= |
Shorter and Fatter |
|
|
11= |
Thick Wall for Series |
|
|
12= |
Thick Wall Standard |
|
|
13= |
California Special |
|
|
14= |
Blast-O-Vision |
|
|
15= |
|
|
Standard: setViewing3DAnglePreset(0); |
|
||
Tall and Skinny: setViewing3DAnglePreset(1); |
|
||
From the Top: setViewing3DAnglePreset(2); |
|
||
Distorted: setViewing3DAnglePreset(3); |
|
||
Short and Fat: setViewing3DAnglePreset(4); |
|
||
Group's Eye: setViewing3DAnglePreset(5); |
|
||
Group Emphasis: setViewing3DAnglePreset(6); |
|
||
Few Series: setViewing3DAnglePreset(7); |
|
||
Few Groups: setViewing3DAnglePreset(8); |
|
||
Distorted Standard: setViewing3DAnglePreset(9); |
|
||
Shorter and Fatter: setViewing3DAnglePreset(10); |
|
||
Thick Wall for Series: setViewing3DAnglePreset(11); |
|
||
Thick Wall Standard: setViewing3DAnglePreset(12); |
|
||
California Special: setViewing3DAnglePreset(13); |
|
||
Blast-O-Vision: setViewing3DAnglePreset(14); |
|
||
setViewing3DAnglePreset(15); |
|