1 of 1 people found this helpful
Most pie charts don't have dimensions on ROWS or COLUMNS. So the swapping filter on the sheet actually doesn't have a row or column to clear out.
Create a bogus calc.
Put that on columns. Then uncheck "show header" for that pill.
Now your pie chart will disappear when you swap.
Thanks very much Joe. It works like a charm.