In this post, we'll explore how to create a standard area chart, as well as a stacked area chart, in Excel.ĭon't forget though, you can easily create an area chart for free using Displayr's free area chart maker! Setting up the data for the area chart An area chart is based on a line chart, with the area between the line and the x-axis colored to illustrate volume.