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

  Using the "Make a chart" dialogs in the Entrance "Charts" menu makes it
  easy to create PLOT scripts.

PLOT Syntax

  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 [X | Y] minimum maximum increment]
        [ZEROBASED]                              
        [[HORIZONTAL | VERTICAL] GRIDLINES]    
        [TITLE [LEFT | RIGHT | CENTER] "string"] ...
        [NOTE [LEFT | RIGHT | CENTER] "string"] ...
        [COMMENT [LEFT | RIGHT | CENTER] "string"] ...
        [TITLE Y "string"]
        [TITLE X "string"]
        [FORMAT [X | Y] {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]
        [FOREGROUND color]
        [BACKGROUND color]
        [[NO] SIDES]
        [[NO] COLLAR]
        [[NO] YAXIS]
        [[NO] XAXIS]
        [[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)"]
        
  SELECT 
     (MySQL select statement body);

CHART SERIES TYPES
      [color]  BAR
      [color]  AREA
      [color]  [line_type] [line_width] LINE
      [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 

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

URL:  http://dbentrance.com/docs/plotsyntnax.html

Example:

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

URL:  http://dbentrance.com/docs/plotsyntax.html
