Discussion
In MS Excel, which chart type is best for showing the proportion each category contributes to a whole?
Answer: D
Correct answer: Pie chart
A pie chart shows parts of a whole, each slice representing a category’s share of the total. It works only under conditions worth remembering: the values must be parts of a single total, must all be positive, and should be few - beyond about five or six slices the differences become impossible to judge. Human eyes compare angles poorly, so a bar chart is usually clearer even when a pie is technically valid. The other types answer different questions. A line chart shows change over time. A bar or column chart compares values across categories. A scatter chart shows the relationship between two numeric variables and is the right choice for correlation. An area chart is a line chart with the region below filled, emphasising cumulative magnitude. Choosing the chart type is a matter of what question is being asked, not of appearance. Alt + F1 inserts a default chart from the selected data.
Post your comment
Please log in or register to post a comment.
Examination Categories
- SSC Exams
- Banking Exams
- Teaching Exams
- Civil Services Exams
- Railways Exams
- Engineering Recruitment Exams
- Defence Exams
- State Government Exams
- Police Exams
- Insurance Exams
- Nursing Exams
- Other Government Exams
- NRA CET
- PG Entrance Exams
- Campus Placement
- MBA Entrance Exams
- CUET and UG Entrance
- Judiciary Exams
- Regulatory Body Exams
- Software Development