{"id":1673,"date":"2023-11-11T18:18:59","date_gmt":"2023-11-11T18:18:59","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/histogram\/"},"modified":"2023-12-10T06:00:58","modified_gmt":"2023-12-10T06:00:58","slug":"histogram","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/histogram\/","title":{"rendered":"Excel&#39;de hi\u0307stogram nas\u0131l olu\u015fturulur?"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-506230434\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>Bu, Excel&#8217;de HISTOGRAM&#8217;\u0131 farkl\u0131 Excel s\u00fcr\u00fcmlerinde farkl\u0131 \u015fekillerde olu\u015fturmak i\u00e7in ad\u0131m ad\u0131m \u00f6\u011freticidir.<\/p><h2 class=\"wp-block-heading\"> Excel Histogram Grafi\u011fi<\/h2><p> Histogram, bir aral\u0131k kullanarak de\u011ferleri temsil eden bir s\u00fctun veya \u00e7ubuk grafiktir. \u00d6\u011frenci notlar\u0131n\u0131 \u00e7e\u015fitli kategoriler (Bin&#8217;ler) kullanarak sunmak isteyen bir \u00f6\u011fretmen d\u00fc\u015f\u00fcn\u00fcn. S\u0131n\u0131fta 50 \u00f6\u011frencisi var ve s\u0131n\u0131f\u0131n performans\u0131n\u0131 sunmak i\u00e7in histogram kullanarak \u00f6\u011frencilerin notlar\u0131na g\u00f6re da\u011f\u0131l\u0131m\u0131n\u0131 kullanabiliyor. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/etapes-pour-creer-un-histogramme-dans-excel-toute-version-1.png\" sizes=\"\" srcset=\"\" alt=\"Excel'in herhangi bir s\u00fcr\u00fcm\u00fcnde histogram olu\u015fturma ad\u0131mlar\u0131\"><\/figure><\/div><p> Bu k\u0131lavuzda, bu tahtada ustala\u015fmak i\u00e7in ihtiyac\u0131n\u0131z olan her \u015feyi sizinle payla\u015faca\u011f\u0131m. O halde \u00f6n\u00fcm\u00fczdeki birka\u00e7 dakika boyunca benimle kal\u0131n\u2026<\/p><ul><li> 2016<\/li><li> 2013<\/li><li> Mac<\/li><li> Eksen<\/li><li> Di\u011fer<\/li><\/ul><h2 class=\"wp-block-heading\"> Excel 2016&#8217;da Histogram Olu\u015fturma Ad\u0131mlar\u0131<\/h2><p> Benim gibi Excel 2016 kullan\u0131yorsan\u0131z, size iyi haberlerim var ve iyi haber \u015fu ki, Excel&#8217;in bu s\u00fcr\u00fcm\u00fcnde yerle\u015fik bir histogram olu\u015fturma se\u00e7ene\u011fi var.<\/p><p> \u00c7al\u0131\u015fanlar\u0131n\u0131z\u0131n bir listesinin ( <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/histogramme-des-donnees-des-employes.xlsx\" rel=\"nofollow\"><span style=\"font-family: inherit;\"><strong>liste buradad\u0131r<\/strong><\/span><\/a> ) ve \u015firketteki \u00e7al\u0131\u015fma s\u00fcrelerinin elinizde oldu\u011funu varsayal\u0131m. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/donnees-des-employes-pour-creer-un-histogramme-dans-excel-1.png\" sizes=\"\" srcset=\"\" alt=\"excel'de histogram olu\u015fturmak i\u00e7in \u00e7al\u0131\u015fan verileri\"><\/figure><\/div><p> \u015eimdi belirli bir d\u00f6nem aral\u0131\u011f\u0131ndaki (Bin) \u00e7al\u0131\u015fan say\u0131s\u0131n\u0131 g\u00f6stermesi gereken bir histogram olu\u015fturman\u0131z gerekiyor.<\/p><p> \u015eu basit ad\u0131mlar\u0131 izleyin:<\/p><ul><li> <strong><span style=\"color: #000000;\">\u00d6ncelikle<\/span><\/strong> verileri se\u00e7in ve grafi\u011fi eklemek i\u00e7in Ekle sekmesi <span style=\"color: #000000;\">\u279c<\/span> Grafik <span style=\"color: #000000;\">\u279c<\/span> \u0130statistiksel Grafikler Ekle <span style=\"color: #000000;\">\u279c<\/span> Histogram <span style=\"color: #000000;\">\u279c<\/span> Histogram&#8217;a gidin. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/allez-a-longlet-donnees-pour-creer-un-histogramme-dans-excel-2016-1.png\" sizes=\"\" srcset=\"\" alt=\"excel 2016'da histogram olu\u015fturmak i\u00e7in veri sekmesine gidin\"><\/figure><\/div><p> Ger\u00e7ekte, atman\u0131z gereken tek ad\u0131m budur; grafi\u011finiz e-tablonuzun tam oradad\u0131r. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/inserer-un-histogramme-Excel-a-partir-de-graphiques-donglets-de-donnees-1.png\" sizes=\"\" srcset=\"\" alt=\"veri sekmesi grafiklerinden excel histogram\u0131 ekleme\"><\/figure><\/div><p> \u0130sterseniz grafik ba\u015fl\u0131\u011f\u0131n\u0131 ve k\u0131lavuz \u00e7izgilerini kald\u0131rabilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-histogramme-2016-sans-grille-de-titre-de-graphique-1.png\" sizes=\"\" srcset=\"\" alt=\"Grafik ba\u015fl\u0131\u011f\u0131 \u0131zgaras\u0131 olmadan Excel histogram\u0131 2016\"><\/figure><\/div><p> <strong><span style=\"color: #000000;\">Profesyonel \u0130pucu<\/span><\/strong> Excel 2016&#8217;y\u0131 kullan\u0131rken, <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/tr\/dinamik-grafik-araligi\/\"><span style=\"font-family: inherit;\">dinamik hale getirmek i\u00e7in verilerinizi bir Excel tablosuna d\u00f6n\u00fc\u015ft\u00fcrd\u00fc\u011f\u00fcn\u00fczden<\/span><\/a> emin olun. B\u00f6ylece, ona her yeni veri ekledi\u011finizde grafi\u011finiz otomatik olarak g\u00fcncellenir.<\/p><p> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/histogramme-excel-2016.xlsx\" rel=\"nofollow\">\u2026daha fazla bilgi edinmek i\u00e7in bu \u00f6rnek dosyay\u0131 buradan indirin<\/a> .<\/p><p> Ancak \u015fimdi onu nas\u0131l \u00f6zelle\u015ftirebilece\u011finizi ve sahip oldu\u011funuz t\u00fcm se\u00e7enekleri g\u00f6rmeniz gerekiyor.<\/p><p> Ana kutu se\u00e7eneklerinden baz\u0131lar\u0131n\u0131 tek tek inceleyelim:<\/p><ul><li> <strong><span style=\"color: #000000;\">\u015eimdi<\/span><\/strong> grafi\u011finizin eksenini se\u00e7in ve \u00fczerine sa\u011f t\u0131klay\u0131n, ard\u0131ndan \u201cEkseni Bi\u00e7imlendir\u201di a\u00e7\u0131n. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/option-daxe-de-format-ouvert-pour-modifier-les-parametres-du-graphique-1.png\" sizes=\"\" srcset=\"\" alt=\"grafik ayarlar\u0131n\u0131 de\u011fi\u015ftirmek i\u00e7in format ekseni se\u00e7ene\u011fini a\u00e7\u0131n\"><\/figure><\/div><h3 class=\"wp-block-heading\"> 1. Kategorilere g\u00f6re<\/h3><p> Burada kulland\u0131\u011f\u0131m\u0131z verileri d\u00fc\u015f\u00fcn\u00fcrseniz, her \u00e7al\u0131\u015fan\u0131n ad\u0131 farkl\u0131 oldu\u011fundan her giri\u015f benzersizdir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Excel-histogramme-2016-avec-categories-1.png\" sizes=\"\" srcset=\"\" alt=\"Kategorilerle Excel histogram\u0131 2016\"><\/figure><\/div><p> Ancak tekrarlayan giri\u015flerinizin oldu\u011fu verileriniz varsa say\u0131sal gruplar yerine bu kategorilerin TOPLAMI veya SAYISINA dayal\u0131 bir grafik olu\u015fturmak i\u00e7in bu se\u00e7ene\u011fi kullanabilirsiniz.<\/p><p> Bu durumda, kutular say\u0131sal verilerin da\u011f\u0131l\u0131m\u0131 de\u011fil, kategoriler olacakt\u0131r.<\/p><h3 class=\"wp-block-heading\"> 2 Otomatik<\/h3><p> Histogram olu\u015fturdu\u011funuzda Excel, mevcut de\u011fer aral\u0131\u011f\u0131n\u0131 kullanarak otomatik olarak b\u00f6lmeler olu\u015fturur. Basit\u00e7e s\u00f6ylemek gerekirse, bu se\u00e7enek histogram olu\u015fturman\u0131n varsay\u0131lan y\u00f6ntemidir.<\/p><h3 class=\"wp-block-heading\"> 3. Tepsi geni\u015fli\u011fi<\/h3><p> Bu se\u00e7ene\u011fi kullanarak b\u00f6lmelerin geni\u015fli\u011fini belirleyebilirsiniz. Diyelim ki her b\u00f6lmenin 10 olmas\u0131n\u0131 istiyorsan\u0131z, bu her b\u00f6lmeyi 0-10, 10-20 vb. olu\u015fturacakt\u0131r.<\/p><p> Bu se\u00e7enekle b\u00f6lmenin geni\u015fli\u011fini kontrol edersiniz ve Excel, belirtti\u011finiz geni\u015fli\u011fi kullanarak b\u00f6lme say\u0131s\u0131n\u0131 olu\u015fturur. Diyelim ki 1&#8217;den 20&#8217;ye kadar de\u011ferleriniz var ve b\u00f6lme geni\u015fli\u011finin 4 olmas\u0131n\u0131 istiyorsunuz, o zaman Excel \u015fu \u015fekilde 5 b\u00f6lme olu\u015fturacakt\u0131r: <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/histogramme-excel-avec-une-largeur-de-bac-specifique-1.png\" sizes=\"\" srcset=\"\" alt=\"belirli b\u00f6lme geni\u015fli\u011fine sahip excel histogram\u0131\"><\/figure><\/div><h3 class=\"wp-block-heading\"> 4. Kutu say\u0131s\u0131<\/h3><p> E\u011fer aral\u0131k yerine bin say\u0131s\u0131n\u0131 belirtmek istiyorsan\u0131z bu se\u00e7ene\u011fe t\u0131klay\u0131p say\u0131y\u0131 girebilirsiniz. Diyelim ki 3 b\u00f6lmeye sahip olmak istiyorsan\u0131z ve de\u011fer aral\u0131\u011f\u0131 0 ile 15 aras\u0131ndaysa, Excel a\u015fa\u011f\u0131daki gibi b\u00f6lmeler olu\u015fturacakt\u0131r: <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/histogramme-excel-avec-un-nombre-specifique-de-bacs-1.png\" sizes=\"\" srcset=\"\" alt=\"belirli say\u0131da kutu i\u00e7eren excel histogram\u0131\"><\/figure><\/div><h4 class=\"wp-block-heading\"> 5. Ta\u015fma tepsisi Ta\u015fma tepsisi<\/h4><p> Bu iki se\u00e7enek, grafikte daha fazla veya daha az b\u00f6lme olu\u015fturman\u0131za yard\u0131mc\u0131 olur. Diyelim ki 10 y\u0131ldan az \u00e7al\u0131\u015fma s\u00fcresine sahip \u00e7al\u0131\u015fanlar i\u00e7in bir sepetiniz olsun istiyorsunuz.<\/p><p> Alt ak\u0131\u015fa sadece 10 girebilirsiniz. Veya 20 y\u0131ldan fazla \u00e7al\u0131\u015fma s\u00fcresine sahip \u00e7al\u0131\u015fanlar i\u00e7in bir Bin olu\u015fturmak istiyorsan\u0131z ta\u015fma alan\u0131na 20 de\u011ferini girin. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/histogramme-excel-avec-bacs-de-debordement-et-de-debordement-1.png\" sizes=\"\" srcset=\"\" alt=\"ta\u015fma ve ta\u015fma kutular\u0131n\u0131 i\u00e7eren excel histogram\u0131\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Excel 2013&#8217;te Histogram Grafi\u011fi Olu\u015fturma Ad\u0131mlar\u0131 (Veri Analizi Ara\u00e7 Paketi)<\/h2><p> Excel 2013 veya daha d\u00fc\u015f\u00fck bir s\u00fcr\u00fcm kullan\u0131yorsan\u0131z bu grafi\u011fi olu\u015fturmak i\u00e7in farkl\u0131 ad\u0131mlar\u0131 izlemeniz gerekir.<\/p><p> Y\u00fcklemeniz gereken <strong><span style=\"color: #000000;\">\u201cAnaliz Ara\u00e7 Paketi\u201d<\/span><\/strong> ADD-IN&#8217;i var. Excel&#8217;inizle birlikte gelir ancak y\u00fcklemeniz gerekir.<\/p><p> \u00d6yleyse nas\u0131l kurulaca\u011f\u0131n\u0131 \u00f6\u011frenelim (Excel 2016 i\u00e7in ekran g\u00f6r\u00fcnt\u00fcleri kullan\u0131yorum ancak ad\u0131mlar Excel&#8217;in t\u00fcm s\u00fcr\u00fcmlerinde ayn\u0131d\u0131r) ve ard\u0131ndan bir histogram olu\u015fturmaya ba\u015flayaca\u011f\u0131z.<\/p><h3 class=\"wp-block-heading\"> Veri Analizi Ara\u00e7lar\u0131 Paketini Y\u00fckleme Ad\u0131mlar\u0131<\/h3><ul><li> \u00d6ncelikle Dosya sekmesine t\u0131klay\u0131n ve \u201cExcel Se\u00e7enekleri\u201dni a\u00e7\u0131n. <br><img decoding=\"async\" title=\"a\u00e7\u0131k-dosya-sekmesinden-a\u00e7\u0131k-excel-se\u00e7ene\u011fine-y\u00fckleme-analiz-ara\u00e7-paketine-olu\u015fturmak i\u00e7in-histogram\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/ouvrir-longlet-du-fichier-pour-ouvrir-loption-Excel-pour-installer-le-pack-doutils-danalyse-pour-creer-un-histogramme-1.png\" sizes=\"\" srcset=\"\" alt=\"open file tab to open excel option to install analysis tool pack to create histogram\"><\/li><li> \u015eimdi buradan Eklentilere gidin ve \u201cExcel Eklentileri\u201dni a\u00e7\u0131n. <br><img decoding=\"async\" title=\"a\u00e7\u0131k-Excel-eklentileri-kurulum-analiz-ara\u00e7-paketi-olu\u015fturmak i\u00e7in-histogram\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/ouvrir-des-complements-Excel-pour-installer-un-pack-doutils-danalyse-pour-creer-un-histogramme-1.png\" sizes=\"\" srcset=\"\" alt=\"open excel addins to install analysis tool pack to create histogram\"><\/li><li> Ve \u201cAnaliz Paketi Al\u201d kutusunu i\u015faretleyin ve Tamam&#8217;a t\u0131klay\u0131n. <br><img decoding=\"async\" title=\"histogram\u0131 olu\u015fturmak i\u00e7in-analiz-ara\u00e7-paketini-y\u00fcklemek i\u00e7in-i\u015faretleyin\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/coche-pour-installer-le-pack-doutils-danalyse-pour-creer-un-histogramme-1.png\" sizes=\"\" srcset=\"\" alt=\"tick mark to install analysis tool pack to create histogram\"><\/li><\/ul><p> Tamam&#8217;\u0131 t\u0131klad\u0131\u011f\u0131n\u0131zda i\u015flem birka\u00e7 saniye s\u00fcrecek ve art\u0131k haz\u0131rs\u0131n\u0131z. Veri sekmesinde bir <strong><span style=\"color: #000000;\">\u201cVeri Analizi\u201d<\/span><\/strong> d\u00fc\u011fmesine sahip olacaks\u0131n\u0131z. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/bouton-danalyse-de-donnees-pour-creer-un-histogramme-1.png\" sizes=\"\" srcset=\"\" alt=\"histogram olu\u015fturmak i\u00e7in veri analizi d\u00fc\u011fmesi\"><\/figure><\/div><p> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/histogramme-des-donnees-des-employes.xlsx\" rel=\"nofollow\">\u2026Devam etmek i\u00e7in bu \u00f6rnek veri dosyas\u0131n\u0131 buradan indirdi\u011finizden emin olun<\/a> .<\/p><p> \u201cAnaliz Ald\u0131 Paketi\u201dni kullanarak bir histogram olu\u015fturmadan \u00f6nce kutular olu\u015fturman\u0131z gerekir. Evet, manuel olarak. ama bu \u00e7ok basit bir \u015fey, biliyorsun. Burada a\u015fa\u011f\u0131daki gibi kutulara veya ne yapmak istiyorsan\u0131z ona ihtiyac\u0131m\u0131z var. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/creer-des-bacs-pour-creer-un-histogramme-dans-Excel-2013-1.png\" sizes=\"\" srcset=\"\" alt=\"Excel 2013'te histogram olu\u015fturmak i\u00e7in kutular olu\u015fturun\"><\/figure><\/div><p> \u015eimdi histogram\u0131 eklemek i\u00e7in bu basit ad\u0131mlar\u0131 izleyelim ve takip edebilece\u011finiz bu veri dosyas\u0131n\u0131n yan\u0131n\u0131zda oldu\u011fundan emin olun.<\/p><ul><li> \u00d6ncelikle veri sekmesine gidin ve \u201cVeri Analizi\u201d se\u00e7ene\u011fine t\u0131klay\u0131n. <br><img decoding=\"async\" title=\"Excel 2013'te histogram olu\u015fturmak i\u00e7in veri analizi d\u00fc\u011fmesini t\u0131klay\u0131n\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/cliquez-sur-le-bouton-danalyse-des-donnees-pour-creer-un-histogramme-dans-Excel-2013-1.png\" sizes=\"\" srcset=\"\" alt=\"click on data anlysis button to create histogram in excel 2013\"><\/li><li> \u015eimdi veri analizi men\u00fcs\u00fcnde \u201cHistogram\u201d\u0131 se\u00e7in ve Tamam&#8217;a t\u0131klay\u0131n. <br><img decoding=\"async\" title=\"histogram\u0131 olu\u015fturmak i\u00e7in veri analizinden-histogram\u0131 se\u00e7\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/selectionner-lhistogramme-a-partir-de-lanalyse-des-donnees-pour-creer-un-histogramme-1.png\" sizes=\"\" srcset=\"\" alt=\"select histogram from data analysis to create histogram\"><\/li><li> Bu noktada a\u015fa\u011f\u0131daki gibi bir histogram pencereniz var ve bu pencereden a\u015fa\u011f\u0131daki detaylar\u0131 belirtmeniz gerekiyor: <br><img decoding=\"async\" title=\"excel-2013'te-bir-histogram-olu\u015fturmak i\u00e7in giri\u015f aral\u0131\u011f\u0131n\u0131 ve kutu aral\u0131\u011f\u0131n\u0131 ayarlama\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/definir-la-plage-dentree-et-la-plage-bin-pour-creer-un-histogramme-dans-Excel-2013-1.png\" sizes=\"\" srcset=\"\" alt=\"define input rang and bin range to create a histogram in excel 2013\"><\/li><\/ul><ol><li> <strong>Giri\u015f Aral\u0131\u011f\u0131:<\/strong> \u015eirketteki \u00e7al\u0131\u015fan y\u0131llar\u0131n\u0131z\u0131n bulundu\u011fu aral\u0131k (yaln\u0131zca ba\u015fl\u0131ks\u0131z de\u011ferleri se\u00e7ti\u011finizden emin olun).<\/li><li> <strong>Bin Aral\u0131\u011f\u0131:<\/strong> Binlerin bulundu\u011fu aral\u0131k, evet az \u00f6nce olu\u015fturdu\u011fumuz aral\u0131k (Yaln\u0131zca ba\u015fl\u0131ks\u0131z de\u011ferleri se\u00e7ti\u011finizden emin olun).<\/li><li> <strong>\u00c7\u0131kt\u0131 Se\u00e7ene\u011fi:<\/strong> \u00c7\u0131kt\u0131 i\u00e7in \u201cYeni \u00c7al\u0131\u015fma Sayfas\u0131\u201dn\u0131 se\u00e7in ve grafik i\u00e7in \u201cGrafik \u00c7\u0131kt\u0131s\u0131\u201dn\u0131 i\u015faretleyin.<\/li><\/ol><ul><li> Sonunda Tamam&#8217;\u0131 t\u0131klay\u0131n.<\/li><\/ul><p> Tamam&#8217;\u0131 t\u0131klad\u0131\u011f\u0131n\u0131zda, grafik ve frekans i\u00e7eren yeni bir e-tabloya sahip olacaks\u0131n\u0131z. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/votre-histogramme-dans-excel-2013-est-pret-1.png\" sizes=\"\" srcset=\"\" alt=\"excel 2013'teki histogram\u0131n\u0131z haz\u0131r\"><\/figure><\/div><p> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/histogramme-excel-2013.xlsx\" rel=\"nofollow\">\u2026\u0130\u015fte \u201cAnaliz Ara\u00e7 Paketi\u201d kullan\u0131larak olu\u015fturulan histograml\u0131 \u00f6rnek dosya<\/a> .<\/p><h3 class=\"wp-block-heading\"> Excel&#8217;de histogram olu\u015fturmak i\u00e7in \u201cAnaliz Ald\u0131 Paketi\u201dni kullan\u0131rken anlaman\u0131z gereken <span style=\"color: #ea493f;\">\u00f6nemli noktalar<\/span><\/h3><ul><li> Birinci grup kendi <strong>de\u011ferinden k\u00fc\u00e7\u00fck bir de\u011fer<\/strong> i\u00e7erirken, geri kalan gruplar <strong>kendisinden k\u00fc\u00e7\u00fck ve bir \u00f6nceki gruptan b\u00fcy\u00fck de\u011ferleri<\/strong> i\u00e7ermektedir. <br><img decoding=\"async\" title=\"kutular-nas\u0131l-\u00e7al\u0131\u015f\u0131r-wneh-excel-analiz-ara\u00e7 paketini kullanarak-histogram-olu\u015fturursunuz\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/comment-fonctionnent-les-bacs-lorsque-vous-creez-un-histogramme-dans-Excel-a-laide-du-pack-doutils-danalyse-1.png\" sizes=\"\" srcset=\"\" alt=\"how bins work wneh you create a histogram in excel using analysis tool pack\"><\/li><li> Olu\u015fturdu\u011funuz binlerin yan\u0131 s\u0131ra, son binden daha fazla de\u011fer g\u00f6r\u00fcnt\u00fclemek i\u00e7in <strong>&#8220;Daha Fazla&#8221; ad\u0131nda ekstra bir bin ekler<\/strong> . Son binden b\u00fcy\u00fck bir de\u011feriniz olmasa bile, bin olarak &#8220;Daha Fazla&#8221;y\u0131 ekler. <br><img decoding=\"async\" title=\"analiz-ara\u00e7 paketini kullanarak excel'de-histogram-olu\u015fturdu\u011funuzda daha fazla-bin\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/plus-bin-lorsque-vous-creez-un-histogramme-dans-Excel-a-laide-du-pack-doutils-danalyse-1.png\" sizes=\"\" srcset=\"\" alt=\"more bin when you create a histgram in excel using analysis tool pack\"><\/li><li> \u201cAnaliz Ald\u0131 Paketi\u201d <strong>dinamik olmayan bir grafik<\/strong> olu\u015fturur. Ana verilere yeni bir de\u011fer ekledi\u011finizde bu de\u011fer g\u00fcncellenmeyece\u011finden yeni bir grafik olu\u015fturman\u0131z gerekir.<\/li><li> <strong>Bin&#8217;leri belirtmeyi g\u00f6z ard\u0131<\/strong> ederseniz, otomatik olarak bin&#8217;leri se\u00e7ecek ve grafi\u011fi olu\u015fturacakt\u0131r. <br><img decoding=\"async\" title=\"Excel'de-analiz-arac\u0131-paketini-kullanarak-bir-histogram-olu\u015fturdu\u011funuzda-kutuyu-otomatik olarak-belirtmeyin\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/lorsque-vous-creez-un-histogramme-dans-Excel-a-laide-du-pack-doutils-danalyse-et-que-vous-ne-specifiez-pas-bin-il-cree-automatiquement-des-bacs-1.png\" sizes=\"\" srcset=\"\" alt=\"when you create histogram in excel using analysis tool packand don't specify bin it create bins automatically\"><\/li><li> \u201cAnaliz Ald\u0131 Paketi\u201d kullanarak histogram olu\u015fturdu\u011funuzda <strong>bunu geri alamazs\u0131n\u0131z<\/strong> , de\u011fi\u015fiklik yapmak istiyorsan\u0131z onu silip yenisini olu\u015fturman\u0131z gerekir.<\/li><\/ul><h2 class=\"wp-block-heading\"> Mac i\u00e7in Excel&#8217;de Histogram Olu\u015fturma [2011]<\/h2><p> Excel&#8217;in Mac s\u00fcr\u00fcm\u00fcnde [2011] histogram olu\u015fturmak i\u00e7in ayr\u0131ca \u201cAnaliz Ara\u00e7 Paketi\u201dni de kurmam\u0131z gerekiyor.<\/p><p> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/histogramme-des-donnees-des-employes.xlsx\" rel=\"nofollow\">\u2026Devam etmek i\u00e7in bu \u00f6rnek dosyay\u0131 indirdi\u011finizden emin olun.<\/a><\/p><h3 class=\"wp-block-heading\"> Excel Mac&#8217;te \u201cAnaliz Ara\u00e7 Paketi\u201dni Etkinle\u015ftirme<\/h3><p> Excel Mac&#8217;te &#8220;Analiz Ara\u00e7 Paketi&#8221;ni etkinle\u015ftirmek i\u00e7in bu basit ad\u0131mlar\u0131 izleyin<\/p><ul><li> <strong>\u00d6ncelikle<\/strong> Ara\u00e7lar men\u00fcs\u00fcne gidin ve \u201cExcel Eklentileri\u201dne t\u0131klay\u0131n. <br><img decoding=\"async\" title=\"mac'ta-histogram-olu\u015fturmak i\u00e7in excel-mac'teki-analiz-ara\u00e7-paketini etkinle\u015ftir\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/activer-le-pack-doutils-danalyse-dans-excel-mac-pour-creer-un-histogramme-dans-mac-1.png\" sizes=\"\" srcset=\"\" alt=\"activate analysis tool pack in excel mac to create a histogram in mac\"><\/li><li> \u015eimdi eklenti penceresinde \u201cTarama Arac\u0131 Paketi\u201d kutusunu i\u015faretleyin ve Tamam&#8217;a t\u0131klay\u0131n. <br><img decoding=\"async\" title=\"excel-mac'te-histgram-olu\u015fturmak i\u00e7in-i\u015faret-analiz-ara\u00e7-paketi\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/pack-doutils-danalyse-de-coches-pour-creer-un-histogramme-dans-excel-mac-1.png\" sizes=\"\" srcset=\"\" alt=\"tick mark analysis tool pack to create histgram in excel mac\"><\/li><li> Bu, \u201cVeri Analizi\u201d d\u00fc\u011fmesini an\u0131nda Veri sekmesine ekleyecektir. <br><img decoding=\"async\" title=\"excel-2011-mac'te-histogram-olu\u015fturma-veri-analizi-d\u00fc\u011fmesi\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/bouton-danalyse-de-donnees-pour-creer-un-histogramme-dans-excel-2011-mac-1.png\" sizes=\"\" srcset=\"\" alt=\"data analysis button to create histogram in excel 2011 mac\"><\/li><\/ul><p> \u015eimdi bir sonraki ad\u0131m.<\/p><h3 class=\"wp-block-heading\"> Histogram Olu\u015fturma Ad\u0131m\u0131 [Mac Excel]<\/h3><p> Grafi\u011finizi olu\u015fturmadan \u00f6nce, yukar\u0131daki y\u00f6ntemde yapt\u0131\u011f\u0131m\u0131z gibi bin&#8217;leri olu\u015fturdu\u011funuzdan emin olun. Ayr\u0131ca \u00e7\u00f6p kutular\u0131na a\u015fina de\u011filseniz, bu makalenin yukar\u0131daki b\u00f6l\u00fcm\u00fcnde onlar hakk\u0131nda bilgi edindi\u011finizden emin olun.<\/p><ul><li> \u00d6ncelikle veri sekmesine gidin ve \u201cVeri Analizi\u201d butonuna t\u0131klay\u0131n.<\/li><li> Veri analizi penceresinde \u201cHistogram\u201d\u0131 se\u00e7in ve Tamam&#8217;a t\u0131klay\u0131n. <br><img decoding=\"async\" title=\"excel-2011-mac'te-histogram-grafik-olu\u015fturmak i\u00e7in-histogram\u0131 se\u00e7in\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/selectionnez-lhistogramme-pour-creer-un-graphique-dhistogramme-dans-Excel-2011-mac-1.png\" sizes=\"\" srcset=\"\" alt=\"select histogram to create histogram chart in excel 2011 mac\"><\/li><li> Tamam&#8217;\u0131 t\u0131klatt\u0131\u011f\u0131n\u0131zda, a\u015fa\u011f\u0131dakileri girmeniz gereken histogram ileti\u015fim kutusunu g\u00f6receksiniz: <br><img decoding=\"async\" title=\"giri\u015f-de\u011ferleri-aral\u0131\u011f\u0131-ve-bin-aral\u0131\u011f\u0131-excel-2011-mac'te-histogram-olu\u015fturulacak\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/plage-de-valeurs-dentree-et-plage-de-bacs-pour-creer-un-histogramme-dans-Excel-2011-mac-1.png\" sizes=\"\" srcset=\"\" alt=\"input values range and bin range to create histogram in excel 2011 mac\"><\/li><\/ul><ol><li> <strong>Giri\u015f Aral\u0131\u011f\u0131:<\/strong> \u015eirketteki \u00e7al\u0131\u015fan y\u0131llar\u0131n\u0131z\u0131n bulundu\u011fu aral\u0131k (yaln\u0131zca ba\u015fl\u0131ks\u0131z de\u011ferleri se\u00e7ti\u011finizden emin olun).<\/li><li> <strong>Bin Aral\u0131\u011f\u0131:<\/strong> Binlerin bulundu\u011fu aral\u0131k, evet az \u00f6nce olu\u015fturdu\u011fumuz aral\u0131k (Yaln\u0131zca ba\u015fl\u0131ks\u0131z de\u011ferleri se\u00e7ti\u011finizden emin olun).<\/li><li> <strong>\u00c7\u0131kt\u0131 Se\u00e7ene\u011fi:<\/strong> \u00c7\u0131kt\u0131 i\u00e7in \u201cYeni \u00c7al\u0131\u015fma Sayfas\u0131\u201dn\u0131 se\u00e7in ve grafik i\u00e7in \u201cGrafik \u00c7\u0131kt\u0131s\u0131\u201dn\u0131 i\u015faretleyin.<\/li><\/ol><ul><li> Bundan sonra Tamam&#8217;\u0131 t\u0131klay\u0131n.<\/li><\/ul><p> Tamam&#8217;\u0131 t\u0131klatt\u0131\u011f\u0131n\u0131zda, frekans tablosu ve histogram\u0131 i\u00e7eren yeni bir \u00e7al\u0131\u015fma sayfas\u0131 eklenir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/histogramme-final-dans-la-version-mac-dexcel-1.png\" sizes=\"\" srcset=\"\" alt=\"excel'in mac versiyonundaki son histogram\"><\/figure><\/div><h2 class=\"wp-block-heading\"> PivotTable ve PivotChart&#8217;\u0131 kullanarak histogram olu\u015fturma<\/h2><p> Konu kontrol ve esneklik oldu\u011funda pivot tablo ve <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/tr\/pivot-tablo-2\/\" data-wpil=\"url\">pivot tablo<\/a> gibisi yoktur. Bir pivot tablo ile bir pivot tabloyu birle\u015ftirerek histogram olu\u015fturman\u0131n basit bir yolunu buldum. A\u015fa\u011f\u0131daki tablo bir pivot tablodur, buna inanabiliyor musunuz? <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/creer-un-histogramme-dans-Excel-a-laide-dun-tableau-croise-dynamique-et-dun-tableau-croise-dynamique-1.png\" sizes=\"\" srcset=\"\" alt=\"pivot tablo ve pivot tabloyu kullanarak excel'de histogram olu\u015fturma\"><\/figure><\/div><p> Size bunun nas\u0131l \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131 anlatay\u0131m ( <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/histogramme-des-donnees-des-employes.xlsx\" rel=\"nofollow\">burada ayn\u0131 \u00e7al\u0131\u015fan verileriyle<\/a> ).<\/p><ul><li> \u00d6ncelikle bir pivot tablo olu\u015fturman\u0131z gerekir (veya tek seferde bir pivot tablo ve pivot tablo da olu\u015fturabilirsiniz).<\/li><li> Bunu yapmak i\u00e7in Ekle sekmesine gidin \u279c Grafikler \u279c Pivot Grafik \u279c Pivot Grafik ve Pivot Tablo.<\/li><li> \u201c\u00d6zet Tablo Olu\u015ftur\u201d ileti\u015fim kutusunda \u201cYeni \u00c7al\u0131\u015fma Sayfas\u0131\u201dn\u0131 ve ard\u0131ndan Tamam&#8217;\u0131 t\u0131klay\u0131n. <br><img decoding=\"async\" title=\"Pivot tablo ve pivot grafi\u011fi kullanarak histogram olu\u015fturmak i\u00e7in pivot tablo olu\u015fturma penceresi\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/creer-une-fenetre-de-tableau-croise-dynamique-pour-creer-un-histogramme-a-laide-dun-tableau-croise-dynamique-et-dun-graphique-croise-dynamique-1.png\" sizes=\"\" srcset=\"\" alt=\"create pivot table window to create a histogram using pivot table and pivot chart\"><\/li><li> Bu noktada \u00e7al\u0131\u015fma sayfan\u0131zda bo\u015f bir PivotTable ve PivotTable var. <br><img decoding=\"async\" title=\"excel'de-histogram-olu\u015fturmak i\u00e7in bo\u015f bir pivot tablo\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/un-tableau-croise-dynamique-vide-pour-creer-un-histogramme-dans-excel-1.png\" sizes=\"\" srcset=\"\" alt=\"a blank pivot table to create a histogram in excel\"><\/li><li> Bir dahaki sefere de\u011fer eklememiz gerekti\u011finde, \u015fimdi sat\u0131r alan\u0131na ve de\u011ferlere &#8220;\u015eirketteki istihdam (y\u0131l olarak)&#8221; s\u00fctununu ekleyin. <br><img decoding=\"async\" title=\"histogram olu\u015fturmak i\u00e7in pivot tabloya de\u011ferler ve sat\u0131r alan\u0131 ekleyin\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/ajouter-des-valeurs-et-un-champ-de-ligne-dans-le-tableau-croise-dynamique-pour-creer-un-histogramme-1.png\" sizes=\"\" srcset=\"\" alt=\"add values and row field into the pivot table to create a histogram\"><\/li><li> \u015eimdi de\u011ferler kutusu i\u00e7in \u201cDe\u011fer Alan\u0131 Ayar\u0131\u201dn\u0131 a\u00e7\u0131n ve \u201cToplam\u201d yerine \u201cSayma\u201dy\u0131 se\u00e7in. <br><img decoding=\"async\" title=\"pivot tablo kullanarak excel'e-histogram-eklemek i\u00e7in de\u011fer alan\u0131 i\u00e7in-say\u0131m\u0131-se\u00e7in\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/selectionnez-le-nombre-pour-le-champ-de-valeur-pour-inserer-un-histogramme-dans-Excel-a-laide-dun-tableau-croise-dynamique-1.png\" sizes=\"\" srcset=\"\" alt=\"select count for the value field to insert a histogram in excel using pivot table\"><\/li><li> Daha sonra pivot tabloya gidin ve \u201cSat\u0131r Etiketi\u201dne sa\u011f t\u0131klay\u0131n ve \u201cGrup\u201da t\u0131klay\u0131n.<\/li><li> \u201cGrupland\u0131rma \u00d6l\u00e7\u00fct\u00fc\u201d penceresinde \u201cBy\u201d alan\u0131na 5 girin ve Tamam&#8217;a t\u0131klay\u0131n. <br><img decoding=\"async\" title=\"pivot tablo kullanarak excel'de bir histogram olu\u015fturmak i\u00e7in grubu se\u00e7in\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/selectionnez-le-groupe-pour-creer-un-histogramme-dans-Excel-a-laide-dun-tableau-croise-dynamique-1.png\" sizes=\"\" srcset=\"\" alt=\"select the group to create a histogram in excel using pivot table\"><\/li><\/ul><p> \u015eimdi onu m\u00fckemmel bir tahta haline getirmek i\u00e7in tahtada baz\u0131 \u00f6zelle\u015ftirmeler yapman\u0131z gerekiyor.<\/p><ul><li> Veri Serisi ve A\u00e7\u0131k Veri Serisi se\u00e7eneklerini se\u00e7in. Buradan \u201cbo\u015fluk geni\u015fli\u011fini\u201d 0 olarak ayarlay\u0131n. <br><img decoding=\"async\" title=\"excel'de-histogram-olu\u015fturmak i\u00e7in pivot grafi\u011fi i\u00e7in bo\u015fluk geni\u015fli\u011fini s\u0131f\u0131r yap\u0131n\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/faire-la-largeur-de-lecart-zero-pour-le-tableau-croise-dynamique-pour-faire-un-histogramme-dans-Excel.png\" sizes=\"\" srcset=\"\" alt=\"make gap width zero for the pivot chart to make a histogram in excel\"><\/li><li> Bundan sonra, k\u0131lavuz \u00e7izgilerini ve ba\u015fl\u0131\u011f\u0131 grafikten kald\u0131r\u0131n (istenirse).<\/li><li> Filtre d\u00fc\u011fmesine t\u0131klay\u0131n ve \u201cT\u00fcm\u00fcn\u00fc Gizle\u201dye t\u0131klay\u0131n. <br><img decoding=\"async\" title=\"pivot grafik histogram\u0131n\u0131zdaki t\u00fcm filtreleri gizleyin\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/masquer-tous-les-filtres-de-votre-histogramme-de-tableau-croise-dynamique-1.png\" sizes=\"\" srcset=\"\" alt=\"hide all the filters from your pivot chart histogram\"><\/li><li> Sonunda sa\u011f eksene sa\u011f t\u0131klay\u0131n ve \u201cEkseni Bi\u00e7imlendir\u201d i a\u00e7\u0131n.<\/li><li> Eksen Bi\u00e7imlendirme Se\u00e7enekleri&#8217;nde Eksen Se\u00e7enekleri \u279c Eksen Se\u00e7enekleri \u279c Birimler&#8217;e gidin ve maj\u00f6rde 1, min\u00f6rde 0 girin. <br><img decoding=\"async\" title=\"excel'deki gpivot grafi\u011fini kullanarak m\u00fckemmel bir histogram olu\u015fturmak i\u00e7in ana ve k\u00fc\u00e7\u00fck eksende de\u011fi\u015fiklik yapar\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/modifie-les-axes-majon-et-mineur-pour-creer-un-histogramme-parfait-a-laide-du-graphique-gpivot-dans-Excel-1.png\" sizes=\"\" srcset=\"\" alt=\"makes change to majon and minor axis to create a perfect histogram using gpivot chart in excel\"><\/li><\/ul><p> Boom! histogram\u0131n\u0131z haz\u0131r. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/votre-histogramme-a-laide-dun-tableau-croise-dynamique-et-dun-tableau-croise-dynamique-est-pret-1.png\" sizes=\"\" srcset=\"\" alt=\"Pivot tablo ve pivot tablo kullanan histogram\u0131n\u0131z haz\u0131r\"><\/figure><\/div><h2 class=\"wp-block-heading\"> FREKANS i\u015flevini kullanan dinamik histogram<\/h2><p> \u201cAnaliz Ara\u00e7 Paketi\u201dni kullanarak bir histogram olu\u015fturursan\u0131z dinamik olmayacakt\u0131r.<\/p><p> Ama\u00e7\u2026<\/p><p> FREKANS fonksiyonunu kullanarak dinamik bir histogram olu\u015fturabilirsiniz. Bu i\u015flevi kullanmak i\u00e7in, verilerde kutular olu\u015fturun (burada ayn\u0131 \u00e7al\u0131\u015fan verilerini kullan\u0131yorum), ard\u0131ndan <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/tr\/excel-formul-cubugu\/\">a\u015fa\u011f\u0131daki form\u00fcl\u00fc form\u00fcl \u00e7ubu\u011funa<\/a> girin:<\/p><p> =FREKANS(Giri\u015fVeriAral\u0131\u011f\u0131,BinAral\u0131\u011f\u0131) <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/utiliser-la-fonction-de-frequence-pour-creer-un-histogramme-dynamique-dans-Excel-1.png\" sizes=\"\" srcset=\"\" alt=\"Excel'de dinamik bir histogram olu\u015fturmak i\u00e7in frekans i\u015flevini kullan\u0131n\"><\/figure><\/div><p class=\"mytip\"> Bu form\u00fcl\u00fc Alt + Shift + Enter tu\u015flar\u0131n\u0131 kullanarak dizi form\u00fcl\u00fc olarak girdi\u011finizden emin olun.<\/p><p> Bundan sonra, az \u00f6nce olu\u015fturdu\u011fumuz tabloyu kullanarak normal bir histogram eklemeniz yeterli. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/une-fois-que-vous-avez-cree-un-tableau-avec-une-formule-de-frequence-inserez-simplement-un-graphique-numerique-pour-creer-un-histogramme-1.png\" sizes=\"\" srcset=\"\" alt=\"Frekans form\u00fcll\u00fc bir tablo olu\u015fturduktan sonra histogram olu\u015fturmak i\u00e7in bir say\u0131 grafi\u011fi eklemeniz yeterlidir\"><\/figure><\/div><p> Ve &#8220;Veri Serisini Formatla&#8221; se\u00e7eneklerinden bo\u015fluk geni\u015fli\u011fini %0 olarak de\u011fi\u015ftirmeyi unutmay\u0131n. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/rendre-la-largeur-de-lecart-nulle-pour-creer-un-histogramme-dans-Excel-en-utilisant-la-fonction-de-frequence-1.png\" sizes=\"\" srcset=\"\" alt=\"frekans fonksiyonunu kullanarak excel'de histogram olu\u015fturmak i\u00e7in bo\u015fluk geni\u015fli\u011fini s\u0131f\u0131r yap\u0131n\"><\/figure><\/div><p> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/histogramme-des-donnees-des-employes.xlsx\" rel=\"nofollow\">\u2026daha fazla bilgi edinmek i\u00e7in \u00f6rnek dosyay\u0131 buradan indirin.<\/a><\/p><h2 class=\"wp-block-heading\"> Histogram olu\u015fturman\u0131z gerekti\u011finde<\/h2><p> Excel&#8217;de histogram olu\u015fturmak roket bilimi de\u011fildir, ancak bunun yararl\u0131 olabilece\u011fi durumlar\u0131n fark\u0131nda olmal\u0131s\u0131n\u0131z.<\/p><h3 class=\"wp-block-heading\"> 1. B\u00fcy\u00fck verileri sunmak<\/h3><p> \u00d6\u011frencilerin \u00f6rne\u011fini hat\u0131rl\u0131yor musunuz? Bazen verileri normal bir grafikte (sat\u0131r, s\u00fctun veya \u00e7ubuk) sunmak zordur. Ancak histogramla kutular olu\u015fturabilir ve b\u00fcy\u00fck verileri basit bir grafikte sunabilirsiniz.<\/p><h3 class=\"wp-block-heading\"> 2. Da\u011f\u0131t\u0131m\u0131 anlamak<\/h3><p> Histogram, verileri yaln\u0131zca b\u00f6lmelere b\u00f6lmekle kalmaz, ayn\u0131 zamanda da\u011f\u0131l\u0131m\u0131 anlaman\u0131za da yard\u0131mc\u0131 olur. A\u015fa\u011f\u0131daki histograma bakt\u0131\u011f\u0131n\u0131zda \u00e7o\u011fu \u00f6\u011frencinin 40 ile 80 aras\u0131nda puan ald\u0131\u011f\u0131n\u0131, 23 \u00f6\u011frencinin ise 60&#8217;\u0131n \u00fczerinde puan ald\u0131\u011f\u0131n\u0131 anlayabilirsiniz.<\/p><h3 class=\"wp-block-heading\"> 3. Karar vermede yard\u0131mc\u0131 olmak<\/h3><p> Histogram kullanarak hangi \u00f6\u011frencilerin performanslar\u0131 \u00fczerinde \u00e7al\u0131\u015fmas\u0131 gerekti\u011fini kolayca belirleyebilirsiniz. Da\u011f\u0131t\u0131m numaralar\u0131n\u0131 \u00f6\u011frendikten sonra her da\u011f\u0131t\u0131ma ayr\u0131 ayr\u0131 odaklanabilirsiniz.<\/p><h2 class=\"wp-block-heading\"> Kutular nedir?<\/h2><p> Bin (Kova), olu\u015fum s\u0131kl\u0131\u011f\u0131n\u0131 da\u011f\u0131tt\u0131\u011f\u0131n\u0131z bir de\u011fer aral\u0131\u011f\u0131d\u0131r. Normalde birisi histogram olu\u015fturdu\u011funda \u00f6nceden b\u00f6lmeler olu\u015fturmas\u0131 gerekir, ancak Excel&#8217;de histogram olu\u015ftururken b\u00f6lmeler olu\u015fturman\u0131za gerek yoktur.<\/p><h2 class=\"wp-block-heading\"> Sonunda<\/h2><p> Excel 2016 kullan\u0131yorsan\u0131z histogram olu\u015fturman\u0131n tek t\u0131klamayla kolay bir yolu vard\u0131r \u00e7\u00fcnk\u00fc histogram zaten oradad\u0131r. Aksi takdirde \u201cTarama Arac\u0131 Paketi\u201dni kullanabilirsiniz ancak kullanabilmek i\u00e7in \u00f6nce onu y\u00fcklemeniz gerekir.<\/p><p> Bana sorarsan\u0131z histogram olu\u015fturmak i\u00e7in en sevdi\u011fim y\u00f6ntem pivot tablo kullanmakt\u0131r \u00e7\u00fcnk\u00fc \u00e7ok daha dinamiktir ve grafi\u011fi kontrol etmek i\u00e7in size daha fazla se\u00e7enek sunar.<\/p><p> Ama \u015fimdi bana bir \u015fey s\u00f6ylemelisin. <strong>En sevdi\u011finiz y\u00f6ntem hangisi?<\/strong><\/p><p> D\u00fc\u015f\u00fcncelerinizi yorum k\u0131sm\u0131nda benimle payla\u015fmay\u0131 unutmay\u0131n, sizden haber almay\u0131 \u00e7ok isterim. Ve l\u00fctfen bu g\u00f6nderiyi arkada\u015flar\u0131n\u0131zla payla\u015fmay\u0131 unutmay\u0131n, eminim onlar da bundan keyif alacaklard\u0131r.<\/p><h2 class=\"wp-block-heading\"> Daha Fazla Grafik \u0130pu\u00e7lar\u0131 ve \u00d6\u011freticiler<\/h2><ul><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/tr\/yatay-bir-cizgi-ekle\/\">Excel&#8217;deki bir grafi\u011fe yatay \u00e7izgi ekleme<\/a><\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/tr\/dikey-bir-cizgi-ekle\/\">Excel&#8217;deki bir grafi\u011fe dikey \u00e7izgi nas\u0131l eklenir<\/a><\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/tr\/kursun-tahtasi\/\">Excel&#8217;de Madde \u0130\u015fareti Grafi\u011fi Nas\u0131l Olu\u015fturulur<\/a><\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/tr\/dinamik-grafik-araligi\/\">Excel&#8217;de Dinamik Grafik Aral\u0131\u011f\u0131 Nas\u0131l Olu\u015fturulur<\/a><\/li><li> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/tr\/dinamik-grafik-basligi\/\">Excel&#8217;de Dinamik Grafik Ba\u015fl\u0131\u011f\u0131 Nas\u0131l Olu\u015fturulur<\/a><\/li><\/ul>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-1673","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Excel&#039;de H\u0130STOGRAM nas\u0131l olu\u015fturulur? (E\u011fitim 2023)<\/title>\n<meta name=\"description\" content=\"Bu e\u011fitimde, Windows&#039;ta Excel&#039;de ilk HISTOGRAM grafi\u011finizi olu\u015fturmak i\u00e7in basit bir ADIM ADIM s\u00fcrecini \u00f6\u011freneceksiniz.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/tr\/histogram\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;de H\u0130STOGRAM nas\u0131l olu\u015fturulur? (E\u011fitim 2023)\" \/>\n<meta property=\"og:description\" content=\"Bu e\u011fitimde, Windows&#039;ta Excel&#039;de ilk HISTOGRAM grafi\u011finizi olu\u015fturmak i\u00e7in basit bir ADIM ADIM s\u00fcrecini \u00f6\u011freneceksiniz.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/histogram\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:00:58+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/etapes-pour-creer-un-histogramme-dans-excel-toute-version-1.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data1\" content=\"11 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/histogram\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/histogram\/\",\"name\":\"Excel&#39;de H\u0130STOGRAM nas\u0131l olu\u015fturulur? (E\u011fitim 2023)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/histogram\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/histogram\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/etapes-pour-creer-un-histogramme-dans-excel-toute-version-1.png\",\"datePublished\":\"2023-11-11T18:18:59+00:00\",\"dateModified\":\"2023-12-10T06:00:58+00:00\",\"description\":\"Bu e\u011fitimde, Windows&#39;ta Excel&#39;de ilk HISTOGRAM grafi\u011finizi olu\u015fturmak i\u00e7in basit bir ADIM ADIM s\u00fcrecini \u00f6\u011freneceksiniz.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/histogram\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/histogram\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/histogram\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/etapes-pour-creer-un-histogramme-dans-excel-toute-version-1.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/etapes-pour-creer-un-histogramme-dans-excel-toute-version-1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/histogram\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel&#39;de hi\u0307stogram nas\u0131l olu\u015fturulur?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\",\"url\":\"https:\/\/exceladvisor.org\/tr\/\",\"name\":\"Excel Advisor\",\"description\":\"Veri hakimiyetine y\u00f6nelik nihai rehberiniz!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/tr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/tr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel&#39;de H\u0130STOGRAM nas\u0131l olu\u015fturulur? (E\u011fitim 2023)","description":"Bu e\u011fitimde, Windows&#39;ta Excel&#39;de ilk HISTOGRAM grafi\u011finizi olu\u015fturmak i\u00e7in basit bir ADIM ADIM s\u00fcrecini \u00f6\u011freneceksiniz.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/exceladvisor.org\/tr\/histogram\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel&#39;de H\u0130STOGRAM nas\u0131l olu\u015fturulur? (E\u011fitim 2023)","og_description":"Bu e\u011fitimde, Windows&#39;ta Excel&#39;de ilk HISTOGRAM grafi\u011finizi olu\u015fturmak i\u00e7in basit bir ADIM ADIM s\u00fcrecini \u00f6\u011freneceksiniz.","og_url":"https:\/\/exceladvisor.org\/tr\/histogram\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:00:58+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/etapes-pour-creer-un-histogramme-dans-excel-toute-version-1.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tahmini okuma s\u00fcresi":"11 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/histogram\/","url":"https:\/\/exceladvisor.org\/tr\/histogram\/","name":"Excel&#39;de H\u0130STOGRAM nas\u0131l olu\u015fturulur? (E\u011fitim 2023)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/histogram\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/histogram\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/etapes-pour-creer-un-histogramme-dans-excel-toute-version-1.png","datePublished":"2023-11-11T18:18:59+00:00","dateModified":"2023-12-10T06:00:58+00:00","description":"Bu e\u011fitimde, Windows&#39;ta Excel&#39;de ilk HISTOGRAM grafi\u011finizi olu\u015fturmak i\u00e7in basit bir ADIM ADIM s\u00fcrecini \u00f6\u011freneceksiniz.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/histogram\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/histogram\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/histogram\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/etapes-pour-creer-un-histogramme-dans-excel-toute-version-1.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/etapes-pour-creer-un-histogramme-dans-excel-toute-version-1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/histogram\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel&#39;de hi\u0307stogram nas\u0131l olu\u015fturulur?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/tr\/#website","url":"https:\/\/exceladvisor.org\/tr\/","name":"Excel Advisor","description":"Veri hakimiyetine y\u00f6nelik nihai rehberiniz!","publisher":{"@id":"https:\/\/exceladvisor.org\/tr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/tr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/tr\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/tr\/","logo":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1673","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/comments?post=1673"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1673\/revisions"}],"predecessor-version":[{"id":2451,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1673\/revisions\/2451"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=1673"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}