How to make a chart
The Entrance PLOT command makes it possible to draw charts from SQL scripts.  The select part of the command can be any SQL select statement.  You specify series types, colors and so on in the plot part.  These series types in the plot part should match up 1-to-1 with columns in the select part.  
 
Here are are some examples (there are more in the download charts.zip)
 
 
 
 
plot linechart
       xlabels, normal blue line
  with
      comment ""
      comment left "   Consumer Price Index, 1913-2006"
select
      year, average from CPI
      where  year < 2007;
 
 
      
 
 
 
 
 
 
 
 
 
plot rotatedbarchart
   xlabels,  transparent light red bars
  with
    title x "Population (millions)"
    vertical gridlines
    barwidth 0.85
select
  name, population/1000000 from country
  order by population desc
  limit 10;
 
 
 
          
 
 
 
 
 
 
 
 
plot
     very light blue area, light blue line, xlabels
select
     average, average, year from CPI
     where  1949 < year and year < 1980;
 
 
  
 
 
 
 
 
 
plot scatter
    x, filled magenta circle
with
    gridlines
select x,y
    from table1;
 
 
 
 
 
 
 
 
 
 
 
PLOT Syntax
 
  PLOT [LINECHART | BARCHART | AREACHART | XYCHART | CORRELATION
        | HISTOGRAM | ROTATEDBARCHART | PIE | HIGHLOWCHART | TIMEYCHART
        | DATEYCHART | DATETIMEYCHART | WHISKERSCHART | (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"] ...
        [COMMENTZ¬ZZZ [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]
        [{COLOR | SIZE} OVERRIDE]
        [FRAME {TO FIT | left_x top_y right_x bottom_y}]
  SELECT
     (MySQL select statement body);
 
More details about the syntax are online here: http://dbentrance.com/plotsytnax.html  Use Help | PLOT to display the syntax from within Entrance.
 
The Charts Menu
Use the Charts Menu to quickly make a chart  when you have a table displayed:
 
 
 
 
 
 
Copyright (c) 2008 Tod Landis, All Rights Reserved
 
MySQL is a registered trademark of MySQL AB in the United States, the European Union and other countries.  
 
 
 
Click here for more info about Entrance:  http://dbentrance.com/