Chart

Methods
ASPdbUserChart
AspdbSendTemplate

Properties
dbMagicLayout, dbUserChartData

Select a Tab !


General - DataSet

This tab is the most important tab as it defines the data for the graph. Data can be either extracted from database, URL text file or entered manually.

Chart Type Select from the 30 chart types.
Width / Height Size of chart. The size will not affect the response time becasue chartis generated locally vai java applet.
Start, Interval, Stop User can choose from which point to start, the interval and which point to stop from a series of points to be plotted.  This feature is often needed by seldom found in any charting package.
Chart Def Font This global default font applies to those text not defined locally.
Title / Font / Color Chart title and attributes.
SubTitle / Font / Color Chart sub-title and attributes. Sub title is directly below the main title.
Session Var The name of session var that holds the entire chart and used by template, mail or response.write.
User Data Activate dbASPdbUserChart method and bypass the database data.
Test Chart
Checking this box will produce a response.write to display the chart. When layout object is in action, the display will be turned off within the module.
Disable Chart If checked then dbMagicLayout will not be generated hence chart will not be displayed. This is like a temporary switch to turn off the Chart.
Other Attributes Any attributes not covered in the designer can be entered here directly.

Dataset

This tab is the most important tab as it defines the data for the graph. Data can be either extracted from database or entered directly.

Set # A total of 40 datasets (0-39) can be plotted.
Data Set Parameters Type of data. For example, an X-Y chart will have the X as a dataset and a corresponding Y as another dataset.

XV-xValue
YV-yValue
Y2-y2Values
XY-xyValues
DV-dateValues
NA-Name
LB-Labels
CO-Color
CS-Colors
IM-Image
LW-LineWidth
LF-LabelFont
LC-LabelColor
KU-Links
XU-xURL
YU-yURL
LU-URLLabels
DT-Type
URLDataBlock
URLXYDataRows
URLXYDataColumns
customDatasetHandler

DB COl # If data are to be extracted from a database this the field (Column) will be used as a dataset. All the displayed fields of numeric type will be load in this listbox. Only the beginning number will be extracted. Therefore, if there is a calculated field, the column index number can be entered here.
User Data List or URL If the data are from a user list or an URL then enter the list here. If a URL is to be entered here, it'll imply that the URL is an ascii file containing the list separated by commas. Example: http://address/data.txt
This button will build an entry in the property panel from the data. There is no need to erase the entries in the property panel for modifications, just made the changes and re-enter again. If the "Set #" and "DataSet Parameters" exists, it'll be replaced. Otherwise, a new entry will be created.

Charts - Dwell - Legend - Area

labelFormat Default, Comma, or European format
labelPrecision maximum number of places beyond the decimal point to display
labelFont Color for pie labels (default TimesRoman 12pt)
labelColor Color for pie labels (default black)
dataset0URLLabels a URL that returns a list of labels for dataset 0
legendLabelFont Font name, size, & style for legend (default TimesRoman, plain, 12 pt)
legendColor sets the background color of a legend
legendLabelColor color of text in legend (default black)
iconWidth width of legend icon (default 0.07)
iconHeight height of legend icon (default 0.05)
iconGap gap between icon and next legend entry (default 0.01)
LL-X X location of lower left legend corner (default 0.2)
LL-Y Y location of lower left legend corner (default 0.2)
legendOn make the legend visible
legendVertical legend icons in vertical list


Charts

This tab provide different options to control the appearance of various types of chart.

Line & Regression

plotLinesOff plot lines are invisible
dataset0Image a dataset parameter currently only used by Line charts (default none)
labelsOn displays a data label at each point (default is not visible)
labelAngle rotates data labels to the specified angle

Bar

LabelsOn label each bar
Baseline bars ascend or descend from this value (default 0.0)
ClusterWidth relative width of a cluster of bars (default 0.8)
LabelAngle degrees to rotate bar labels (default 0)
target Target frame for hyperBar and hyperColumn drill-down results

Pie

explodeSlice slice number to explode (will not work with 3D)
textLabelsOn make string labels visible
valueLabelsOn make numeric labels visible
percentLabelsOff make percentage labels invisible
labelPosition 0: at center of slice, 1: at edge of slice, 2: outside edge of slice with pointer
startDegrees degrees counterclockwise from 3 o'clock for first slice
Center-X x Location for center of pie (between 0 & 1, default 0.5)
Center-Y y Location for center of pie (between 0 & 1, default 0.5)
Width % of window for pie diameter (default .6 = 60%)
Height % of window for pie diameter (default .6 = 60%)
target Target frame for hyperPie drill-down results

Speedo

needleStyle Kind of needle (default 1) 0 = arrow, 1 = line, 2 = thick arrow, 3 = swept arc
speedoPosition 0 (default) is a mostly complete circle, 1 - 4 are semi circles in various positions, 5-8 are quarter circles in various positions
labelsOutside labels on the outside of the speedo
watermarkColor for hSpeedoApp, determines the color of the history watermark

Polar

manualSpoking If defined, you are responsible for determining how many "spokes" should be drawn in this chart's axis representation
numSpokes The number of spokes in this chart's Axis system (default 4)

Finance

splitWindow if true (default) each dataset type will be in a a separate window with an independent Y axis. The X axis will be shared among all dataset types.

Dwell - Area

lLabelsOn disables dwell popup labels (enabled by default)
lUseLabelString Use data labels in dwell popups (off by default)
lUseXValue Use X values in dwell popups (on by default)
UseYValue Use Y values in dwell popups (on by default)
XString A string containing the "#" character, which will be replaced with a data point's X value (default: "X: #")
YString A string containing the "#" character, which will be replaced with a data point's Y value (default: "Y: #")
LabelPrecision The maximum number of significant digits to display for non-whole numbers (default 2)
LabelFormat Type of number formatting for dwell labels (0 - none, 1 - comma formatting, 2 - European formatting, default 1)
Top Plotting area (0-1) - top
Left Plotting area (0-1) - bottom
Bottom Plotting area (0-1) - left
Right Plotting area (0-1) - right
Color color of plot area

Axis - Dates - effect

Axis
Note: When checking the Axes boolean values. Use an 'x' and you then have to leave the grid by placing the cursor away from the grid in order to register the entry.

noAutoScale Axis scale defined in applet parameters
rotateTitle "true" if vertical axis title should be parallel with axis
logScaling "true" if axis should use log scaling
lineOff axis line is invisible
tickOff major tick marks are invisible
minTickOn minor tick marks are visible
labelsOff axis labels are invisible
gridOn grid lines are visible
rightAxis this axis goes on the right (For Yaxisoption)
topAxis this axis goes on the top (for Xaxisoption)
AxisTitle Y Axis title
AxisTitleFont Y Axis title font
AxisTitleColor Y Axis title color
AxisLabels A comma separated list of user-defined labels for this Axis. This is only effective for certain types of chart (BarChart derivatives, LabelLineChart, Area charts) that use a LabelAxis. By default, LabelAxis is only used for X axes.
AxisLabelFont use this font for Y axis labels (default TimesRoman 12pt)
AxisLabelColor Y axis labels in this color (default black)
AxisLabelAngle label rotation in degrees (default 0). Note: rotations of 0 and 90 degrees will be the most readable
AxisLabelFormat (default 0) Note: by default, charts will automatically localize formats based on the Java Virtual Machine running the chart.
AxisLabelPrecision maximum number of digits past the decimal point to display
AxisLineColor Y axis line color (default black)
AxisTickColor Y axis tick mark color (default black)
AxisGridColor Y axis grid line color (default black)
AxisColor sets Y axis grids, ticks, lines and labels to the same color
AxisTickLength number of pixels long for Y axis tick marks
AxisMinTickLength number of pixels long for Y axis minor tick marks
AxisStart starting value on axis. By default, axes automatically determine a starting and ending value. By setting this value, you can give the axis a default minimum value. If the Axis is set to noAutoScale, this value will be used directly. Otherwise, this value may be adjusted slightly to yield better looking labels. For example, if you set yAxisStart to 0.01, the chart may decide to round the value down to 0.0 to create even axis increments.
AxisEnd ending value on axis. By default, axes automatically determine a starting and ending value. By setting this value, you can give the axis a default maximum value. If the Axis is set to noAutoScale, this value will be used directly. Otherwise, this value may be adjusted slightly to yield better looking labels. For example, if you set yAxisStart to 9.99, the chart may decide to round the value up to 10.0 to create even axis increments.
AxisLabelCount how many labels on a manually scaled axis
AxisTickCount how many tick marks on a manually scaled axis
AxisMinTickCount how many minor tick marks on a manually scaled axis
AxisGridCount how many grid lines on a manually scaled axis
Start Date time/date for axis starting value. Note: this string is passed into Java's "Date" class to be translated into a machine independent time stamp. Many time-stamp formats will work. If you need to use a specific input format, see the Date Format section below.
End Date time/date for axis ending value
Scale Type 1=scale by seconds  2=scale by minutes  3=scale by hours  4=scale by days
5=scale by weeks  6=scale by months  7=scale by years
Axis Date Format By default, DateAxis selects an appropriate labelling type based on your time range and your locale. Your applets will automatically use, for example, Japanese month names for browsers in Japan, and German month names for browsers in Germany. Similarly, applets might choose a yy/mm label for one locale, and mm/yy for another locale. This parameter lets you override the axis labels to use your specific formatting instructions. See the Date Format section below for more information on how to use the formatting patterns.
Axis Secondary Date Format Some DateAxes use a primary and secondary format to highlight important boundaries, like years or hours. This parameter lets you set the date or timestamp format for one of these boundaries. See the Date Format section below for more information on how to use the formatting patterns.
Reset ALL to default values

Dates - effect

startData Ignore any data earlier than this time/date. Note: this string is passed into Java's "Date" class to be translated into a machine independent time stamp. Many time-stamp formats will work. If you need to use a specific input format, see the Date Format section below.
endData Ignore any data later than this time/date. Note: this string is passed into Java's "Date" class to be translated into a machine independent time stamp. Many time-stamp formats will work. If you need to use a specific input format, see the Date Format section below.
inputDateFormat Use this pattern to read any incoming data. For more information on how to construct this string, see the Date Format section below.
incrementalDataURL A URL to poll for additional data points. Date oriented charts read initial data from the URL or file specified in "customDatasetHandler". Subsequent observations can be added to applets by polling the URL specified in this parameter. This URL will be checked each networkInterval.
ChartBGColor color of chart background (default white)
xDepth number of pixels of offset in X direction for 3D effect (default 15)
yDepth number of pixels of offset in y direction for 3D effect (default 15)
networkInterval Number of seconds to wait before re-reading URL datasets
delimiter the separator character for list parameters. Default is comma (e.g. "123.432.123").
BG Image URLImage Charts can replace the solid background color with a GIF or JPEG image for added effect.
3D turns on 3D effects for this chart (default 2D)
List Del the separator character for list parameters. Default is comma (e.g. "123.432.123").