USE test;
PLOT STACKEDBARCHART
    LIGHT SKYBLUE BAR,
    LIGHT TANGOORANGE BAR,
    LIGHT SCARLETRED BAR,
    LIGHT PLUM BAR,
    LIGHT SKYBLUE BAR,
    CHOCOLATE BAR,
    black line:y2,
    ALL AXISLABELS
  WITH
    NO OUTLINES
    BAROVERLAP 0
    BARWIDTH .85
    BARSEPARATION 5

    legend at 475 275
    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 "Weeks in 2009-2010"

    titlesize 20
    fontsize 14
    no sides

    no axisline x

    format y decimal "###,###"
    scale y  0 14000 2000
    scale y2 0 55 5
    title y2 "Percent Positive"

    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)',
  `A_unable_to_sub_type` as 'A (unable to sub type)',
  `A_H3` as 'A (H3)',
  `A_H1` as 'A (H1)',
  `_B` as 'B',
  `%_positive` as 'Percent Positive',
  if(Week % 2 = 1, week, '')

  FROM flu
;