DB2 graphic  QMF Version 8

Displaying data using charts

QMF Visionary provides charts for SQL data allow you to display trends, compare different categories of items, to compare one trend with another, or to compare the various parts of an entire revenue or expenditure category.

Table 2. QMF Visionary charts
Layout and Icon Palette Description
Candlestick chart
Layouts Displays gains and losses in stock prices, or other value-based indexes, and volumes over time. The x-axis represents time, and two y-axes represent price and volume. The color of the candlestick shows either gain or loss: typically, green for gain and red for loss.
Scatter chart
Layouts Displays data in a two-dimensional graph in rectangular coordinates. You can use the scatter chart for statistical analyses, such as correlation studies.
Stock chart
Layouts Displays fluctuations in stock prices, or other value-based indexes, and volumes over time. The x-axis represents time, and two y-axes represent price and volume.
Timeline chart
Layouts Displays a time series. The x-axis is a date-based axis, and the y-axis can be assigned to a numeric value. You can use the timeline chart to show a trend among data values returned in a sorted order by date.
XY chart
Layouts Displays data in a two-dimensional graph; data points are connected by a line, in the order the data was retrieved. You can use XY charts to show correlations between two variables and trends in these correlations.
Multivariate chart
Layouts Displays several scatter charts in a grid. You can use the multivariate chart to analyze three or more independent variables.
Bar chart
Layouts Displays horizontal columns, or bars, to represent values measured on the x-axis that correspond to categories displayed on the y-axis. You can use bar charts to analyze trends over time or to compare quantities of different items.
Bar3D chart
ActiveX Controls Displays horizontal columns, or bars, to represent values measured on the x-axis that correspond to categories displayed on the y-axis. You can use bar charts to analyze trends over time or to compare quantities of different items.
Column chart
Layouts Displays vertical columns, or bars, to represent values measured on the y-axis that correspond to categories displayed on the x-axis. You can use column charts to analyze trends over time or to compare quantities of different items.
Column3D chart
ActiveX Controls Displays vertical columns, or bars, to represent values measured on the y-axis that correspond to categories displayed on the x-axis. You can use column charts to analyze trends over time or to compare quantities of different items.
Pie chart
Layouts Displays a circle cut into wedges; each wedge represents one row returned from a query. You can use the pie chart to examine shares or percentages of a whole.
Pie3D chart
ActiveX Controls Displays a circle cut into wedges; each wedge represents one row returned from a query. You can use the pie chart to examine shares or percentages of a whole.
Pie3DSmooth chart
ActiveX Controls Displays a circle cut into wedges; each wedge represents one row returned from a query. You can use the pie chart to examine shares or percentages of a whole.
Area3D chart
ActiveX Controls Displays areas that begin from the bottom of the chart with drops in the area. You can use Area 3D charts for examining change over time.
Oblique3D chart
ActiveX Controls Displays one or more vertical bars along a labeled axis with one or more planes.
Torus3D chart
ActiveX Controls Displays data in a 3D chart in the shape of a doughnut. Each piece of the torus represents one data point. You can use the torus chart to examine shares or percentages of a whole.
Ribbon3D chart
ActiveX Controls Displays one or more horizontal ribbons along a labeled axis with drops in the ribbons.
Point3D chart
ActiveX Controls Displays data values as points in the chart.
Surface3D chart
ActiveX Controls Displays a surface that connects adjacent data values.
Bubble 3D chart
ActiveX Controls Displays data as bubbles in the chart. The size of the bubble is determined by a data value.
StackBar 3D chart
ActiveX Controls Displays one or more horizontal bars that consist of stacked data values.
StackColumn 3D chart
ActiveX Controls Displays one or more vertical bars that consist of stacked data values.
StackLine 3D
chart
ActiveX Controls Displays one or more horizontal ribbons that consist of stacked data values.
StackArea 3D chart
ActiveX Controls Displays an area that consists of stacked data values.
Stock 3D chart
ActiveX Controls Displays one or more vertical bars on a labeled axis. The stock 3D chart shows open, high, low, close, trading volume, and trading data for a stock.
FloatBar 3D chart
ActiveX Controls Displays floating horizontal bars. This chart displays time ranges and is useful for creating charts on schedules.
Radar chart
ActiveX Controls Displays multi-series data points in a radar screen format.
Polar chart
ActiveX Controls Displays data points in a 360-degree radar screen format.
Shmoo 3D chart
ActiveX Controls Displays multi-series data in a cube-like format. Each cell of the cube is tested to determine if it passes a given condition. Pass and fail cells are color coded. The first set of failed cells can be highlighted.
Legend 3D
ActiveX Controls Displays a legend in a 3D format. The legend can display multiple rows and columns with different mark shapes and controlled legend cell size.

In addition to these layouts, you can also create comparisons by adding layers to some 2-D layouts. Layers are additional data templates added to a single layout: for example, an XY chart with more than one line representing more than one set of query results. For more details on layers, see Using layers in a layout.


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