Where QMF report data appears on a chart

To understand how to present and label data in a chart, review where the report data appears in the chart.

Compare the report in Figure 1 and the bar chart in Figure 2 to see how QMF displays report data on a chart. Both were created using the default report form.

Figure 1. This report shows employee data.
       ID  NAME        DEPT  JOB  YEARS  SALARY        COMM
   ------  ---------  ----- ----- ------ ----------  ----------
      120  NAUGHTON     38  CLERK   -    12954.75      180.00
      180  ABRAHAMS     38  CLERK   3    12009.75      236.50
       40  O'BRIEN      38  SALES   6    18006.00      846.55
       60  QUIGLEY      38  SALES   -    16808.30      650.25
      130  YAMAGUCHI    42  CLERK   6    10505.90       75.60
      200  SCOUTTEN     42  CLERK   -    11508.60       84.20
       90  KOONITZ      42  SALES   6    18001.75     1386.70
      230  LUNDQUIST    51  CLERK   3    13369.80      189.65
      250  WHEELER      51  CLERK   6    14460.00      513.30
      220  SMITH        51  SALES   7    17654.50      992.80
      150  WILLIAMS     51  SALES   6    19456.50      637.65
Figure 2. This bar chart shows the same employee data as the report.
This figure depicts the same report data as shown in the figure above, but graphically as a bar chart. The key for the chart depicts the COMM, SALARY, YEARS and DEPT column data in different colors. The X-axis of the chart shows employee ID numbers and the Y-axis shows salary amounts in increments of 5,000. Each employee has two bars: one for the amount of salary, and one for the commission amount.

You specify the following parts of a chart using a QMF form:

  • Chart heading
  • X-axis
  • X-axis data labels
  • Y-axis
  • Y-axis data labels
  • Legend

The following table shows the correspondence between report and chart data.

Table 1. Where report data appears on a chart
This part of the report: Corresponds to this part of the chart:
Report heading Chart heading
First (left-most) column of the report. If you define a GROUP or BREAK column, the data in that column appears on the X-axis X-axis data
Values in the left-most column, or the GROUP or BREAK column X-axis data labels
Remaining numeric columns Y-axis data
Values in the remaining numeric columns Y-axis data labels
Column headings for the Y-axis data Legend