Chart types

  • Different types of source data call for different chart types.
  • You might also choose a chart type because it gives a clearer illustration of the features and trends that you wish to convey to your audience.

Watch the following PowerPoint presentation to see some features and suggested uses for different chart types:

PowerPoint presentation: Chart types in Excel

True-False Question
Is the following statement true or false?


A column chart is good for illustrating data changes over a period of time.

True False     
Multi-select
Which of the following statements are true about bar charts?
A bar chart can illustrate comparisons between individual items.
Bar charts focus on comparing values and place less emphasis on time.
Bar charts make it easier to display long text headings for each category.



IDevice Question Icon Multi-choice
A pie chart:
       
Can contain more than one set of values.
Is good for the visual presentation of percentages.
Shows trends in data at equal intervals of time.

A line chart:
       
Shows the relationship of parts to a whole.
Emphasizes the amount of change and the magnitude of values.
Emphasizes time flow and the rate of change.

A scatter chart:
       
Shows uneven intervals, or clusters, of data.
Is good for demonstrating size or weight.
Illustrates comparisons between items.

Use the menu on the left to navigate your way to the next page.