When to Use Bar Chart, Column Chart, and Area Chart

Bar Chart and Column Chart

A Bar Chart or Bar Graph can be only used to compare values. It presents grouped data using rectangular bars whose lengths are proportional to the values that they represent. The bars can be plotted vertically or horizontally. A vertical bar chart is sometimes called a Column Chart. Bar charts are usually scaled so that all the data can fit on the chart. Bars on the chart can be arranged in any order. The point values can be compared between themselves (single-series chart) or values inside the category (multi-series chart). In case of several series points are grouped by categories.

While talking about charts, we will generally refer to different axis as dimensions and measures.

The same chart can be presented as a column chart as shown below:

Area Chart

An area chart or area graph is used to display quantitative data in a graphical manner. Common uses are the comparison of two or more quantities. They can be used to represent cumulated totals using numbers or percentages over time. Use the area chart to show trends over time among related attributes. When multiple attributes are included, the first attribute is plotted as a line with color fill followed by the second attribute, and so on. Technically this chart type is based on Line Chart and represents filled area between zeroline and the line that connects data points. The same as for Line Chart, timeline scale is the most common case for the X-axis of the Area Chart, but sometimes ordinal scale can be also used.

The following area chart shows venture capital investment by stage.

100% Stack Area Chart

100 Percent Stacked Area Charts display the data that can be put in a table on a worksheet (the items should have two coordinates or parameters). A stacked chart means that all values of one category form a whole; when we’ve got a 100% stacked chart, it means that this chart displays the comparison of the percentage value each part of the category brings to the category. Real values are not displayed, chart shows only the percentage.

This 100% stacked area chart shows the venture capital investment by stage.

Related Downloads

Data Science in Finance: 9-Book Bundle

Data Science in Finance Book Bundle

Master R and Python for financial data science with our comprehensive bundle of 9 ebooks.

What's Included:

  • Getting Started with R
  • R Programming for Data Science
  • Data Visualization with R
  • Financial Time Series Analysis with R
  • Quantitative Trading Strategies with R
  • Derivatives with R
  • Credit Risk Modelling With R
  • Python for Data Science
  • Machine Learning in Finance using Python

Each book includes PDFs, explanations, instructions, data files, and R code for all examples.

Get the Bundle for $29 (Regular $57)
JOIN 30,000 DATA PROFESSIONALS

Free Guides - Getting Started with R and Python

Enter your name and email address below and we will email you the guides for R programming and Python.

Data Science in Finance: 9-Book Bundle

Data Science in Finance Book Bundle

Master R and Python for financial data science with our comprehensive bundle of 9 ebooks.

What's Included:

  • Getting Started with R
  • R Programming for Data Science
  • Data Visualization with R
  • Financial Time Series Analysis with R
  • Quantitative Trading Strategies with R
  • Derivatives with R
  • Credit Risk Modelling With R
  • Python for Data Science
  • Machine Learning in Finance using Python

Each book comes with PDFs, detailed explanations, step-by-step instructions, data files, and complete downloadable R code for all examples.