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:
Values of any data type, taken from one or more columns in the query results or report, are plotted along the X-axis.
Numeric values, that are taken from one or more columns in the query results, are plotted along the Y-axis.
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.
The following conditions apply when creating charts from query results or from a report:
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 |