Previous Topic

Next Topic

Book Contents

Book Index

Using the Charting window

The following diagram shows you the Charting window, and the different components of it.

Chart components

Building the Chart

To build the chart, use the tabs on the left:


This refreshes the chart data from the data source:

Saving a Chart

You can save your chart with File > Save, or the Save button on the toolbar. The chart will be saved to disk as a *.xcf (chart) file.

Once the chart has been saved, it will be visible in the Query Explorer. The Query Explorer provides a way of quickly seeing all the charts you have developed, and updating them with the current data. This is discussed more fully in Viewing Charts in the Query Explorer.

Commonly used charts can be defined as a Favorite.

Opening a Chart

You can open an existing chart with File > Open Chart for Viewing. The chart will be opened in the chart window in Locked mode. Locked mode is a safety mechanism to prevent you inadvertently making a change that affects the underlying data behind the chart. You will be able to make changes to the chart appearance, however you will not be able to Refresh the chart or change the Data Columns etc.

You can take the chart out of Locked mode with Chart > Locked.

Apply an existing Chart as a Template

This is a very powerful feature of AQT Charting. You can take any existing chart (xcf file) and apply it as a template to your current chart. This is done with File > Open Chart as Template.

To understand how this works, you should realize that an AQT chart consists of two parts:

When Open Chart as Template is used, AQT will open the selected chart and will apply the current data / query to that chart. Once you have developed a chart style, this allows you to apply that style to other charts.

Default Chart for a Table/Query

When you save the chart for a table or query, it will (by default) be saved with the name of the table/query. For instance, if you are charting table TEST.SALES_DETAILS, the default chart name will be test_sales_details.xcf.

The next time you chart the table, AQT will look for the default chart file. It is exists, AQT will apply that chart as a template to the existing table data.

This feature means that, once you have developed a chart for a table, the chart will automatically be re-displayed the next time you chart the table.

Advanced Query Tool
© 2023 Cardett Associates Ltd. All rights reserved.