{"id":1286,"date":"2022-12-02T16:53:06","date_gmt":"2022-12-02T16:53:06","guid":{"rendered":"https:\/\/www.bizinfograph.com\/resource\/?p=1286"},"modified":"2024-01-19T16:24:22","modified_gmt":"2024-01-19T16:24:22","slug":"how-to-create-pie-chart-in-excel","status":"publish","type":"post","link":"https:\/\/www.bizinfograph.com\/resource\/how-to-create-pie-chart-in-excel\/","title":{"rendered":"How to create pie chart in Excel?"},"content":{"rendered":"<p><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter wp-image-1297\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/pie-Chart-11.png\" alt=\"pie Chart\" width=\"368\" height=\"286\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/pie-Chart-11.png 651w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/pie-Chart-11-300x233.png 300w\" sizes=\"(max-width: 368px) 100vw, 368px\" \/><\/p>\n<p>Pie chart is a popular way to visually represent data in Excel. A pie chart displays data as a series of slices or wedges, with each slice representing a percentage or proportion of the total. If you&#8217;re looking to create a pie chart in Excel, there are a few key steps you&#8217;ll need to follow. In this tutorial, we&#8217;ll guide you through the process of creating a pie chart in Excel.<\/p>\n<h2><strong>Potential uses for pie charts:<\/strong><\/h2>\n<ul>\n<li>Showing the breakdown of a whole into parts<\/li>\n<li>Highlighting the most significant parts of a dataset<\/li>\n<li>Comparing proportions or percentages across multiple datasets<\/li>\n<\/ul>\n<h2><strong>How to make a pie chart in excel?<\/strong><\/h2>\n<p>In order to create pie chart excel, do the following steps:<\/p>\n<ol>\n<li>Take a sample data.<img decoding=\"async\" class=\"aligncenter size-full wp-image-1287\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/pie-Chart-1.png\" alt=\"pie Chart\" width=\"228\" height=\"151\" \/><\/li>\n<li>Go to ribbon and select Insert and select your chart type from chart group.<img decoding=\"async\" class=\"aligncenter size-full wp-image-1288\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/pie-Chart-2.png\" alt=\"pie Chart\" width=\"787\" height=\"160\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/pie-Chart-2.png 787w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/pie-Chart-2-300x61.png 300w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/pie-Chart-2-768x156.png 768w\" sizes=\"(max-width: 787px) 100vw, 787px\" \/><\/li>\n<li>Select Pie Chart.<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1289\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/pie-Chart-3.png\" alt=\"pie Chart\" width=\"221\" height=\"446\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/pie-Chart-3.png 221w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/pie-Chart-3-149x300.png 149w\" sizes=\"(max-width: 221px) 100vw, 221px\" \/><\/li>\n<li>Your charts look like below chart.<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1290\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/pie-Chart-4.png\" alt=\"pie Chart\" width=\"621\" height=\"401\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/pie-Chart-4.png 621w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/pie-Chart-4-300x194.png 300w\" sizes=\"(max-width: 621px) 100vw, 621px\" \/><\/li>\n<li>To change Color right click on chart and select Format Data Series.<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1291\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/pie-Chart-5.png\" alt=\"pie Chart\" width=\"676\" height=\"485\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/pie-Chart-5.png 676w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/pie-Chart-5-300x215.png 300w\" sizes=\"(max-width: 676px) 100vw, 676px\" \/><\/li>\n<li>Go to the Fill and choose your color. \ufffc<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1293\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/pie-Chart-6.png\" alt=\"\" width=\"887\" height=\"590\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/pie-Chart-6.png 887w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/pie-Chart-6-300x200.png 300w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/pie-Chart-6-768x511.png 768w\" sizes=\"(max-width: 887px) 100vw, 887px\" \/><\/li>\n<li>For changing other pie color, go to the fill and choose your color<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1292\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/pie-Chart-7.png\" alt=\"pie Chart\" width=\"891\" height=\"602\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/pie-Chart-7.png 891w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/pie-Chart-7-300x203.png 300w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/pie-Chart-7-768x519.png 768w\" sizes=\"(max-width: 891px) 100vw, 891px\" \/><\/li>\n<li>To give charts data label click on your chart and select + button. Select Data labels arrow and click Outside End or any other option.<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1294\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/pie-Chart-8.png\" alt=\"pie Chart\" width=\"887\" height=\"391\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/pie-Chart-8.png 887w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/pie-Chart-8-300x132.png 300w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/pie-Chart-8-768x339.png 768w\" sizes=\"(max-width: 887px) 100vw, 887px\" \/><\/li>\n<li>Another way to give data labels &#8211; right click on chart and select Format Data Labels for more data label option.<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1295\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/pie-Chart-9.png\" alt=\"pie Chart\" width=\"691\" height=\"582\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/pie-Chart-9.png 691w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/pie-Chart-9-300x253.png 300w\" sizes=\"(max-width: 691px) 100vw, 691px\" \/><\/li>\n<li>In the Label Option check mark to Value, Percentage, and Show Leader Lines.<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1296\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/pie-Chart-10.png\" alt=\"pie Chart\" width=\"840\" height=\"617\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/pie-Chart-10.png 840w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/pie-Chart-10-300x220.png 300w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/pie-Chart-10-768x564.png 768w\" sizes=\"(max-width: 840px) 100vw, 840px\" \/><\/li>\n<li>Chart looks like below.<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1297\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/pie-Chart-11.png\" alt=\"pie Chart\" width=\"651\" height=\"506\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/pie-Chart-11.png 651w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/pie-Chart-11-300x233.png 300w\" sizes=\"(max-width: 651px) 100vw, 651px\" \/><\/li>\n<\/ol>\n<h2><strong>Application of Pie Chart in Excel in Dashboard Reporting<\/strong><\/h2>\n<figure id=\"attachment_8148\" aria-describedby=\"caption-attachment-8148\" style=\"width: 572px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-8148\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/pie-chart.png\" alt=\"Actual Vs Budget Excel Template\" width=\"572\" height=\"810\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/pie-chart.png 572w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/pie-chart-212x300.png 212w\" sizes=\"(max-width: 572px) 100vw, 572px\" \/><figcaption id=\"caption-attachment-8148\" class=\"wp-caption-text\"><a href=\"https:\/\/www.bizinfograph.com\/dashboard-templates\/budget-vs-actual-dashboard\">Actual Vs Budget Excel Template<\/a><\/figcaption><\/figure>\n<div class=\"flex-1 overflow-hidden\">\n<div class=\"react-scroll-to-bottom--css-vvuon-79elbk h-full\">\n<div class=\"react-scroll-to-bottom--css-vvuon-1n7m0yu\">\n<div class=\"flex flex-col pb-9 text-sm\">\n<div class=\"w-full text-token-text-primary\" data-testid=\"conversation-turn-22\">\n<div class=\"px-4 py-2 justify-center text-base md:gap-6 m-auto\">\n<div class=\"flex flex-1 text-base mx-auto gap-3 md:px-5 lg:px-1 xl:px-5 md:max-w-3xl lg:max-w-[40rem] xl:max-w-[48rem] group final-completion\">\n<div class=\"relative flex w-full flex-col lg:w-[calc(100%-115px)] agent-turn\">\n<div class=\"flex-col gap-1 md:gap-3\">\n<div class=\"flex flex-grow flex-col max-w-full\">\n<div class=\"min-h-[20px] text-message flex flex-col items-start gap-3 whitespace-pre-wrap break-words [.text-message+&amp;]:mt-5 overflow-x-auto\" data-message-author-role=\"assistant\" data-message-id=\"d636e574-3e5c-4151-9151-65ba62f302d2\">\n<div class=\"markdown prose w-full break-words dark:prose-invert light\">\n<p>Here are some uses of pie charts in dashboard reporting:<\/p>\n<ol>\n<li><strong>Market Share Visualization<\/strong>:\n<ul>\n<li>Displays the distribution of market share among competitors, showing each company&#8217;s proportion in the market, making it easier to understand competitive dynamics.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Budget Allocation<\/strong>:\n<ul>\n<li>Visualizes how a budget is allocated across different departments, projects, or expenditure types, helping stakeholders understand financial distribution and resource allocation.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Product Sales Mix<\/strong>:\n<ul>\n<li>Shows the contribution of different products or services to total sales, enabling a clear view of which products are performing well and which are not.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Customer Segmentation<\/strong>:\n<ul>\n<li>Illustrates the breakdown of customers into various segments, such as age groups, income levels, or buying behaviors, providing insights into market segmentation and customer demographics.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Inventory or Asset Composition<\/strong>:\n<ul>\n<li>Represents the proportion of different types of inventory or assets within the total, aiding in the management and optimization of inventory or asset portfolios.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Survey or Poll Results<\/strong>:\n<ul>\n<li>Summarizes the results of surveys or polls, displaying responses to a particular question in percentage terms, which makes understanding public opinion or feedback straightforward.<\/li>\n<\/ul>\n<ol>\n<li><strong>Market Share Visualization<\/strong>:\n<ul>\n<li>Displays the distribution of market share among competitors, showing each company&#8217;s proportion in the market, making it easier to understand competitive dynamics.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Budget Allocation<\/strong>:\n<ul>\n<li>Visualizes how a budget is allocated across different departments, projects, or expenditure types, helping stakeholders understand financial distribution and resource allocation.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Product Sales Mix<\/strong>:\n<ul>\n<li>Shows the contribution of different products or services to total sales, enabling a clear view of which products are performing well and which are not.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Customer Segmentation<\/strong>:\n<ul>\n<li>Illustrates the breakdown of customers into various segments, such as age groups, income levels, or buying behaviors, providing insights into market segmentation and customer demographics.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Inventory or Asset Composition<\/strong>:\n<ul>\n<li>Represents the proportion of different types of inventory or assets within the total, aiding in the management and optimization of inventory or asset portfolios.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Survey or Poll Results<\/strong>:\n<ul>\n<li>Summarizes the results of surveys or polls, displaying responses to a particular question in percentage terms, which makes understanding public opinion or feedback straightforward.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Project Resource Allocation<\/strong>:\n<ul>\n<li>Illustrates how resources, such as time, budget, or manpower, are allocated across different project components, ensuring balanced resource distribution.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Traffic Source Overview<\/strong>:\n<ul>\n<li>Summarizes different sources of website traffic, such as direct, referral, paid, or organic, helping in the analysis and strategy planning of digital marketing efforts.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Revenue Breakdown<\/strong>:\n<ul>\n<li>Visualizes the contribution of different revenue streams or product lines to total revenue, helping in understanding which areas are driving the most income.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Expense Distribution<\/strong>:\n<ul>\n<li>Displays how total expenses are spread across different categories, such as salaries, utilities, and marketing, aiding in budget analysis and financial planning.<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<ol>\n<li style=\"list-style-type: none;\"><\/li>\n<\/ol>\n<p>Pie charts are particularly effective for these uses because they provide a quick, intuitive way to understand the proportional distribution of parts within a whole, making them a popular choice for displaying composition in dashboard reports.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p>For ready-to-use dashboard templates:<\/p>\n<ol>\n<li style=\"list-style-type: none;\">\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<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Pie chart is a popular way to visually represent data in Excel. A pie chart displays data as a series of slices or wedges, with each slice representing a percentage or proportion of the total. If you&#8217;re looking to create a pie chart in Excel, there are a few key steps you&#8217;ll need to follow. &hellip;<\/p>\n<p class=\"read-more\"> <a class=\"\" href=\"https:\/\/www.bizinfograph.com\/resource\/how-to-create-pie-chart-in-excel\/\"> <span class=\"screen-reader-text\">How to create pie 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":[210],"tags":[212,213,211,214],"class_list":["post-1286","post","type-post","status-publish","format-standard","hentry","category-pie-chart","tag-chart","tag-excel-chart","tag-pie-chart","tag-pie-chart-in-excel"],"_links":{"self":[{"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/posts\/1286","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=1286"}],"version-history":[{"count":8,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/posts\/1286\/revisions"}],"predecessor-version":[{"id":8152,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/posts\/1286\/revisions\/8152"}],"wp:attachment":[{"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/media?parent=1286"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/categories?post=1286"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/tags?post=1286"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}