Blanks Displayed in Pivit and Charts

hello

is there a way for blanks NOT to be displayed, Looks very messy on a chart,

please see attched

Paul

There are a couple of ways of attacking this,
Firstly on your slicers right click, slicer settings, check box - Hide items with no data...
Secondly on your charts you have a filter on the bottom left corner - Department/Customer - select the filter an uncheck blanks - refresh