update CPI
  set color = '';

update CPI
  set color = 'light blue' where year > 1956 and year <= 1962;

update CPI
  set color = 'light blue' where year =1965;

plot linechart
   very light blue area, light blue line, xlabels, color override
  with
    title "AREA CHART WITH COLOR OVERRIDE"
    title x "X Axis"
    title y "Y Axis"
select
  average, average, year, color from CPI
  where  1949 < year and year < 1980;

plot linechart
   very light blue area, light blue line, xlabels, color override
  with
    title "AREA CHART WITH COLOR OVERRIDE"
    title x "X Axis"
    title y "Y Axis"
select
  average, average, year, color from CPI
  where  1949 < year and year < 1980;