How To Build Interactive Excel Dashboards Webinar - Question|Dashboards & Charts|Excel Forum|My Online Training Hub

Hi -

I was able to recreate the pivot table / dashboard in the webinar.  Everything seems to work OK, but - I noticed that the slicers for states SA and TAS seem to throw a nasty #REF! onto the pie chart whenever they are selected.  (I realize the source data has nothing available for Fashion Direct sales in either SA or TAS, as evidenced by the gap in the sparkline chart.)

Just wondering if anyone might know of an easy fix for this(?).  I know it's easily explained due to the data gap, but for the audience, it might give them an uneasy feeling that maybe the dashboard isn't working correctly.  I'd much rather see an "N/A" or a 0 displayed, myself.  Any thoughts......??

Thanks! -