-- Sample for Entrance, http://dbentrance.com/

set @yr = '1916';

plot linechart
     thin gray line,  datalabel above,
     thin gray line,  datalabel above, 
     thin gray line,  datalabel above, 
     thin gray line,  datalabel above, 
     very light blue area, light blue line,
     axislabels
  with
    title  "Consumer Price Index, 1913-2006"
    no sides
    scale y 0 225 50
    no axisline y
    no ticks y 
    no labels y
    foreground dark gray
select
    25,  if(year = @yr, '25', ''), 
    50,  if(year = @yr, '50', ''),  
    100, if(year = @yr, '100', ''), 
    200, if(year = @yr, '200', ''), 
    jan, jan,  
    year from CPI
  ;