{"id":1793,"date":"2022-12-20T16:11:24","date_gmt":"2022-12-20T16:11:24","guid":{"rendered":"https:\/\/www.bizinfograph.com\/resource\/?p=1793"},"modified":"2024-04-29T21:53:52","modified_gmt":"2024-04-29T21:53:52","slug":"how-to-create-progress-chart-in-excel","status":"publish","type":"post","link":"https:\/\/www.bizinfograph.com\/resource\/how-to-create-progress-chart-in-excel\/","title":{"rendered":"How to Create Progress Chart in Excel?"},"content":{"rendered":"<p><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter wp-image-1815\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Progress-Chart-19.png\" alt=\"Progress Chart \" width=\"376\" height=\"230\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Progress-Chart-19.png 497w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Progress-Chart-19-300x184.png 300w\" sizes=\"(max-width: 376px) 100vw, 376px\" \/><\/p>\n<p>In Excel, a progress chart is a helpful tool for displaying data over time. Growth, milestones, and accomplishments along the way can all be documented and shared with the help of a progress chart. There are only a few essential steps required to create a progress chart in Excel and you&#8217;ll be well on your way to tracking your progress in no time. Here, you&#8217;ll learn the steps to make an Excel chart showing your progress.<\/p>\n<h2><strong>Uses for progress charts:<\/strong><\/h2>\n<ul>\n<li>Following one&#8217;s steps towards a target<\/li>\n<li>Explicitly showing how something changed over time<\/li>\n<li>Keeping tabs on how well a group or person is doing over time<\/li>\n<\/ul>\n<p>Please follow the below steps to create excel progress bar chart:<\/p>\n<ol>\n<li>Take sample data.<\/li>\n<\/ol>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-1794\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Progress-Chart-1.png\" alt=\"Progress Chart \" width=\"327\" height=\"183\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Progress-Chart-1.png 327w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Progress-Chart-1-300x168.png 300w\" sizes=\"(max-width: 327px) 100vw, 327px\" \/><\/p>\n<p>2. Select any cell of data then go to the ribbon, select Insert, and select your chart type from the chart group.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-1795\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Progress-Chart-2.png\" alt=\"Progress Chart \" width=\"674\" height=\"146\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Progress-Chart-2.png 674w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Progress-Chart-2-300x65.png 300w\" sizes=\"(max-width: 674px) 100vw, 674px\" \/><\/p>\n<p>3. Select Chart type as 2-D Bar to create excel progress bar chart.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1796\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Progress-Chart-3.png\" alt=\"Progress Chart\" width=\"201\" height=\"380\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Progress-Chart-3.png 201w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Progress-Chart-3-159x300.png 159w\" sizes=\"(max-width: 201px) 100vw, 201px\" \/><\/p>\n<p>4. The chart looks below.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1797\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Progress-Chart-4.png\" alt=\"Progress Chart \" width=\"518\" height=\"330\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Progress-Chart-4.png 518w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Progress-Chart-4-300x191.png 300w\" sizes=\"(max-width: 518px) 100vw, 518px\" \/><\/p>\n<p>5. To change the category in reverse on the vertical axis, right-click on the axis and select Format Axis.<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1798\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Progress-Chart-5.png\" alt=\"Progress Chart\" width=\"431\" height=\"322\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Progress-Chart-5.png 431w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Progress-Chart-5-300x224.png 300w\" sizes=\"(max-width: 431px) 100vw, 431px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>6. After that in the Axis Options give a checkmark on the \u2018Categories in Reverse Order\u2019 box.<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1799\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Progress-Chart-6.png\" alt=\"Progress Chart \" width=\"643\" height=\"394\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Progress-Chart-6.png 643w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Progress-Chart-6-300x184.png 300w\" sizes=\"(max-width: 643px) 100vw, 643px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>7. To remove the horizontal axis, click on Axis and press Delete.<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1801\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Progress-Chart-7-1.png\" alt=\"Progress Chart\" width=\"415\" height=\"503\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Progress-Chart-7-1.png 415w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Progress-Chart-7-1-248x300.png 248w\" sizes=\"(max-width: 415px) 100vw, 415px\" \/><\/p>\n<p>8. To remove the Chart Title and Legend, click on the Chart Title and Legend then press Delete.<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1802\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Progress-Chart-8.png\" alt=\"Progress Chart\" width=\"396\" height=\"505\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Progress-Chart-8.png 396w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Progress-Chart-8-235x300.png 235w\" sizes=\"(max-width: 396px) 100vw, 396px\" \/><\/p>\n<p>9. To give a horizontal Gridline, click on the chart then select the + button, and check the Gridline. Here we remove the vertical gridline and give a horizontal gridline.<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1803\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Progress-Chart-9.png\" alt=\"Progress Chart\" width=\"654\" height=\"244\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Progress-Chart-9.png 654w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Progress-Chart-9-300x112.png 300w\" sizes=\"(max-width: 654px) 100vw, 654px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>10. To change the gap width and Series Overlap in the bar, right-click on the chart and select Format Data, in Format Data Series select Series Option and change the gap width to 60% and Series Overlap to 100%.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1804\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Progress-Chart-10.png\" alt=\"Progress Chart\" width=\"592\" height=\"295\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Progress-Chart-10.png 592w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Progress-Chart-10-300x149.png 300w\" sizes=\"(max-width: 592px) 100vw, 592px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>11. To change the color in the first bar, right-click on the chart and select Format Data, in Format Data Series select Fill and choose your color.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1805\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Progress-Chart-11.png\" alt=\"Progress Chart\" width=\"605\" height=\"299\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Progress-Chart-11.png 605w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Progress-Chart-11-300x148.png 300w\" sizes=\"(max-width: 605px) 100vw, 605px\" \/><\/p>\n<p>12. To change the color in the second bar, right-click on the chart and select Format Data, in Format Data Series select Fill and choose No fill.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1806\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Progress-Chart-12.png\" alt=\"Progress Chart\" width=\"564\" height=\"328\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Progress-Chart-12.png 564w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Progress-Chart-12-300x174.png 300w\" sizes=\"(max-width: 564px) 100vw, 564px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>13. To change the color in the second bar outline, right-click on the chart and select Format Data, in Format Data Series select Border and choose your color and change Width to 1.5 pt.<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1807\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Progress-Chart-13.png\" alt=\"Progress Chart\" width=\"573\" height=\"327\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Progress-Chart-13.png 573w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Progress-Chart-13-300x171.png 300w\" sizes=\"(max-width: 573px) 100vw, 573px\" \/><\/p>\n<p>14. To bring forward the second bar outline, follow the below steps. Right-click on the bar and select data.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1808\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Progress-Chart-14.png\" alt=\"Progress Chart\" width=\"510\" height=\"321\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Progress-Chart-14.png 510w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Progress-Chart-14-300x189.png 300w\" sizes=\"(max-width: 510px) 100vw, 510px\" \/><\/p>\n<p>15. Select % of Completion and move up as indicated below image.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1809\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Progress-Chart-15.png\" alt=\"Progress Chart\" width=\"416\" height=\"485\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Progress-Chart-15.png 416w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Progress-Chart-15-257x300.png 257w\" sizes=\"(max-width: 416px) 100vw, 416px\" \/><\/p>\n<p>16. To give a data label of % completion, right-click on the bar, select Format Data Series, and choose the series type as % Completion.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1810\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Progress-Chart-16.png\" alt=\"Progress Chart\" width=\"669\" height=\"327\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Progress-Chart-16.png 669w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Progress-Chart-16-300x147.png 300w\" sizes=\"(max-width: 669px) 100vw, 669px\" \/><\/p>\n<p>17. To give Data Labels click on your chart and select the + button to give your Data labels. Select Data labels and click on Inside End or any other option.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1811\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Progress-Chart-17.png\" alt=\"Progress Chart\" width=\"603\" height=\"245\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Progress-Chart-17.png 603w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Progress-Chart-17-300x122.png 300w\" sizes=\"(max-width: 603px) 100vw, 603px\" \/><\/p>\n<p>18. To give a Chart Title click on your chart and select the + button to give your Chart Title, select Chart Title.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1814\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Progress-Chart-18.png\" alt=\"Progress Chart\" width=\"587\" height=\"273\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Progress-Chart-18.png 587w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Progress-Chart-18-300x140.png 300w\" sizes=\"(max-width: 587px) 100vw, 587px\" \/><\/p>\n<p>19. To change the chart title name, click the chart title and write the title name. The chart looks below.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1815\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Progress-Chart-19.png\" alt=\"Progress Chart \" width=\"497\" height=\"304\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Progress-Chart-19.png 497w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/Progress-Chart-19-300x184.png 300w\" sizes=\"(max-width: 497px) 100vw, 497px\" \/><\/p>\n<h2>Application of Progress Chart in Dashboard Reporting:<\/h2>\n<figure id=\"attachment_8077\" aria-describedby=\"caption-attachment-8077\" style=\"width: 617px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-8077\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/HR-Termination-Dashboard.png\" alt=\"HR Termination Dashboard\" width=\"617\" height=\"812\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/HR-Termination-Dashboard.png 617w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/HR-Termination-Dashboard-228x300.png 228w\" sizes=\"(max-width: 617px) 100vw, 617px\" \/><figcaption id=\"caption-attachment-8077\" class=\"wp-caption-text\"><a href=\"https:\/\/www.bizinfograph.com\/dashboard-templates\/hr-termination-dashboard-\">HR Termination Dashboard<\/a><\/figcaption><\/figure>\n<p>Progress Charts are essential tools in dashboard reporting, particularly for tracking the progression of tasks or goals over time. Here are six applications of Progress Charts in dashboard reporting:<\/p>\n<ol>\n<li><strong>Tracking Project Milestones<\/strong>:\n<ul>\n<li>Progress Charts can effectively track the completion status of various milestones in a project. This visualization helps project managers and teams understand what portions of the project are complete, in progress, or pending, facilitating better project management and timely interventions.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Monitoring Sales Targets<\/strong>:\n<ul>\n<li>In sales dashboards, these charts are invaluable for monitoring progress towards sales targets. They can show how close a team or individual is to achieving monthly, quarterly, or annual sales goals, enabling sales managers to make strategic decisions based on real-time data.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Performance Measurement against KPIs<\/strong>:\n<ul>\n<li>Progress Charts are used to measure and visualize the performance of individuals, teams, or the entire organization against key performance indicators (KPIs). This helps in quickly assessing whether performance standards are being met or if there are areas needing improvement.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Budget Utilization Tracking<\/strong>:\n<ul>\n<li>They can be used to track budget utilization in financial dashboards. For example, monitoring the percentage of an annual budget spent can help in ensuring that spending is on track and within the allocated limits.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Goal Tracking in Personal Dashboards<\/strong>:\n<ul>\n<li>In personal or individual performance dashboards, Progress Charts can track progress towards personal goals like learning objectives, fitness targets, or personal projects, providing a visual motivation and status check.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Operational Efficiency Analysis<\/strong>:\n<ul>\n<li>For operational dashboards, these charts can indicate the efficiency of different processes or systems, such as the percentage of tasks completed in a production cycle or the progress in resolving customer support tickets.<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<p><strong>For ready-to-use Dashboard Templates:<\/strong><\/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>In Excel, a progress chart is a helpful tool for displaying data over time. Growth, milestones, and accomplishments along the way can all be documented and shared with the help of a progress chart. There are only a few essential steps required to create a progress chart in Excel and you&#8217;ll be well on your &hellip;<\/p>\n<p class=\"read-more\"> <a class=\"\" href=\"https:\/\/www.bizinfograph.com\/resource\/how-to-create-progress-chart-in-excel\/\"> <span class=\"screen-reader-text\">How to Create Progress 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":[247],"tags":[249,248],"class_list":["post-1793","post","type-post","status-publish","format-standard","hentry","category-progress-chart-in-excel","tag-progress-chart","tag-progress-chart-in-excel"],"_links":{"self":[{"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/posts\/1793","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=1793"}],"version-history":[{"count":11,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/posts\/1793\/revisions"}],"predecessor-version":[{"id":9131,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/posts\/1793\/revisions\/9131"}],"wp:attachment":[{"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/media?parent=1793"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/categories?post=1793"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/tags?post=1793"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}