Making Charts

Using the Charts Menu

Click the image below to see a short video demonstrating how to make line charts using the Entrance Charts | Line Chart dialog (video only, no sound):

Notice how easy it is to experiment with different settings using the "Try It" button. Once you have something you like, click "OK" and you have an Entrance PLOT script for making the chart.

Writing PLOT Scripts From Scratch

The process is very simple. Write a SQL script the normal way, but add a PLOT keyword, and you have a chart:
PLOT
  AXISLABELS, ORANGE LINE
SELECT
  year, avg FROM cpi_annual;
You can embellish the basic script with things like legends, titles, and data labels using PLOT syntax. There are a few basic examples listed below and many more are on the Entrance blog. You can also use the Charts menu for help making a chart.

The Details

First, install Entrance and connect to a MySQL® database. then click the "New" button to open a script tab. Enter a script like the one above, and click the "Run" button. You should now have a chart. Use the "SQL" and "Results" tabs at the bottom of the screen to jump back and forth between the chart and script views.

Examples

Here are a few examples you can copy and use for templates. (Just keep in mind that the chart series listed in PLOT must matchup 1-to-1 with columns listed in SELECT)
PLOT
  ONLY 5 AXISLABELS, 
     DARK BLUE CIRCLE AND LINE
  WITH
    TITLE "Main Title"
    TITLE X "X Title"
    TITLE Y "Y Title"
    GRIDLINES
SELECT
  year, avg FROM cpi_annual
  WHERE year >= 1965
     AND year <= 1975;

PLOT
  AXISLABELS, LIGHT RED BAR
  WITH
    TITLE "Main Title"
    TITLE X "X Title"
    TITLE Y "Y Title"
SELECT
  year, avg FROM cpi_annual
  WHERE year >= 2000 
     AND year <= 2005;
PLOT
  AXISLABELS, LIGHT BLUE AREA
  WITH
    TITLE "Main Title"
    TITLE X "X Title"
    TITLE Y "Y Title"
SELECT
  year, avg FROM cpi_annual
    WHERE year <= 2008;
PLOT SCATTER
  X, DARK BUTTER CIRCLE
  with 
    SCALE Y -1 1 1
    TITLE "Title"
    TITLE X "X Title"
    TITLE Y "Y Title"
SELECT
  4 * x * COS(y * 2 * PI()),
     x * SIN(y * 2 * PI()) 
  FROM ref2;