-- requires the CPI sample data from
-- charts.zip on http://dbentrance.com/

plot linechart
  xlabels, swath, light red swath, light green swath,
         light blue swath
with 
  comment ""
  comment left "   Use SWATH to fill in color between lines."
  legend
select
  year, average, average*4 as 'Red swath', 
     average *5 as'Green swath', average*6 as 'Blue swath'
  from CPI
  where  year < 2007;