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