The cause of the problem is due to no pills on Rows/Columns shelves. These are the gridless chart types. The solution was to add some "Blank" dimensions to Rows/Columns and thus the problem got fixed. Remember to right click the Blank dimension and un-check "Show Header".
Click this picture to go to the interactive version.
As sheet swapping gets popular, similar problems came up often:
The above technique applies to all the chart types with no rows/columns pills: Packed Bubble, Pie and Treemap etc.
Note that in this thread, Zen Master Jonathan Drummey mentioned that he has long found the issue and its solution. He even posted an idea in as early as 2011, which still remains active:
Hope this idea gets implemented one day. Before that day, we have to live with the above tricks.
View comments