XYChart (or Scatter)
Entrance XYCharts plot points based on values in X and Y columns:
PLOT ScatterChart
X,Y
SELECT
val1, val2 FROM myTable;
You can change the markers by replacing Y with a marker description:
PLOT ScatterChart
X, SMALL RED CIRCLES
SELECT
x, y FROM myTable;
Markers can be any of these types: BOX, CIRCLE, TRIANGLE, OTHERTRIANGLE, DIAMOND,
VERTICK, XSYMBOL, or PLUS. They can be any Entrance color, and they can be FILLED, UNFILLED or MASKED. (A “MASKED” marker is unfilled and hides what is behind it)
You can also set the size of markers to be TINY, SMALL, BIG, VERY SMALL, or VERY BIG.
Adding Data Labels
Use the keyword DATALABELS after the Y series to specify a column for datalabels:
PLOT SCATTER
X, FILLED BLUE TRIANGLE, DATALABELS
WITH
SCALE X 0 5 1
SCALE Y 0 4 1
SELECT
xval, yval, label FROM myTable;
You can also specify where to draw labels in relation to their data points: DATALABELS ABOVE, DATALABELS BELOW, DATALABELS RIGHT, DATALABELS LEFT or DATALABELS CENTERED.
Setting Scales
Set the scale of the X or Y axis using SCALE:
SCALE X (min) (max) (increment)
SCALE Y (min) (max) (increment)
Change the format of labels on an axis using FORMAT:
FORMAT X (format)
FORMAT Y (format)
where (format) is PLAIN, SCIENTIFIC, or DECIMAL “(decimal format)”. Decimal formats can be any of the formats supported by the Java class DecimalFormat. The details are here. Use 0 for a digit, # for an optional digit, and ‘.’ to place the decimal point. For example: “$###,###.00” formats values up to $999,999.00” as US currency.
Use chart FRAME to change the location of the chart on the current page in screen coordinates::
FRAME (min x) (min y) (max x) (max y)
Copyright (c) 2008 dbEntrance Software, All Rights Reserved
MySQL is a registered trademark of MySQL AB in the United States, the European Union and other countries.
Java is a trademark or registered trademarks of Sun Microsystems, Inc. in the U.S. and other countries.
