USE test;
PLOT STACKEDBARCHART
    LIGHT SKYBLUE BAR,
    LIGHT TANGOORANGE BAR
    ALL AXISLABELS
  WITH
    NO OUTLINES
    BAROVERLAP 0
    BARWIDTH .85
    BARSEPARATION 5

    legend at 475 300
    title " "
    title left "Influenza Positive Tests Reported to CDC"
    title left "by U.S. WHO/NREVSS Collaborating Laboratories"
    title " "

    title y "Number of Positive Specimens"
    title x "Week"

    titlesize 20
    fontsize 14
    no sides

    no axisline x

    format y decimal "###,###"
    scale y  0 14000 2000

    page         0 0 700 600
    frame insets 100 95 60 50
SELECT
  `2009_A_H1N1` as 'A (2009 H1N1)',
  `A_Subtyping_not_performed` as 'A (subtyping not performed)',
  if(Week % 2 = 1, week, '')

  FROM flu
;