16.20 - Creating a Chart - Teradata SQL Assistant

Teradata® SQL Assistant for Windows User Guide

Product
Teradata SQL Assistant
Release Number
16.20
Published
October 2018
Language
English (United States)
Last Update
2020-01-03
dita:mapPath
gfk1537201040714.ditamap
dita:ditavalPath
ft:empty
  1. Do one of the following:
    • Click .
    • Right-click in the Answer window and click Chart ....
  2. In the Chart Definition dialog, select the Chart Type you want to display.
  3. Enter or verify the From / To Row number for the rows to be plotted.
  4. Select or verify the Column(s) whose data you want to chart.
  5. Select or enter any additional options for the chart, then click OK.
    Option Description
    Chart Type Select the type of chart you want to create. The picture below shows a simple example. The default is a line chart.
    Horizontal

    Draw Horizontal bars rather than vertical Columns. Used for Bar types only.

    The default is cleared.

    Rectangular

    Draw rectangular bars rather than cylindrical bars. Used for Bar types only.

    The default is cleared.

    3D

    Draw a 3D chart. The default is selected.

    A chart can also be changed to 2D by changing its rotation and elevation

    From Row

    This specifies the first row to be included in the data range to be plotted.

    This value is pre-populated if a block of cells is currently selected.

    To Row

    This specifies the last row to be included in the data range to be plotted.

    This value is pre-populated if a block of cells is currently selected.

    X Axis Labels

    This column provides the data labels for the X Axis.

    Select <RowNumber> to use the row number instead of a data column.

    Data Columns

    Select one or more numeric columns whose data you wish to chart.

    Only one column can be selected if the Chart Type is Pie.

    The highlighted columns are pre-selected if a block of cells is currently selected.

    X Axis Title If entered, this text appears below the X axis labels
    Y Axis Title If entered, this text appears to the left of the Y axis labels.
    Chart Title If entered, this text appears above the chart.
    Display Chart in a new window

    Select this box to display the chart in a new window.

    The default is checked if the Answerset Mode is Each Resultset. Otherwise, it is cleared.