Appendix A
Gallery of Graph Types and
3D Preset Viewing Angles


 

This appendix describes:

 

Graph Types

 

3D Preset Viewing Angles

GRAPH TYPES

 

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 Graphs

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.

Vertical Bar Graphs

 

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%.

Horizontal Bar Graphs

 

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%.

Vertical Area Graphs

 

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%.

Horizontal Area Graphs

 

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 Line Charts

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 Line Charts

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 Charts

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)

Scatter Charts

 

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.

Polar Charts

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 Charts

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.

Stock Charts

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.

Histogram Charts

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

Spectral Map (GraphType=87): Row or column matrix of markers that are colored according to data values.

Bubble Charts

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.

3D PRESET VIEWING ANGLES

 

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);