How to Make an Area Chart

An Area Chart will help you oversee the trends or changes over time by different categories. Please follow the steps below to make an area chart:

Step 1: Select the data with category names;

Step 2: Click the "Insert" Tab from the ribbon;

This image has an empty alt attribute; its file name is excelinserttab.jpg

Step 3: Click the "Area" chart command in the Chart area;

Step 4: An Area Chart will be created.

Step 5: Change Chart Title: click on the title then select the words inside the box to replace with the proper ones;

Step 6: Add Data Labels: Right click any portion of the area, in the dialog box, select "Add Data Labels" then "Add Data Labels" or "Add Data Callouts" (Notes: Excel 2010 and earlier versions have no option of "Data Callouts").

Step 7: Format Axis: Double click on the Axis, in the Format Axis window, change the values to make chart changes.

Another method is to right click on the axis, select Format Axis from the dialog box to bring up Format Axis Window. Please note that Excel 2010 or earlier versions has a different style of the "Format Axis" window.

Download Example

Leave a Reply