Hi,
I use a slicer for market type. Sometimes my Market type is blank as source data is from another spreadheet which might not be upto date. When Slicer choices arent selected and its showing all market types including blank (unalloacted) my pie chart looks weird.
Is there a way to not include the Blank in my Market slicer? Or even though slicers connected to a Pie chart (have Pie chart locked so doesnt include Blank Market data?
Changing slicer settings to hide values wth no data doesnt have an affect, its reading the blan as data?
Formula in my Mkt column (source data)
Many Thanks
Gareth
I use a slicer for market type. Sometimes my Market type is blank as source data is from another spreadheet which might not be upto date. When Slicer choices arent selected and its showing all market types including blank (unalloacted) my pie chart looks weird.
Is there a way to not include the Blank in my Market slicer? Or even though slicers connected to a Pie chart (have Pie chart locked so doesnt include Blank Market data?
Changing slicer settings to hide values wth no data doesnt have an affect, its reading the blan as data?
Formula in my Mkt column (source data)
Many Thanks
Gareth