i

Gallery Property Pages

The first two tabs displayed on the Graph Property window are the 2D and 3D Gallery tabs. From these tabs you select the type of graph you want. Once you select a graph type, the Style tab displays any options available.

i

Pie Chart

The pie chart, one of the simplest graph types, consists of a circle (or pie) divided into two or more sections (slices). Pie charts show the proportion of parts to the whole. By labeling each pie slice with the quantity it represents, you can compare slices with each other, although not as effectively as you could with a bar graph or other graph type.

• A pie chart can graph only one data set, with each data point represented by a pie slice.
• You can draw any pie chart in either 2D or 3D form.

Pie-chart options are described in the following table.

Setting	Description
Off (default is off)	Select this option to draw a pie chart with no labels for the slices. Deselect it to draw labels.
Connecting Lines (default is on)	Select this option to draw connecting lines drawn between pie slices and their labels. Deselect it to remove connecting lines.
Colored as Slices (default is off)	Select this option to have pie labels drawn in the same colors as their corresponding slices. Deselect it to have every label drawn in a single color (black by default, or as specified on the Fonts Property tab).
% Data Values (default is off)	Select this option to have pie labels show the percentage values of their slices (relative to the whole). Deselect it to have labels show the actual values of their slices.

i

Polar Graph

The polar graph is a line graph drawn on a circular grid. The magnitude of the dependent variable is represented by the distance of the line from the center of the grid. Like logarithmic graphs, polar graphs are useful primarily in mathematical and statistical applications.

• The independent variable is charted on the angular axis, based on an origin (zero point) of 3 o'clock. The dependent variable is charted on the radial axis with the origin at the center of the circle.
• Polar graphs can chart multiple data sets, each represented by a single line, with any number of data points.
• The first data point is at an angle of 0 (3 o’clock), with subsequent points at increments of 360 (degrees) divided by the total number of points.

Polar graph options are described in the following table.

Setting	Description
Symbols (default is off)	Select this option to draw a symbol at the position of each data point. Deselect it to remove the symbols.
Lines (default is off)	Select this option to draw lines between data points. Deselect it to remove the lines.
Sticks (default is off)	Select this option to draw a line from each data point to the origin. Deselect it to remove the lines.

i

2D Scatter Graph

The 2D scatter graph consists of plotted points "scattered" around an X-Y grid. The pattern may reveal a relationship between the two variables measured by the X and Y axes. You can illustrate trends in the plotted points by adding a curve. (See the Trends property section.)

• Scatter graphs can chart multiple data sets, each represented by a different symbol and having any number of data points.
• You can display scatter plots alone, curves alone, or both together. The combination is determined by your selections in the Style and Trends property tabs.

The only 2D scatter graph style setting is described below.

Setting	Description
Symbols (default is on)	This option matters only if you've enabled curve fitting for the graph in the Trends property page. In that case, select Symbols to draw symbols along with curves and deselect it to draw curves only. If you haven't enabled a curve, symbols are drawn in any case.

i

3D Scatter Graph

The 3D scatter graph consists of plotted points "scattered" around an X-Y-Z space. The pattern may reveal a relationship among the variables plotted on X, Y, and Z axes.

• Scatter graphs can chart multiple data sets, each represented by a different symbol and having any number of data points.
• The Graph Control automatically places points at increments of 1 on the X axis, starting at 0.
• You can emphasize the Y value of each plotted point by selecting the Sticks option in the Style property page.

The 3D scatter graph settings are described in the following table.

Setting	Description
Markers group	All 3D scatter graphs are drawn with symbols representing data points. In the Markers group, you can also enable vertical "sticks" for the graph.
Sticks (default is off)	Select this option to draw a vertical line between each data point and the Y origin plane. Deselect it to remove the sticks.

i

Line Graph

The line graph consists of one or more lines (or sequences of symbols) drawn on an X-Y grid. These graphs let you show trends in values over a continuous scale.

• In a line graph, the X axis usually represents an independent variable, which is most often a time scale. The Y axis usually shows a dependent variable, such as a quantity or percentage.
• In drawing a line graph, you can use any combination of lines, symbols, and vertical "sticks." You can choose this combination in the Style Property tab.
• In the Style Property tab, you can choose to show the X axis, Y axis, or both in a logarithmic scale--creating a lin/log, log/lin, or log/log graph. These graph types are used mainly in scientific and statistical applications.

Line graph settings are described in the following table.

Setting	Description
Symbols (default is off)	Select this option to draw a symbol at the position of each data point. Deselect it to remove the symbols.
Lines (default is off)	Select this option to draw lines between data points. Deselect it to remove the lines.
Sticks (default is off)	Select this option to draw a vertical "stick" between each data point and the Y origin. Deselect it to remove the sticks.
Y Axis (default is off)	Select this option for a logarithmic Y axis. If you select Y Axis and leave X Axis off, you'll get a log/lin graph; if you select both, you'll get a log/log graph.
X Axis (default is off)	Select this option for a logarithmic X axis. If you select X Axis and leave Y Axis off, you'll get a lin/log graph; if you select both, you'll get a log/log graph.

i

2D Bar Graph

A bar graph consists of two or more parallel bars of equal width drawn on an X-Y grid. Bar graphs compare amounts to each other. They can also suggest trends.

• 2D bar graphs are available in three styles: simple, stacked, and stacked percentage. You can choose a style on the Style Property tab.
• You can draw bars either vertically or horizontally. In the vertical format, viewers tend to attribute a left-to-right sequence to the bars, whether you intend one or not. To choose vertical or horizontal bars, go to the Style Property tab.

The 2D bar graph settings are described in the following table.

Setting	Description
Horizontal	Select this option for a graph with bars drawn horizontally.
Vertical (default)	Select this option for a graph with bars drawn vertically, which is sometimes called a column graph.
Simple (default)	Select this option to draw one bar per data point. If you have more than one data set, corresponding points from each set are shown as clustered bars.
Stacked	Select this option to divide bars into segments, showing multiple data sets at corresponding data points.
Stacked %	Select this option to divide bars into segments representing percentages of a whole. Each complete bar will be the same length, but the breakdown of segments will vary according to their percentages at each data point.

i

3D Bar Graph

A bar graph consists of two or more parallel bars of equal width drawn on an X-Y grid. Bar graphs compare amounts to each other. They can also suggest trends.

• 3D bar graphs are available in four styles: simple, stacked, stacked percentage, and z-clustered. You can choose this style on the Style Property tab.
• You can draw bars either vertically or horizontally. In the vertical format, viewers tend to attribute a left-to-right sequence to the bars, whether you intend one or not. Select vertical or horizontal bars on the Style Property tab.

The 3D bar graph settings are described in the following table.

Setting	Description
Horizontal	Select this option for a graph with bars drawn horizontally.
Vertical (default)	Select this option for a graph with bars drawn vertically, which is sometimes called a column graph.
Simple (default)	Select this option to draw one bar per data point. If you have more than one data set, corresponding points from each set are shown as clustered bars.
Stacked	Select this option to divide bars into segments, showing multiple data sets at corresponding data points.
Stacked %	Select this option to divide bars into segments representing percentages of a whole. Each complete bar will be the same length, but the breakdown of segments will vary according to their percentages at each data point.
Z-Clustered	Select this option to draw multiple sets of bars, one bar per data point, with subsequent sets drawn in front of previous ones. In this form, smaller bars may be hidden behind larger values.

i

Area Graph

An area graph consists of one or more lines drawn on an X-Y grid with the area between the line and the X axis filled in. Like line graphs, area graphs show trends in values but give greater emphasis to quantities.

• Area graphs are available in three forms: stacked, absolute, and stacked percentage. You can choose one of these forms on the Style Property tab.
• You can draw any area graphs in either 2D or 3D form.

Area graph settings are described in the following table.

Setting	Description
Stacked (default)	Select this option for stacked (cumulative) layers. Each data set is drawn on top of any previous ones.
Absolute	Select this option to draw each data set from the Y origin. This form is much more readable in 3D.
Stacked %	Select this option to draw each data set as a percentage of a whole.

i

Gantt Chart

The Gantt chart is a specialized version of the horizontal bar graph in simple or stacked form. It's used almost exclusively to show a project schedule, with each bar or bar segment marking the start time, duration, and completion time of a task.

• Depending on your needs, you can have each bar represent either a single task (one solid bar) or a sequence of tasks (stacked bar).
• Gantt charts are made up of at least two data sets. The first set contains the values for the start point of each bar, and subsequent sets contain the end points of each bar segment.
• Unlike bar graphs, Gantt charts are always drawn horizontally and only in 2D form.
• The Graph Control automatically places Gantt bars along the Y axis at increments of 1, starting at 1.
• In default form, Gantt chart bars are drawn with no spaces between them. You can add spaces if you choose. On the Style property tab, select the Spaced option.
• You can't show negative data points on a Gantt chart.

The Gantt chart style setting is described below.

Setting	Description
Spaced (default is off)	Select this option to place spaces between Gantt bars. Deselect it to draw all bars adjacent to each other.

ii

High-Low-Close Graph

The high-low-close (HLC) graph lets you chart a range of values on an X-Y grid. The range is shown as a vertical bar, with horizontal crossbars for the high, the low, and a normative value usually called the close. An alternate version, the open-high-low-close (OHLC) graph, adds a fourth crossbar for another normative value usually called the open.

• When you select the High-Low icon on the 2D Gallery property tab, you get an HLC graph. To get an OHLC graph, go to the Style property tab and select 'Open' Values.
• An HLC graph must have three data sets (high, low, and close values), and an OHLC graph must have four data sets (open, high, low, and close values). There's no limit on the number of data points you can graph, but each data set should have the same number.
• You can draw the graph without the open and close bars, without the high and low bars, or with no bars at all. These options are available in the Style property tab.

High-low-close graph settings are described in the following table.

Setting	Description
Data group	By default, a high-low-close graph charts three data sets: high values, low values, and closing values. In the Data group, you can enable a fourth data set for opening values, creating an open-high-low-close graph.
'Open' Values (default is off)	Select this option for an open-high-low-close graph. Deselect it for a high-low-close graph.
No High/Low Ticks (default is off)	Select this option to disable high and low ticks. Deselect it to show those ticks.
No Open/Close Ticks (default is off)	Select this option to disable open and close ticks. Deselect it to show those ticks.

i

Candlestick Graph

The candlestick graph is an alternative to the open-high-low-close graph. It consists of a series of boxes with lines extending up and down from the ends, drawn on an X-Y grid. The top and bottom of each box indicate the open and close values. If the open value is higher, the box is filled with a color; if the close value is higher, the box is filled with white. The ascending and descending lines indicate the high and low values for that point.

• The candlestick graph requires four data sets (open, high, low, and close values), each of which should have the same number of data points.
• No style settings are available.

i

Box-Whisker Graph

The box-whisker graph illustrates the spread of data groups around their medians, using a "box" and "whiskers" to break down each data group by percentile.

You can either specify the seven percentile parameters for each symbol (parametric data) or supply raw data for the Graph Control to process and graph.

• You need enough data sets to hold all the values making up each group (always at least seven sets). In drawing the graph, the Graph Control sorts the values for each group, then assigns the seven percentile positions (5, 10, 25, 50, 75, 90, or 95) to the values closest to those percentiles. For example, in a group of 20 values, the second value would be shown as the tenth percentile.
• You can add symbols to the graph showing each value. If a group contains duplicate values, only one symbol is shown at that position.
• The number of data points is the number of box-whisker symbols.

Box-whisker graph settings are described in the following table.

Setting	Description
Parametric Data	Select this option to specify the seven values making up the box-whisker graph.
Raw Data (default)	Select this option if you want the Graph Control to process a group of data and produce the seven values making up the box-whisker graph.
Show Samples (default is on)	Select this option to show the actual data values (samples) from which the box-whisker graph is produced, superimposed as symbols over the box-whisker graphics. Deselect it to remove the samples.

i

Bubble Graph

A bubble graph charts three variables in two dimensions. It's a special form of the scatter graph showing "bubbles," which are circular markers of variable size plotted on an X-Y grid. The size of each bubble is typically used to show the data point's relative importance, such as the percentage of gross sales it represents.

• In a bubble graph, all three variables are independent. You can choose which variable to show on the X axis, which to show on the Y axis, and which to show by the size of the bubble.
• You can't draw curves on a bubble graph.

i

Time-Series Graph

A time-series graph consists of a X-Y grid in which points are added one at a time to the right-hand edge. When the graph reaches the limit of points it can show, the oldest data begins to drop off the left edge.

• Time-series graphs can chart multiple data sets, each represented by a single sequence of symbols.
• Because time-series graphs represent continuous streams of data, they must be displayed on screen to show all the data. Printouts of time-series graphs can show only freeze-frames of the graph captured at particular times.

i

Tape Graph

The tape graph is a 3D form of the line graph. It gives you only one styling option—tapes—drawn between data points.

i

Surface Graph

The surface graph lets you represent data topographically in three dimensions. The graph uses an X-Z grid drawn at regular increments in the X and Z directions, with one Y value for each X-Z intersection. The color scale of the graph is automatically keyed to the height of points, helping the viewer differentiate between higher and lower values.

• A surface graph represents at least two data sets and usually more. Each data set holds the Y values of a row of points along the X axis. The first set applies to the row of points perpendicular to the Z origin (the "back" of the graph), and subsequent sets apply to additional rows.
• All panels of the surface graph (the rectangles formed by the X and Z grids) are colored according to their height. You specify the colors at the maximum and minimum points of the axis and the Graph Control interpolates colors between these points.
• In drawing a surface graph, you can use lines to show the edges of each panel, fill each panel with a solid color, or use both lines and fills. You can also add side walls to the front and right edges of the graph if you choose. All of these options are available in the Style property tab.

Surface graph style settings are described in the following table.

Setting	Description
Filled Panels (default is on)	Select this option to fill in the cells of a surface graph grid with panels of color. Deselect it to remove the panels. The color range of panels is determined by your settings in the Grade Color group.
Boundary Lines (default is on)	This option lets you draw lines along the edges of each cell of the surface graph grid. If Filled Panels is selected, select Boundary Lines to draw lines (which are always black); deselect it to remove the lines. If Filled Panels is deselected, lines are drawn in any case. Their color range is determined by the settings in the Grade Color group.
Min	Sets the color for the lowest point on the surface graph.
Max	Sets the color for the highest point on the surface graph.
On (default is off)	Select this option to draw side walls around the perimeter of the graph in the X and Z planes. Deselect it to remove the side walls.
Color	Sets the color for the side walls.

© 1996-1997 Microsoft Corporation. All rights reserved.