• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL

Hour 12. Adding a Chart > Types of Charts

Types of Charts

The most common chart types include pie, bar, column (default), line, and area. Table 12.2 lists these chart types, their descriptions, and how you would use them.

Table 12.2. Excel's Chart Types
Chart TypeDescription/How to Use It
PiePlots only one category of data, but each wedge of the pie represents a different data series. Use this chart to show the relationship among parts of a whole.
BarHorizontal representations of column charts, often called histograms. Use this chart to compare values at a given point in time, emphasizing the performance of a group of items. Often, different patterns are not required for bar chart data series.
ColumnSimilar to a bar chart; use this chart to emphasize the difference between items over a period of time. Columns make it easy to compare the values of items in each category. Column charts are best for comparing two or more items.
LineUse this chart to emphasize trends and the change of values over time, showing how one or more items have changed over time. Lines emphasize the change, not the comparison of one item to another. Also useful for plotting numerous categories of data for multiple data series.
AreaSimilar to the line chart and stacked column chart in that an area chart shows how items combine to form a total. Use this chart to emphasize the amount of change in values, providing a more dramatic representation of the change in values over time.



Not a subscriber?

Start A Free Trial

  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint