DB2 graphic QMF Version 8

Overview

You can display query results in a graphical format using Lotus 1-2-3 or Microsoft Excel for charting, or view them in a browser.

The Java charting component is installed with QMF for Windows; however, you need to install the Microsoft Excel or Lotus 1-2-3 application separately to display charts. You can use the charting application to further customize your chart after it is created by QMF for Windows.

Charts have a standard set of characteristics, regardless of the application used to create and display them:

Labels can be defined for the X- and Y-axes to describe the plotted values. A legend is displayed on the side of the chart. It contains the column headings for each column plotted on the Y-axis. A chart title displays above the chart.

Charting rules

The following conditions apply when creating charts from query results or from a report:

  1. If the query results or report used to create the chart contains group or break columns, the columns will appear on the X-axis of the chart; otherwise, the first column on the left appears on the X-axis.
  2. The remaining columns with numeric data types appear on the Y-axis.

Table 37. Chart elements
Category axis columns Value axis columns Legend Title
Query Results All group columns.

If there are none, use the first column.

All remaining numeric columns Value axis column headings Value specified on the Chart Options dialog box
Report All BREAK or GROUP columns.

If there are none, use the first column.

All remaining numeric columns Value axis column names FORM.PAGE heading text or the value specified on the Chart Options dialog box


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004