Database Toolbox

X Labels, Y Labels, and Z Labels

1. In the VQB Charting dialog box, after selecting the type of chart and data fields, select the X labels, Y labels, and Z labels. The axis labels you select must be strings.

To select more than one item in a list, hold down the Ctrl key or Shift key while selecting.

If you select Use Field Names, the field names will appear as the labels instead of the actual values.

2. After selecting the labels, the preview of that chart updates to reflect the selections.
3. Next, check the Show Legend checkbox if you want to add a legend to the chart.

See Also.   

• VQB Charting dialog box
• Visual Query Builder Dialog Box

Show Legend

1. In the VQB Charting dialog box, after selecting the X Labels, Y Labels, and Z Labels, check the Show legend checkbox to add a legend to the chart, which maps colors used in the plot to the data they represent.

The items in Legend labels become available for you to select from.

Select the label you want to appear in the legend from the Legend labels listbox. If you select Use Field Names, the field names instead of the actual values appear as the labels.

A legend appears in preview area of the chart.

2. Next, click Display to view the chart. For more information, see Display the Chart.

Th example below shows the legend using Y Data Field Names for the plot of sales volume over three months (Y Data) by product (X Data).

See Also.   

• VQB Charting dialog box
• Visual Query Builder Dialog Box

Aggregate Column Data

Preview the Chart