Tip # 196: Why can’t I funnel or pie?

I received an excellent question this morning:

“Dear Tip, why can’t I do a funnel or pie chart? These buttons are grayed out!”

The reason the buttons for funnel and pie are grayed out is because the chart definition includes multiple categories. Pie and funnel charts only support single groupings (series and category). When doing multi-series or multi-category charts, you should use a bar or line chart.