Need bar chart to ignore entries with blank or #n/a labels

[sbrien]

Hello,

I'm trying to build a chart that will ignore any rows of data that have a data label that is either blank or an error. I would use a pivot chart, but I need to be able to select from various metrics that are represented on the chart using a slicer.

I've attached a link to sample of what I'm working with below.

https://app.box.com/s/5xzm6gy35wcacldiu667

Thanks,
SBrien