-- requires the CPI sample data 
-- (use create_cpi.sql from charts.zip)

plot barchart
  axislabels,  transparent red bars, datalabels
with 
  title "Title"
  title x "X Axis"
  title y "Y Axis"
  barwidth 0.85
  no outlines
  scale 0 50 10
select
  substring(year,3,2), average, average from CPI
  where  1959 < year and year < 1967;