Overview
  PLOT is a SQL extension provided by Entrance for making charts.  SQL scripts
  containing PLOT commands can be run from the Entrance window or from the
  command line (using EntrancePlot).

  There is a "Five Minute Introduction" to PLOT scripting online here:
  http://dbentrance.com/blog_images/fivemin.pdf 

  If you prefer something more like a spreadsheet GUI, try the 
  "Make a chart" dialogs in the "Charts" menu 

PLOT Syntax (as of Entrance Version 1.4.1)

  PLOT [LINECHART | BARCHART | AREACHART | XYCHART | CORRELATION 
        | HISTOGRAM | ROTATEDBARCHART | PIE 
        | HIGHLOWCHART | CANDLESTICK | BURNDOWN 
        | TIMEYCHART | DATEYCHART | DATETIMEYCHART  
        | WHISKERSCHART 
        | BITMAPCHART | EARTHCHART 
        | COLORINGBOOK | USCOLORINGBOOK |
       (extended_chart_type) ]

    chart_series_type [, ...]

      [WITH]
        [SCALE (axis) {(min) (max) (incr) | LOG | LOG10 }]
        [ZEROBASED]                              

        [[HORIZONTAL | VERTICAL] GRIDLINES]    

        [TITLE [LEFT | RIGHT | CENTER] "string"] ...
        [TITLE (axis) "string"]

        [NOTE     [LEFT | RIGHT | CENTER] "string"] ...
        [COMMENT  [LEFT | RIGHT | CENTER] "string"] ...

        [FORMAT (axis) {AUTO | PLAIN | SCIENTIFIC | 
                        [DECIMAL] "(decimal format)" | "(date/time format)"]
        [LABELANGLE {0 | 90}]
        [[color] [line_type] [HORIZONTAL | VERTICAL] GRIDLINES]

        [FONT font_family font_style font_size]
        [TITLEFONT font_family font_style font_size]

        [FOREGROUND color]
        [BACKGROUND color]
        [FRAMECOLOR color]

        [[NO] SIDES]
        [[NO] COLLAR]

        [[NO] YAXIS]
        [[NO] XAXIS]
        [[NO] X2AXIS]
        [[NO] Y2AXIS]

        [[NO] LABELS (axis) [ON {TOP | BOTTOM | LEFT | RIGHT}]
        [[NO] TICKS (axis) [ON {TOP | BOTTOM | LEFT | RIGHT}]
        [[NO] AXISLINE (axis) [ON {TOP | BOTTOM | LEFT | RIGHT}]

        [[NO] LEGEND]

        [NO BITMAP | BITMAP "(PNG file name)"]
        [PAGEBITMAP "(PNG file name)"]

        [{COLOR | SIZE} OVERRIDE]
        [FRAME {TO FIT | left_x top_y right_x bottom_y}]
        [PAGE 0 0  right_x bottom_y]

        [BARWIDTH (integer 0 - 100)]     
        [BARSEPARATION (integer)]        
        [BAROVERLAP (0 or 1)]            

        [PALETTE [TRANSPARENT] {"Tango" | "Bright" | "Light" |
              "Very Light" | "Blue Shades" | "Red Shades" |
              "Gray Shades"}]

         [THROUGHNULLS]

         [PAGENAME "(name)"]

         [TRANSLUCENCE (integer 0-255)]
         [LAYERS "(path to directory)"]
         [VERSION "(version string)"]
        
  SELECT 
     (MySQL select statement body);

CHART SERIES TYPES
      [color]  BAR
      [color]  AREA
      [color]  STEPPEDAREA
      [color]  [line_type] [line_width] LINE
      [color]  [line_type] [line_width] STEPPEDLINE
      [color]  SWATH
      [color]  HIGH                            
      [color]  LOW                             
      [color]  OPEN       
      [color]  CLOSE       
      [color]  [marker_size] [marker_fill] marker_type [AND LINES]
      SKIP
      [ALL | ONLY (n) | AUTO] XLABELS 
      PIELABEL  
      PIEVALUE 
      DATALABELS [ABOVE | BELOW | LEFT | RIGHT | CENTERED]
      [color] [line_type] WHENLINES 
      LAYERNAME
      LAYER
      COLOR OVERRIDE  
      SIZE OVERRIDE 

AXIS
      X | Y | X2 | y2

MARKER SIZE
      TINY | DEFAULT | [[VERY] {BIG | SMALL}] 

MARKER FILL
       FILLED | UNFILLED | MASKED

MARKER TYPE
   BOX | CIRCLE | TRIANGLE | OTHERTRIANGLE | DIAMOND | HORTICK | 
      VERTICK | XSYMBOL | PLUS 

LINES
   DOTTED | DASHED | SOLID
   THIN | NORMAL | [VERY] THICK

COLORS
      [transparency_type]  [lightness] color_name

TRANSPARENCY TYPE
      [VERY] {TRANSPARENT | OPAQUE}

LIGHTNESS
       [VERY] {DARK | LIGHT}

COLOR NAME
      RED | GREEN | BLUE | YELLOW | CYAN | MAGENTA | WHITE | LIGHTGRAY | 
      GRAY   DARKGRAY | BLACK |  BUTTER | ORANGE | CHOCOLATE | CHAMELEON 
      | SKYBLUE | PLUM | SCARLETRED | ALUMINUM | CHARCOAL   RGB(r,g,b) 
      | RGB(r,g,b,a)

DATE/TIME FORMATS (Date-Y, Time-Y, DateTime-Y only)
          %Y   - four digit year
          %y   - two digit year
          %m   - month  (00-12)
          %b   - abbreviated month name (Jan-Dec)
          %d   - day of the month (00-31)
          %H - hours 00-23
          %i - minutes 00-59
          %S - seconds 00-59
          %s - seconds 00-59

Example:

PLOT
    AXISLABELS, RED LINE, BLUE LINE
  WITH
    TITLE "Sample Chart"
SELECT
    labels, value1, value2
  FROM
    myTable;

Related URLs:
  http://dbentrance.com/blog/ has tips and tricks
  http://dbentrance.com/docs/Colors.html has color examples
  http://dbentrance.com/blog_images/fivemin.pdf is a five minute introduction