{"id":9026,"date":"2018-07-20T13:25:54","date_gmt":"2018-07-20T11:25:54","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=9026"},"modified":"2024-02-06T15:47:25","modified_gmt":"2024-02-06T14:47:25","slug":"frequency-distribution-with-excel-pivot-tables","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/frequency-distribution-with-excel-pivot-tables\/","title":{"rendered":"Frequency Distribution with Excel Pivot Tables"},"content":{"rendered":"<p>With Excel <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/101-excel-pivot-tables\/\" target=\"_blank\" rel=\"noopener\" title=\"Pivot Tables\" data-wpil-keyword-link=\"linked\">Pivot Tables<\/a> you can do a lot of stuff with your data! But did you know that you can even create a <strong>Frequency Distribution Table<\/strong>?<\/p>\n<p>Let&#8217;s have some fun below! I&#8217;ll show you how easy it is to create your own Frequency Distribution Chart!<\/p>\n<p>We will create a chart based on this table with Sales values:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Frequency-Distribution-00.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Frequency Distribution with Excel Pivot Tables\"  class=\"alignnone size-full wp-image-9042\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Frequency-Distribution-00.jpg\" alt=\"Frequency Distribution with Excel Pivot Tables\" width=\"1323\" height=\"222\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Frequency-Distribution-00.jpg 1323w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Frequency-Distribution-00-300x50.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Frequency-Distribution-00-1024x172.jpg 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Frequency-Distribution-00-768x129.jpg 768w\" sizes=\"(max-width: 1323px) 100vw, 1323px\" \/><\/a><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_57_1 counter-flat ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li><a href=\"#\" class=\"scroll-to-download\">Free Practice Workbook<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/frequency-distribution-with-excel-pivot-tables\/#Want_to_know_How_to_Create_Frequency_Distribution_with_Excel_Pivot_Tables\" title=\"Want to know How to Create Frequency Distribution with Excel Pivot Tables?\">Want to know How to Create Frequency Distribution with Excel Pivot Tables?<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Want_to_know_How_to_Create_Frequency_Distribution_with_Excel_Pivot_Tables\"><\/span><em><strong>Want to know How to Create Frequency Distribution with Excel Pivot Tables?<\/strong><\/em><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>*** Watch our video and step by step guide below with free downloadable Excel workbook to practice ***<\/p>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/htKvsOr4blc?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<div>\n<div style=\"float: left;\"><span style=\"text-decoration: underline;\"><strong><a href=\"https:\/\/youtu.be\/htKvsOr4blc\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">Watch on YouTube<\/a> <\/strong><\/span>and give it a thumbs up &#x1f44d;<\/div>\n<div>\n<p><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignright wp-image-111468 size-full\" style=\"vertical-align: middle;\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><\/p>\n\n<div class=\"after-post-box\">\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Frequency-Distribution.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Frequency-Distribution.xlsx\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\">Download excel workbook<i class=\"fa fa-download\"><\/i><\/span><span class=\"postTitle px-3\">Frequency-Distribution.xlsx<\/span><\/a><\/p>\n<\/div>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong><\/span>\u00a0Let us insert a new <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/101-excel-pivot-tables\/\" target=\"_blank\" rel=\"noopener\" title=\"Pivot Table\" data-wpil-keyword-link=\"linked\">Pivot Table<\/a>. Select your data and Go to\u00a0<em><strong>Insert &gt; Tables &gt; PivotTable<\/strong><\/em><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Frequency-Distribution-01.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Frequency Distribution with Excel Pivot Tables\"  class=\"alignnone size-full wp-image-9030\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Frequency-Distribution-01.jpg\" alt=\"Frequency Distribution with Excel Pivot Tables\" width=\"506\" height=\"283\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Frequency-Distribution-01.jpg 506w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Frequency-Distribution-01-300x168.jpg 300w\" sizes=\"(max-width: 506px) 100vw, 506px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>Select <strong>Existing Worksheet<\/strong> and pick an empty space to place your\u00a0<strong>Pivot Table.\u00a0<\/strong>Click\u00a0<strong>OK.<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Frequency-Distribution-02.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Frequency Distribution with Excel Pivot Tables\"  class=\"alignnone size-full wp-image-9031\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Frequency-Distribution-02.jpg\" alt=\"Frequency Distribution with Excel Pivot Tables\" width=\"548\" height=\"393\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Frequency-Distribution-02.jpg 548w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Frequency-Distribution-02-300x215.jpg 300w\" sizes=\"(max-width: 548px) 100vw, 548px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong><\/span>\u00a0Drag\u00a0<em><strong>SALES\u00a0<\/strong><\/em>into <em><strong>VALUES<\/strong> <\/em>and\u00a0<em><strong>ROWS\u00a0<\/strong><\/em>and you&#8217;ll see your Pivot Table get updated:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Frequency-Distribution-03.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Frequency Distribution with Excel Pivot Tables\"  class=\"alignnone size-full wp-image-9032\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Frequency-Distribution-03.jpg\" alt=\"Frequency Distribution with Excel Pivot Tables\" width=\"759\" height=\"583\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Frequency-Distribution-03.jpg 759w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Frequency-Distribution-03-300x230.jpg 300w\" sizes=\"(max-width: 759px) 100vw, 759px\" \/><\/a><\/p>\n<p>Click on\u00a0<em><strong>Sum of SALES\u00a0<\/strong><\/em>and select\u00a0<em><strong>Value Field Settings.<\/strong><\/em><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Frequency-Distribution-04.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Frequency Distribution with Excel Pivot Tables\"  class=\"alignnone size-full wp-image-9033\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Frequency-Distribution-04.jpg\" alt=\"Frequency Distribution with Excel Pivot Tables\" width=\"373\" height=\"543\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Frequency-Distribution-04.jpg 373w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Frequency-Distribution-04-206x300.jpg 206w\" sizes=\"(max-width: 373px) 100vw, 373px\" \/><\/a><\/p>\n<p>Select\u00a0<strong>Count<\/strong> and click\u00a0<strong>OK.<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Frequency-Distribution-05.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Frequency Distribution with Excel Pivot Tables\"  class=\"alignnone size-full wp-image-9034\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Frequency-Distribution-05.jpg\" alt=\"Frequency Distribution with Excel Pivot Tables\" width=\"373\" height=\"319\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Frequency-Distribution-05.jpg 373w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Frequency-Distribution-05-300x257.jpg 300w\" sizes=\"(max-width: 373px) 100vw, 373px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 3:<\/strong><\/span>\u00a0We are almost there! Right click on your Pivot Table and select\u00a0<strong>Group.<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Frequency-Distribution-06.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Frequency Distribution with Excel Pivot Tables\"  class=\"alignnone size-full wp-image-9035\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Frequency-Distribution-06.jpg\" alt=\"Frequency Distribution with Excel Pivot Tables\" width=\"317\" height=\"565\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Frequency-Distribution-06.jpg 317w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Frequency-Distribution-06-168x300.jpg 168w\" sizes=\"(max-width: 317px) 100vw, 317px\" \/><\/a><\/p>\n<p>Accept the suggested values. It will group our values by ranges of 10,000. Click\u00a0<strong>OK.<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Frequency-Distribution-07.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Frequency Distribution with Excel Pivot Tables\"  class=\"alignnone size-full wp-image-9036\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Frequency-Distribution-07.jpg\" alt=\"Frequency Distribution with Excel Pivot Tables\" width=\"211\" height=\"171\" \/><\/a><\/p>\n<p>Now it&#8217;s grouped together!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Frequency-Distribution-08.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Frequency Distribution with Excel Pivot Tables\"  class=\"alignnone size-full wp-image-9037\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Frequency-Distribution-08.jpg\" alt=\"Frequency Distribution with Excel Pivot Tables\" width=\"175\" height=\"237\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 4:<\/strong><\/span>\u00a0Go to\u00a0<em><strong>Analyze &gt; Tools &gt; PivotChart\u00a0<\/strong><\/em><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Frequency-Distribution-09.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Frequency Distribution with Excel Pivot Tables\"  class=\"alignnone size-full wp-image-9038\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Frequency-Distribution-09.jpg\" alt=\"Frequency Distribution with Excel Pivot Tables\" width=\"454\" height=\"163\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Frequency-Distribution-09.jpg 454w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Frequency-Distribution-09-300x108.jpg 300w\" sizes=\"(max-width: 454px) 100vw, 454px\" \/><\/a><\/p>\n<p>Ensure\u00a0<strong>Clustered Column\u00a0<\/strong>is selected. Click\u00a0<strong>OK.<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Frequency-Distribution-10.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Frequency Distribution with Excel Pivot Tables\"  class=\"alignnone size-full wp-image-9039\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Frequency-Distribution-10.jpg\" alt=\"Frequency Distribution with Excel Pivot Tables\" width=\"632\" height=\"596\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Frequency-Distribution-10.jpg 632w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Frequency-Distribution-10-300x283.jpg 300w\" sizes=\"(max-width: 632px) 100vw, 632px\" \/><\/a><\/p>\n<p>Your awesome <strong>Frequency Distribution<\/strong> is now ready!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Frequency-Distribution-11.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Frequency Distribution with Excel Pivot Tables\"  class=\"alignnone size-full wp-image-9040\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Frequency-Distribution-11.jpg\" alt=\"Frequency Distribution with Excel Pivot Tables\" width=\"707\" height=\"289\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Frequency-Distribution-11.jpg 707w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/07\/Frequency-Distribution-11-300x123.jpg 300w\" sizes=\"(max-width: 707px) 100vw, 707px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong>Further Learning:<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/customising-pivot-table-styles\/\" target=\"_blank\" rel=\"noopener\">Customising Excel Pivot Table Styles<\/a><\/li>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/move-and-remove-fields-and-items\/\" target=\"_blank\" rel=\"noopener\">Move and Remove Fields and Items in Excel Pivot Tables<\/a><\/li>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/maximum-in-pivot-tables\/\" target=\"_blank\" rel=\"noopener\">Maximum in Excel Pivot Tables<\/a><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>With Excel Pivot Tables you can do a lot of stuff with your data! But did you know that you can even create a Frequency Distribution Table? Let&#8217;s have some fun below! I&#8217;ll show you how easy it is to create your own Frequency Distribution Chart! We will create a chart based on this table [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":15239,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[4,24],"tags":[460,459,139],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/9026"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=9026"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/9026\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/15239"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=9026"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=9026"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=9026"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}