The GRAPHTYPE attribute determines
the basic type of graph, be it Bar, Pie, Line or one of 18 others....
The GRAPHTYPE attribute is
used in conjunction with the GRAPHSTYLE atrtibute in order to determine
exactly how to draw the graph.
For each GRAPHTYPE, there
is a set of applicable GRAPHSTYLE values thus...
Area (2D)
0 Stacked (default)
1 Absolute
2 Stacked percentage
3 Stacked semi-logarithmic
4 Absolute semi-logarithmic
Area (3D)
0 Stacked (default)
1 Absolute
2 Stacked percentage
Bar (2D)
0 Vertical bars, clustered if multiple data sets (default)
1 Horizontal
2 Stacked
3 Horizontal stacked
4 Stacked percentage
5 Horizontal stacked percentage
8 Vertical stacked floating
9 Horizontal stacked floating
Note: Floating bars require more than one data set. The first data set
in a floating bar graph is invisible. The missing bottom element of
the stacked bar makes the bar appear to be suspended above the X axis,
hence the name "floating" bar graph.
10 Vertical Pareto
11 Horizontal Pareto
Note: With a Pareto graph, bars are sorted in descending order; any
attached user-defined X axis labels are sorted with the data. If there
is more than one data set, bars are sorted in groups such that the first
data set appears in descending order.
Bar (3D)
As for 2D bar, plus:
6 Z-clustered
7 Horizontal Z-clustered
Box-whisker
0 Raw data, samples drawn (default)
1 Raw data, no samples drawn
2 Parametric data
The following values may
be added to settings 0-2 and may be used in combination. For example,
to produce a graph with parametric data, no notch and a black border,
the setting would be:
Graph1.GraphStyle = 2 + 4
+ 32
+4 No notch
+8 No whisker
+16 No median line
+32 Black border
Note: Median lines are visible
with the black border option and when the marker's fill pattern is non-solid.
Bubble
No style options
Candlestick
No style options
Gantt
0 Adjacent bars (default)
1 Spaced bars
High-low-close and open-high-low-close
0 Open (if used), high, low, and close bars (default)
1 No open or close bars
2 No high or low bars
3 No bars of any kind
Line, log/lin, lin/log,
and log/log
0 Lines only (default)
1 Symbols
2 Sticks between points and Y origin
3 Sticks and symbols
4 Lines
5 Lines and symbols
6 Lines and sticks
7 Lines, sticks, and symbols
Pie (2D/3D)
0 Lines join labels to pie (default)
1 No label lines
2 Colored labels
3 Colored labels without lines
4 Percentage labels
5 Percentage labels without lines
6 Colored percentage labels
7 Colored percentage labels without lines
Polar
0 Lines only (default)
1 Symbols
2 Sticks between points and origin (center)
3 Sticks and symbols
4 Lines
5 Lines and symbols
6 Lines and sticks
7 Lines, sticks, and symbols
Scatter (2D)
0 Symbols only (default)
1 Curve only
2 Symbols only
3 Curve and symbols
Scatter (3D)
0 Symbols only (default)
1 Vertical sticks and symbols
2 Symbols and lines between points
3 Symbols, vertical sticks, and lines between points
Surface
0 Filled panels and boundary lines (default)
1 Boundary lines only
2 Filled panels only
3 Filled panels and boundary lines with side wall
4 Boundary lines only with side wall
5 Filled panels only with side wall
Tape
No style options