Chart
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 |
| 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"). |
