Overview

To create a Chart within Andi, first select your data as described in Data Selection and then prepare your result data as shown in Data Preparation . These two articles help you prepare your data before attempting to create a chart. Once your data is prepared, use the following steps to quickly create a chart.

To use the samples provided, you must first create the included sample database as described in Andi Sample Database.

Chart Dialog

The Chart Dialog allows you to quickly select a chart type and then select the columns to use when creating a chart. Each Chart will have a unique input field(s) that can be used to create a chart. To start the wizard, click one of the icons as shown below, or right-click on the table data and use the Data Analysis menu items.

Create a Chart

Create a Pivot Chart

The Wizard will display common attributes that can be selected. Note that for a Pivot Chart, there will be an extra function selection that will determine the pivot column.

Column Types

There are three column types that are used when creating a chart.

Value - A number value: (for example) an amount. This value will correspond to the Y axis on the chart.
Category/X Axis - Used to group values by year, month, etc.. The category will be visible on the X axis of the chart. Charts which allow using numeric values for the category such as the XYLine Chart will have a label of X Axis to indicate a numeric category value.
Legend - The legend column displays under the category headings on the X axis and breaks the total value per category into smaller portions. An example showing Items for the legend column: Total amount spent on each item per month.

Option	Description
Chart Type	Displays the appropriate options required to create a specific chart
Chart Title	The title to be displayed that explains the completed chart
Display Legend	For charts such as Line and Bar, when you add a Legend column, this option chooses whether the legend values will be displayed below the X axis.
Display Tooltips	Allows you to place the mouse over a data selection on the chart and to see the related value.
Column Label / Column Name	Chooses the display values for the column names in the combo box selections. Label - The label value return by the database. An example would be the value returned when using an "as <name" statement for a column. Name - The actual name returned by the database
Plot Orientation	Vertical - Default value which displays chart in X (the horizontal axis) and Y (the vertical axis). Horizontal - rotates the orientation of the axis 90 degrees clockwise
Chart Specific Options	Data Point Shapes - Allows shapes to display for each data point Tick Marks - Change the number of tick marks shown on the y axis for XY charts Stacked View - Use a stacked representation 3D - Display the chart as a simulated 3D chart
Create Chart	Create the actual chart
Reset	Reset the chosen column names to unselected

Examples

To recreate the samples below, run the following SQL.

SELECT AMOUNT, SOLD_ON as MONTH, ITEM 
FROM ITEM_SALES
WHERE YEAR(SOLD_ON) = 2020

Now sort the columns in the result set by MONTH and then ITEM.

Now define the chart by:

Clicking the Chart Wizard button
Right click on the table and choose Data Analysis->Chart->Create

Creating Specific Charts

For examples of creating specific charts using the Andi sample database, try out the following articles.

Pie Chart
Bar Chart
Line Chart
XY Line Chart
Area Chart
Scatter Chart
Box and Whisker Chart