Spreadsheet: 179969d1347443057-hiding-data-on-a-bar-chart-using-named-ranges-not-working-chartp
Sheet: Data

 |  | Date |  | Pain |  |  |  |  |  |  |  |  |  | ConsNum | Specialty | ProjMonth
 |  | 2012-01-20 00:00:00 |  | 0 |  |  |  |  |  |  |  |  |  | 54 | GYNAECOLOGY | 30
 |  | 2012-01-20 00:00:00 |  | 0 |  |  |  |  |  |  |  |  |  | 54 | GYNAECOLOGY | 30
 |  | 2012-01-20 00:00:00 |  | 3 |  |  |  |  |  |  |  |  |  | 54 | GYNAECOLOGY | 30
 |  | 2012-01-20 00:00:00 |  | 1 |  |  |  |  |  |  |  |  |  | 54 | GYNAECOLOGY | 30
 |  | 2012-01-20 00:00:00 |  | 0 |  |  |  |  |  |  |  |  |  | 54 | GYNAECOLOGY | 30
 |  | 2012-01-20 00:00:00 |  | 2 |  |  |  |  |  |  |  |  |  | 54 | GYNAECOLOGY | 30
 |  | 2012-01-20 00:00:00 |  | 0 |  |  |  |  |  |  |  |  |  | 54 | GYNAECOLOGY | 30
 |  | 2012-02-10 00:00:00 |  | 0 |  |  |  |  |  |  |  |  |  | 54 | GYNAECOLOGY | 31
 |  | 2012-02-10 00:00:00 |  | 2 |  |  |  |  |  |  |  |  |  | 54 | GYNAECOLOGY | 31
 |  | 2012-02-10 00:00:00 |  | 1 |  |  |  |  |  |  |  |  |  | 54 | GYNAECOLOGY | 31
 |  | 2012-02-10 00:00:00 |  | 3 |  |  |  |  |  |  |  |  |  | 54 | GYNAECOLOGY | 31
 |  | 2012-02-10 00:00:00 |  | 0 |  |  |  |  |  |  |  |  |  | 54 | GYNAECOLOGY | 31
 |  | 2012-02-24 00:00:00 |  | 1 |  |  |  |  |  |  |  |  |  | 54 | BREAST SURGERY | 31
 |  | 2012-02-24 00:00:00 |  | 0 |  |  |  |  |  |  |  |  |  | 54 | GYNAECOLOGY | 31
 |  | 2012-02-24 00:00:00 |  | 0 |  |  |  |  |  |  |  |  |  | 54 | GYNAECOLOGY | 31
 |  | 2012-02-24 00:00:00 |  | 0 |  |  |  |  |  |  |  |  |  | 54 | GYNAECOLOGY | 31
 |  | 2012-02-24 00:00:00 |  | 0 |  |  |  |  |  |  |  |  |  | 54 | GYNAECOLOGY | 31
 |  | 2012-03-02 00:00:00 |  | 0 |  |  |  |  |  |  |  |  |  | 54 | GYNAECOLOGY | 32
 |  | 2012-03-02 00:00:00 |  | 2 |  |  |  |  |  |  |  |  |  | 54 | GYNAECOLOGY | 32
 |  | 2012-03-02 00:00:00 |  | 0 |  |  |  |  |  |  |  |  |  | 54 | GYNAECOLOGY | 32
 |  | 2012-03-02 00:00:00 |  | 1 |  |  |  |  |  |  |  |  |  | 54 | GYNAECOLOGY | 32
 |  | 2012-03-02 00:00:00 |  | 0 |  |  |  |  |  |  |  |  |  | 54 | GYNAECOLOGY | 32
 |  | 2012-08-01 00:00:00 |  | 0 |  |  |  |  |  |  |  |  |  | 54 | COLORECTAL SURGERY | 37
 |  | 2012-08-01 00:00:00 |  | 0 |  |  |  |  |  |  |  |  |  | 54 | COLORECTAL SURGERY | 37
 |  | 2012-08-01 00:00:00 |  | 0 |  |  |  |  |  |  |  |  |  | 54 | COLORECTAL SURGERY | 37
 |  | 2012-08-01 00:00:00 |  | 3 |  |  |  |  |  |  |  |  |  | 54 | COLORECTAL SURGERY | 37
 |  | 2012-08-06 00:00:00 |  | 0 |  |  |  |  |  |  |  |  |  | 54 | UROLOGY | 37
 |  | 2012-08-06 00:00:00 |  | 0 |  |  |  |  |  |  |  |  |  | 54 | UROLOGY | 37
 |  | 2012-08-06 00:00:00 |  | 0 |  |  |  |  |  |  |  |  |  | 54 | UROLOGY | 37
 |  | 2012-08-06 00:00:00 |  | 0 |  |  |  |  |  |  |  |  |  | 54 | UROLOGY | 37
 |  | 2012-08-06 00:00:00 |  | 0 |  |  |  |  |  |  |  |  |  | 54 | UROLOGY | 37
 |  | 2012-08-13 00:00:00 |  | 2 |  |  |  |  |  |  |  |  |  | 54 | UROLOGY | 37
 |  | 2012-08-13 00:00:00 |  | 0 |  |  |  |  |  |  |  |  |  | 54 | UROLOGY | 37
 |  | 2012-08-13 00:00:00 |  | 0 |  |  |  |  |  |  |  |  |  | 54 | UROLOGY | 37
 |  | 2012-08-13 00:00:00 |  | 0 |  |  |  |  |  |  |  |  |  | 54 | UROLOGY | 37
 |  | 2012-08-15 00:00:00 |  | 2 |  |  |  |  |  |  |  |  |  | 54 | COLORECTAL SURGERY | 37
 |  | 2012-08-15 00:00:00 |  | 1 |  |  |  |  |  |  |  |  |  | 54 | COLORECTAL SURGERY | 37
 |  | 2012-08-15 00:00:00 |  | 0 |  |  |  |  |  |  |  |  |  | 54 | COLORECTAL SURGERY | 37
 |  | 2012-08-16 00:00:00 |  | 0 |  |  |  |  |  |  |  |  |  | 54 | GENERAL SURGERY | 37
 |  | 2012-08-16 00:00:00 |  | 0 |  |  |  |  |  |  |  |  |  | 54 | GENERAL SURGERY | 37
 |  | 2012-08-16 00:00:00 |  | 0 |  |  |  |  |  |  |  |  |  | 54 | GENERAL SURGERY | 37
 |  | 2012-08-16 00:00:00 |  | 0 |  |  |  |  |  |  |  |  |  | 54 | GENERAL SURGERY | 37
 |  | 2012-08-23 00:00:00 |  | 0 |  |  |  |  |  |  |  |  |  | 54 | COLORECTAL SURGERY | 37
 |  | 2012-08-23 00:00:00 |  | 0 |  |  |  |  |  |  |  |  |  | 54 | COLORECTAL SURGERY | 37
 |  | 2012-08-23 00:00:00 |  | 0 |  |  |  |  |  |  |  |  |  | 54 | COLORECTAL SURGERY | 37
 |  | 2012-08-29 00:00:00 |  | 3 |  |  |  |  |  |  |  |  |  | 54 | GENERAL SURGERY | 37
 |  | 2012-08-29 00:00:00 |  | 2 |  |  |  |  |  |  |  |  |  | 54 | GENERAL SURGERY | 37
 |  | 2012-08-30 00:00:00 |  | 0 |  |  |  |  |  |  |  |  |  | 54 | GENERAL SURGERY | 37
 |  | 2012-08-30 00:00:00 |  | 0 |  |  |  |  |  |  |  |  |  | 54 | UROLOGY | 37