Question

How many categories of data can be plotted on a pie chart in Excel software?

• A. 4
• B. 12
• C. 20
• D. 7

Hint:

Use pie charts in Excel for up to 20 categories to maintain readability. For larger datasets, use bar charts or column charts for clearer data representation.

Answer 1

The Correct Option is C

Excel allows up to 20 categories of data to be represented effectively on a pie chart. - If the number of categories exceeds 20, the chart becomes cluttered and less readable. - For more categories, bar charts or column charts are better alternatives for data visualization. Why 20 Categories? Pie charts are meant for simple, comparative visualizations of parts-to-whole relationships. Keeping the limit to 20 ensures clarity and avoids overlapping labels. \vspace{0.5cm}