A stacked area chart is used in similar instances as an area chart or a line chart, but shows the relationship of the part to the whole. The data format for a stacked area chart is the same as an area chart, although you’ll need two or more columns containing numeric data. The following example shows Gold, Silver and Bronze Olympic medals as a portion of the total medals earned by each country.