{"id":9163,"date":"2023-04-06T14:50:22","date_gmt":"2023-04-06T14:50:22","guid":{"rendered":"https:\/\/www.excel-learn.com\/?p=9163"},"modified":"2023-04-06T14:50:22","modified_gmt":"2023-04-06T14:50:22","slug":"area-charts-in-excel","status":"publish","type":"post","link":"https:\/\/www.excel-learn.com\/area-charts-in-excel\/","title":{"rendered":"How to Create Area Charts in Excel"},"content":{"rendered":"

5 Steps to draw an area chart<\/strong><\/h3>\n

Follow these steps to access and draw an area chart in MS Excel. We will use the 3-D area chart option.<\/p>\n

Step 1:<\/strong><\/p>\n

Select the data in the sheet that you want to create an area chart. We have the following sample data of top countries with area in Square Kms.<\/p>\n

\"Excel-area-sample\"<\/p>\n

Step 2:<\/strong><\/p>\n

Go to Insert<\/strong> tab in the ribbon\/menu and click on the \u201cRecommended Charts<\/strong>\u201d<\/p>\n

\"Excel-area-Insert\"<\/p>\n

Step 3:<\/strong><\/p>\n

In the \u201cChange Chart Type<\/strong>\u201d dialog, click on \u201cAll Charts<\/strong>\u201d and then click on \u201cArea<\/strong>\u201d as shown below:<\/p>\n

\"Excel-area-all-charts\"<\/p>\n

Step 4:<\/strong><\/p>\n

Find the \u201c3-D Area\u201d towards the right and press OK<\/strong><\/p>\n

\"Excel-area-chart-3D\"<\/p>\n

Result:<\/strong><\/p>\n

We have created the following area chart for the demo:<\/p>\n

\"Excel-area-chart-result\"<\/p>\n

Show\/Hide Data labels in the chart<\/strong><\/h3>\n

To show\/hide data labels in the chart, follow this:<\/p>\n

Step 1:<\/strong><\/p>\n

Select the created chart and click on the + sign (icon):<\/p>\n

\"Excel-area-plus-icon\"<\/p>\n

 <\/p>\n

Step 2:<\/strong><\/p>\n

Under the \u201cCHART ELEMENTS<\/strong>\u201d, click on the \u201cData Labels<\/strong>\u201d checkbox.<\/p>\n

It will display the figures in the chart as labels (see below):<\/p>\n

\"area-chart-date-labels\"<\/p>\n

We also resized the chart to avoid cluttering the figures.<\/p>\n

Show\/Hide data table<\/strong><\/h3>\n

Similarly, you may click on the data table check box to display the data below the chart.<\/p>\n

\"area-chart-date-tables\"<\/p>\n

Change the style of the Area chart<\/strong><\/h3>\n

If you want to change the style of the area chart and use one of the other available styles then click on the \u201cChart Styles<\/strong>\u201d icon after selecting created area chart.<\/p>\n

\"area-chart-style\"<\/p>\n

You can see the list of available styles. Just hover the mouse over any style and you can see how it looks.<\/p>\n

Click the style that you like and click again outside of the style box.<\/p>\n

We choose dark style-8<\/strong> and see the result:<\/p>\n

\"area-chart-style-dark\"<\/p>\n

Change color scheme of the chart<\/strong><\/h3>\n

Adjacent to style is the \u201cCOLOR\u201d option. There you can choose a different color scheme.<\/p>\n

Again, hover the mouse over any color scheme and you will its impact on the chart \u2013 real-time.<\/p>\n

Click on the one you like.<\/p>\n

\"area-chart-Color\"<\/p>\n

Note: <\/strong>You may also notice the options are available on the top menu bar as well.<\/p>\n

Removing specific data from the graph<\/strong><\/h3>\n

If you want to keep data on an Excel sheet but remove certain entries from displaying in the chart then you may filter that by following this.<\/p>\n

Step 1:<\/strong><\/p>\n

Click on the \u201cFilter<\/strong>\u201d icon after selecting the created chart.<\/p>\n

Step 2:<\/strong><\/p>\n

Unselect the \u201cCATEGORIES\u201d in the checkboxes that you do not want to display and click \u201cApply\u201d. We unselected three countries and the result:<\/p>\n

\"area-chart-Category\"<\/p>\n","protected":false},"excerpt":{"rendered":"

Select the data in the sheet that you want to create area chart. We have following sample data of top countries with area in Square Kms.<\/p>\n","protected":false},"author":1,"featured_media":9164,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[71],"tags":[],"yoast_head":"\n6 Examples of How to Create Area Charts in Excel<\/title>\n<meta name=\"description\" content=\"Select the data in the sheet that you want to create area chart. We have following sample data of top countries with area in Square Kms.\" \/>\n<meta name=\"robots\" content=\"index, follow\" \/>\n<meta name=\"googlebot\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta name=\"bingbot\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.excel-learn.com\/area-charts-in-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"6 Examples of How to Create Area Charts in Excel\" \/>\n<meta property=\"og:description\" content=\"Select the data in the sheet that you want to create area chart. We have following sample data of top countries with area in Square Kms.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.excel-learn.com\/area-charts-in-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-04-06T14:50:22+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2023\/03\/79_12-area-chart-Category.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1047\" \/>\n\t<meta property=\"og:image:height\" content=\"515\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.excel-learn.com\/#website\",\"url\":\"https:\/\/www.excel-learn.com\/\",\"name\":\"Excel Tutorials\",\"description\":\"Tips, Solutions, Tricks\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":\"https:\/\/www.excel-learn.com\/?s={search_term_string}\",\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.excel-learn.com\/area-charts-in-excel\/#primaryimage\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2023\/03\/79_12-area-chart-Category.png\",\"width\":1047,\"height\":515,\"caption\":\"area-chart-Category\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.excel-learn.com\/area-charts-in-excel\/#webpage\",\"url\":\"https:\/\/www.excel-learn.com\/area-charts-in-excel\/\",\"name\":\"6 Examples of How to Create Area Charts in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/www.excel-learn.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.excel-learn.com\/area-charts-in-excel\/#primaryimage\"},\"datePublished\":\"2023-04-06T14:50:22+00:00\",\"dateModified\":\"2023-04-06T14:50:22+00:00\",\"author\":{\"@id\":\"https:\/\/www.excel-learn.com\/#\/schema\/person\/c3f75f86b1c65bf0b93fc46f629fcad3\"},\"description\":\"Select the data in the sheet that you want to create area chart. We have following sample data of top countries with area in Square Kms.\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.excel-learn.com\/area-charts-in-excel\/\"]}]},{\"@type\":[\"Person\"],\"@id\":\"https:\/\/www.excel-learn.com\/#\/schema\/person\/c3f75f86b1c65bf0b93fc46f629fcad3\",\"name\":\"excelmaster\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.excel-learn.com\/#personlogo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/e2a3743b4da71bd52984e02bd5c3280c?s=96&d=mm&r=g\",\"caption\":\"excelmaster\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","_links":{"self":[{"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/posts\/9163"}],"collection":[{"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/comments?post=9163"}],"version-history":[{"count":2,"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/posts\/9163\/revisions"}],"predecessor-version":[{"id":9304,"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/posts\/9163\/revisions\/9304"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/media\/9164"}],"wp:attachment":[{"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/media?parent=9163"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/categories?post=9163"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/tags?post=9163"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}