Chart allows you to define your own SQL query to determine the charts that you would like to generate, ranging from a number of graph types.


Figure 1: Chart Properties

NameDescription

Chart Type

  • Area Chart
  • Bar Chart
  • Bubble Chart
  • Candlestick Chart
  • Donut Chart
  • Line Chart
  • Open High Low Close Chart (OHLC Chart) 
  • Pie Chart
  • XY Chart
Chart TitleChart Title to be displayed as part of the generated graph.
Data Binder

When Datasource is set to "Using Data Binder", this option will show up.

Please see Datalist Binder for the available binder to use.


Figure 2: Chart Properties - Data Binder & Chart Data Mapping

NameDescription

Order By

Column to be sorted in the graph dataset. This would affect how the graph is plotted.
Order
  • ASC
  • DESC
X-axis Value

X-axis label. 

Y-axis ValuesY-axis dataset.
Date Data Format

Date Data Format


Figure 3 : Chart Properties - Chart Options

NameDescription

X-axis Label

X-axis Label 

X-axis display as
  • Category
  • Number
  • Date
Y-axis Label

Y-axis Label 

Y-axis PrefixY-axis Prefix
Show Legend?If checked, the legend will be shown in the generated graph.
Width (px)

Width in character.

640px
Height (px)

Height in character.

480px
Colors

Series color. Optional field.

Comma-separated values (CSV) of color codes.

Example:

 #3333FF,#66FF00,#FF9933,#990000

red,orange,yellow,green,blue,indigo

http://stackoverflow.com/questions/18332440/what-are-the-jqplot-default-series-colors

Alignment
  • Left
  • Center
  • Right
Margin Bottom

Bottom Margin of Chart 

10px