Author: Oscar Cronquist Article last updated on September 06, 2018

The area chart is similar to the line chart except that the area below the line is filled, use this chart to plot data over time or categories (non-numeric).

The time interval must be evenly distributed, use the scatter chart if not. The image above demonstrates time values (years) evenly distributed from 2010 to 2016 (x-axis).

How to build

  1. Select the data you want to graph.
  2. Go to tab "Insert".
  3. Click the "Insert line or area chart" button.
  4. Click the "Area" button.

How to add a second series

  1. Right click on chart.
  2. Click on "Select Data...".
  3. Click "Add" button.
  4. Click "Series values:" button.
  5. Select the data source.
  6. Press Enter
  7. Click OK button.
  8. Click OK button.