Vertical bar chart, multiple series
SQL source code for this example:
DRAW BARCHART WITH
ORIENTATION VERTICAL
AXIS BOTTOM
GRID HORIZONTAL
LEGEND TOP RIGHT INSIDE;
SELECT year AS series, isocode AS x, gdp AS y
FROM gdp_per_capita
WHERE year = "2010" OR year = '2009' or year = '2008'
ORDER BY gdp DESC
LIMIT 9;
DRAW BARCHART WITH
ORIENTATION VERTICAL
AXIS BOTTOM
GRID HORIZONTAL
LEGEND TOP RIGHT INSIDE;
SELECT year AS series, isocode AS x, gdp AS y
FROM gdp_per_capita
WHERE year = "2010" OR year = '2009' or year = '2008'
ORDER BY gdp DESC
LIMIT 9;