{"id":305,"date":"2022-08-18T18:48:22","date_gmt":"2022-08-18T18:48:22","guid":{"rendered":"https:\/\/www.bizinfograph.com\/resource\/?p=305"},"modified":"2024-01-17T16:07:48","modified_gmt":"2024-01-17T16:07:48","slug":"area-chart-in-excel","status":"publish","type":"post","link":"https:\/\/www.bizinfograph.com\/resource\/area-chart-in-excel\/","title":{"rendered":"How to Create Area Chart in Excel?"},"content":{"rendered":"<p>Changes in data over time are often displayed using area charts. You might think of them as line charts with the empty space below the line filled in, making for a more comprehensive and straightforward visual representation of the data. Making an area chart in Excel that does justice to your data only requires a few clicks. This tutorial will show you how to make an area chart in Excel by walking you through each step.<\/p>\n<h2><strong>Potential uses of excel area chart :<\/strong><\/h2>\n<ul>\n<li>Sales, revenues, and profits over time are just some of the many examples of business and financial data that can be represented by area charts.<\/li>\n<li>They are particularly helpful in scientific study since they graphically display facts over time, such as how the climate has changed, the number of people living in a given area, or the spread of disease.<\/li>\n<li>The ability to compare various data sets on a single chart is a key feature of area charts, which aids in the discovery of patterns and trends.<\/li>\n<\/ul>\n<h2><strong>Create Area Chart in Excel<\/strong><\/h2>\n<p>In order to create chart area excel, do the following steps:<\/p>\n<ol>\n<li>Select the data range A1:B7 or simply keep cursor in any cell of the data range<\/li>\n<\/ol>\n<p><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter size-full wp-image-306\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Area-Chart-1.png\" alt=\"Area chart\" width=\"212\" height=\"252\" \/><\/p>\n<p>2. Select Insert menu and click on area chart icon as indicated in below image<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-307\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Area-Chart-2.png\" alt=\"Area chart\" width=\"843\" height=\"183\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Area-Chart-2.png 843w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Area-Chart-2-300x65.png 300w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Area-Chart-2-768x167.png 768w\" sizes=\"(max-width: 843px) 100vw, 843px\" \/><\/p>\n<p>Select 2-D Area chart option<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-308\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Area-Chart-3.png\" alt=\"Area chart\" width=\"312\" height=\"596\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Area-Chart-3.png 312w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Area-Chart-3-157x300.png 157w\" sizes=\"(max-width: 312px) 100vw, 312px\" \/>3. Area Chart looks as per below image<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-309\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Area-Chart-4.png\" alt=\"Area chart\" width=\"640\" height=\"397\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Area-Chart-4.png 640w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Area-Chart-4-300x186.png 300w\" sizes=\"(max-width: 640px) 100vw, 640px\" \/><\/p>\n<p>4. In order to Remove the Gridline \u2013 click the \u2018+\u2019 icon of Chart Elements and uncheck the box of Gridlines<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-310\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Area-Chart-5.png\" alt=\"Area chart\" width=\"717\" height=\"325\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Area-Chart-5.png 717w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Area-Chart-5-300x136.png 300w\" sizes=\"(max-width: 717px) 100vw, 717px\" \/><\/p>\n<p>5. To change color of your area chart \u2013 right click on the chart and from the pop-up window click on \u2018Format Data Series\u2019<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-311\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Area-Chart-6.png\" alt=\"Area Chart\" width=\"682\" height=\"417\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Area-Chart-6.png 682w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Area-Chart-6-300x183.png 300w\" sizes=\"(max-width: 682px) 100vw, 682px\" \/><\/p>\n<p>6. From the \u2018Format Data Series\u2019 pop-up window \u2013 select the desired color<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-312\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Area-Chart-7.png\" alt=\"Area chart\" width=\"832\" height=\"578\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Area-Chart-7.png 832w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Area-Chart-7-300x208.png 300w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Area-Chart-7-768x534.png 768w\" sizes=\"(max-width: 832px) 100vw, 832px\" \/><\/p>\n<p>7. To show the data labels in area chart \u2013 from Chart Elements tick mark the Data Labels check box or click on arrow and click on Show.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-313\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Area-Chart-8.png\" alt=\"Area Chart\" width=\"830\" height=\"325\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Area-Chart-8.png 830w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Area-Chart-8-300x117.png 300w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Area-Chart-8-768x301.png 768w\" sizes=\"(max-width: 830px) 100vw, 830px\" \/><\/p>\n<p>If you want to customize your area chart like below chart i.e. give a deep line on top border of your area chart<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-314\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Area-Chart-9.png\" alt=\"Area chart\" width=\"597\" height=\"363\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Area-Chart-9.png 597w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Area-Chart-9-300x182.png 300w\" sizes=\"(max-width: 597px) 100vw, 597px\" \/><\/p>\n<p>8. Add same data in another column to add line chart<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-315\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Area-Chart-10.png\" alt=\"Area chart\" width=\"290\" height=\"242\" \/><\/p>\n<p>9.\u00a0 Right click on the chart and Select Data option for add new data<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-316\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Area-Chart-11.png\" alt=\"Area chart\" width=\"682\" height=\"378\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Area-Chart-11.png 682w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Area-Chart-11-300x166.png 300w\" sizes=\"(max-width: 682px) 100vw, 682px\" \/><\/p>\n<p>10. Add new data series with existing data series. Here we add the same data set again<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-317\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Area-Chart-12.png\" alt=\"Area chart\" width=\"602\" height=\"352\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Area-Chart-12.png 602w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Area-Chart-12-300x175.png 300w\" sizes=\"(max-width: 602px) 100vw, 602px\" \/><\/p>\n<p>11. Here we add the same data set again. Select new data range<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-318\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Area-Chart-13.png\" alt=\"Area chart\" width=\"565\" height=\"417\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Area-Chart-13.png 565w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Area-Chart-13-300x221.png 300w\" sizes=\"(max-width: 565px) 100vw, 565px\" \/><\/p>\n<p>12. New chart will look as below, since the both data series are same \u2013 one chart overlaps other<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-320\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Area-Chart-14.png\" alt=\"area chart\" width=\"620\" height=\"378\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Area-Chart-14.png 620w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Area-Chart-14-300x183.png 300w\" sizes=\"(max-width: 620px) 100vw, 620px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>13. In order to make the line for the new data set \u2013 execute the following steps<\/p>\n<p>Right click on the chart and select \u2018Change Series Chart Type\u2019<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-322\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Area-Chart-15.png\" alt=\"Area chart\" width=\"621\" height=\"453\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Area-Chart-15.png 621w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Area-Chart-15-300x219.png 300w\" sizes=\"(max-width: 621px) 100vw, 621px\" \/><\/p>\n<p>14. For second data series, click the down arrow icon and select \u2018Line with Marker\u2019 chart<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-323\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Area-Chart-16.png\" alt=\"Area chart\" width=\"806\" height=\"760\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Area-Chart-16.png 806w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Area-Chart-16-300x283.png 300w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Area-Chart-16-768x724.png 768w\" sizes=\"(max-width: 806px) 100vw, 806px\" \/><\/p>\n<p>15. Chart looks as below image after Change chart type<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-324\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Area-Chart-17.png\" alt=\"Area chart\" width=\"612\" height=\"368\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Area-Chart-17.png 612w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Area-Chart-17-300x180.png 300w\" sizes=\"(max-width: 612px) 100vw, 612px\" \/><\/p>\n<p>16. From \u2018Format Data Series\u2019 you may reduce the area chart transparency to make it light color.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-325\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Area-Chart-18.png\" alt=\"Area chart\" width=\"866\" height=\"432\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Area-Chart-18.png 866w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Area-Chart-18-300x150.png 300w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Area-Chart-18-768x383.png 768w\" sizes=\"(max-width: 866px) 100vw, 866px\" \/><\/p>\n<p>Also change the data labels for the line chart and remove the existing data labels for area chart.<\/p>\n<h2><strong>Application of Area Chart in Dashboard Reporting<\/strong><\/h2>\n<p>&nbsp;<\/p>\n<figure id=\"attachment_8097\" aria-describedby=\"caption-attachment-8097\" style=\"width: 1097px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-8097\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Area-Chart.png\" alt=\"CEO Dashboard - Executive Dashboard\" width=\"1097\" height=\"825\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Area-Chart.png 1097w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Area-Chart-300x226.png 300w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Area-Chart-1024x770.png 1024w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/08\/Area-Chart-768x578.png 768w\" sizes=\"(max-width: 1097px) 100vw, 1097px\" \/><figcaption id=\"caption-attachment-8097\" class=\"wp-caption-text\"><a href=\"https:\/\/www.bizinfograph.com\/dashboard-templates\/ceo-dashboard---executive-dashboard\">CEO Dashboard &#8211; Executive Dashboard<\/a><\/figcaption><\/figure>\n<p>Here are some uses of area charts in dashboard reporting:<\/p>\n<ol>\n<li><strong>Trend Analysis Over Time<\/strong>:\n<ul>\n<li>Visualizes how a specific data set has progressed over a period, highlighting trends, patterns, or fluctuations, useful for sales, stock prices, or temperature changes.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Cumulative Totals Display<\/strong>:\n<ul>\n<li>Shows the accumulation of values over time, making it easy to understand the total impact by a specific date, often used for tracking total sales, expenses, or inventory levels.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Comparing Multiple Categories<\/strong>:\n<ul>\n<li>Compares the trends of different categories or groups over time, stacked together for a clear comparison, suitable for product line sales, website traffic sources, or market share analysis.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Portfolio or Budget Allocation<\/strong>:\n<ul>\n<li>Represents the distribution of resources or investments among different categories, showing how each part contributes to the whole, used in finance for portfolio diversification or budget allocation.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Project Phase or Task Progression<\/strong>:\n<ul>\n<li>Illustrates the stages or tasks of a project over time, showing how much of each task is completed and the overlapping of different phases, aiding in project management and scheduling.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Market or Population Segmentation<\/strong>:\n<ul>\n<li>Displays the size and change of different segments within a market or population, such as age groups, income brackets, or product categories, beneficial for market analysis or demographic studies.<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<p>For ready-to-use Dashboard Templates:<\/p>\n<ol>\n<li><a href=\"https:\/\/www.bizinfograph.com\/dashboard-templates#Finance\" target=\"_blank\" rel=\"noopener\">Financial Dashboards<\/a><\/li>\n<li><a href=\"https:\/\/www.bizinfograph.com\/dashboard-templates#Sales\" target=\"_blank\" rel=\"noopener\">Sales Dashboards<\/a><\/li>\n<li><a href=\"https:\/\/www.bizinfograph.com\/dashboard-templates#Human-Resource\" target=\"_blank\" rel=\"noopener\">HR Dashboards<\/a><\/li>\n<li><a href=\"https:\/\/www.executiveknowledge.org\/dashboard-templates\/35\" target=\"_blank\" rel=\"noopener\">Data Visualization Charts<\/a><\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>Changes in data over time are often displayed using area charts. You might think of them as line charts with the empty space below the line filled in, making for a more comprehensive and straightforward visual representation of the data. Making an area chart in Excel that does justice to your data only requires a &hellip;<\/p>\n<p class=\"read-more\"> <a class=\"\" href=\"https:\/\/www.bizinfograph.com\/resource\/area-chart-in-excel\/\"> <span class=\"screen-reader-text\">How to Create Area Chart in Excel?<\/span> Read More &raquo;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-global-header-display":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","footnotes":""},"categories":[53],"tags":[54,56,55],"class_list":["post-305","post","type-post","status-publish","format-standard","hentry","category-area-chart","tag-area-chart","tag-area-chart-in-excel","tag-area-chart-with-line-chart"],"_links":{"self":[{"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/posts\/305","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/comments?post=305"}],"version-history":[{"count":11,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/posts\/305\/revisions"}],"predecessor-version":[{"id":8098,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/posts\/305\/revisions\/8098"}],"wp:attachment":[{"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/media?parent=305"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/categories?post=305"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/tags?post=305"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}