- Run the query or procedure.
- Select Results--> Display Chart.
The Chart Options dialog box opens.
- Select the charting application from the Application drop-down
menu.
Supported applications include:
- Java
- Lotus 1-2-3, Version 97 or later
- Microsoft Excel, Version 7.0 or later
- Select the type of spreadsheet to create from the Type drop-down
menu.
Supported types include:
- Area
- Area (Stacked Percentage)
- Area (Stacked)
- Bar
- Bar (Stacked Percentage)
- Bar (Stacked)
- Column
- Column (Stacked Percentage)
- Column (Stacked)
- Line
- Line (Stacked Percentage)
- Line (Stacked)
- Line (Stacked) With Markers
- Line (With Markers)
- Pie
- Scatter
Note:
The Java chart application does not support all
available chart types. If you select an unsupported chart type,
the closest supported type will be substituted automatically.
- Select the source for the title of the chart. Select one of
the following options:
- Select the Report page heading radio button
if you are creating a chart from a report (not directly from the
query results). This option uses the report page heading as the
chart title, by default.
Note:
This option is not available if you are creating
a chart from the query results.
- Select the Text radio button to type the
text of the report title.
- Type a label in the Category (X) axis field.
This is the label for the horizontal axis on the report. This
setting will not affect which columns will appear on the Category
axis; all group or break columns will be used, or the first column
will be used if there are no group or break columns.
- Type a label in the Value (Y) axis field.
This is the label for the vertical axis on the report. This
setting does not affect which columns will appear on the Value axis;
all columns with a numeric data type that do not appear on the Category
axis will be used.
- Use the Left, Top, Width,
and Height fields to define the attributes
of the chart.
- In the Units drop-down list, select the
unit type to correspond with the chart dimensions.
Options are:
- Centimeters
- Inches
- Percentage of screen size
- Click OK.
The exported chart data displays in a browser or spreadsheet
application using the chart attributes defined here.