Create a simple area graph

You can create an area graph that stacks time series.

For example, this area graph shows the monthly sales of a major retail chain at three store locations over two years.

To create a simple area graph, you must use a worksheet that contains multiple columns of time series data, and each column is a group.

Example worksheet

C1 C2 C3
Pittsburgh Philadelphia Cleveland
370 255 248
304 225 202
310 245 251
... ... ...
  1. Choose Graph > Area Graph.
  2. Under Series, enter multiple columns of time series data. In the example, Pittsburgh, Philadelphia, and Cleveland are the series.
  3. To specify a time scale for the x-axis, click Time/Scale and choose the scale elements. In the example, the time scale is Calendar: Month.
  4. Click OK in each dialog box.
By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy