{"id":4766,"date":"2023-07-08T04:35:09","date_gmt":"2023-07-08T04:35:09","guid":{"rendered":"https:\/\/statorials.org\/tr\/excel-3d-kume-sutun-grafigi\/"},"modified":"2023-07-08T04:35:09","modified_gmt":"2023-07-08T04:35:09","slug":"excel-3d-kume-sutun-grafigi","status":"publish","type":"post","link":"https:\/\/statorials.org\/tr\/excel-3d-kume-sutun-grafigi\/","title":{"rendered":"Excel&#39;de 3b k\u00fcmelenmi\u015f histogram nas\u0131l olu\u015fturulur"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><strong>3B grupland\u0131r\u0131lm\u0131\u015f histogram,<\/strong> kategorik bir de\u011fi\u015fkene g\u00f6re grupland\u0131r\u0131lm\u0131\u015f birden fazla say\u0131sal de\u011fi\u015fkenin de\u011ferlerini g\u00f6rselle\u015ftirmek i\u00e7in 3B \u00e7ubuklar kullanan bir grafik t\u00fcr\u00fcd\u00fcr.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Bu e\u011fitimde, bir \u015firket i\u00e7in farkl\u0131 b\u00f6lgelerdeki iki farkl\u0131 \u00fcr\u00fcn\u00fcn sat\u0131\u015f\u0131n\u0131 g\u00f6steren a\u015fa\u011f\u0131daki 3B grupland\u0131r\u0131lm\u0131\u015f histogram\u0131n Excel&#8217;de nas\u0131l olu\u015fturulaca\u011f\u0131na ili\u015fkin ad\u0131m ad\u0131m bir \u00f6rnek sunulmaktad\u0131r:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37204 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/clus4.png\" alt=\"\" width=\"551\" height=\"337\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Hadi gidelim!<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>1. Ad\u0131m: Verileri girin<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">\u00d6ncelikle bir firman\u0131n iki farkl\u0131 \u00fcr\u00fcn\u00fcn\u00fcn farkl\u0131 b\u00f6lgelerdeki toplam sat\u0131\u015f\u0131n\u0131 g\u00f6steren a\u015fa\u011f\u0131daki veri setini girelim:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37199 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/clus1.png\" alt=\"\" width=\"464\" height=\"423\" srcset=\"\" sizes=\"auto, \"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Ad\u0131m 2: 3B K\u00fcmelenmi\u015f S\u00fctun Grafi\u011finin Eklenmesi<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Ard\u0131ndan, <strong>A1:C7<\/strong> h\u00fccre aral\u0131\u011f\u0131n\u0131 vurgulay\u0131n, \u00fcst \u015feritteki <strong>Ekle<\/strong> sekmesine t\u0131klay\u0131n ve ard\u0131ndan <strong>Grafikler<\/strong> grubundaki <strong>3B K\u00fcmelenmi\u015f S\u00fctun<\/strong> simgesine t\u0131klay\u0131n:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37200 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/clus2.png\" alt=\"\" width=\"457\" height=\"299\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Bu, a\u015fa\u011f\u0131daki 3B grupland\u0131r\u0131lm\u0131\u015f histogram\u0131 \u00fcretecektir:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37201 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/clus3.png\" alt=\"\" width=\"572\" height=\"347\" srcset=\"\" sizes=\"auto, \"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>3. Ad\u0131m: Grafi\u011fi \u00f6zelle\u015ftirin<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">\u00c7ubuklar\u0131n aral\u0131\u011f\u0131n\u0131 ve boyutunu ayarlamak i\u00e7in grafikteki \u00e7ubuklardan birine \u00e7ift t\u0131klay\u0131n.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>G\u00f6r\u00fcnt\u00fclenen Veri Serisini Bi\u00e7imlendir<\/strong> panelinde \u00e7ubuk grafi\u011fin bo\u015fluk derinli\u011fini ve geni\u015fli\u011fini ayarlayabilirsiniz:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37202 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/clus5.png\" alt=\"\" width=\"288\" height=\"497\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">A\u015fa\u011f\u0131dakilere dikkat et:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>Bo\u015fluk Derinli\u011fi<\/strong> : De\u011fer ne kadar y\u00fcksek olursa grafikte \u00e7ubuklar o kadar derin olur.<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>Bo\u015fluk geni\u015fli\u011fi<\/strong> : De\u011fer ne kadar y\u00fcksek olursa, bireysel \u00e7ubuklar da o kadar geni\u015f olur.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">\u00c7ubuklar\u0131n istedi\u011finiz gibi g\u00f6r\u00fcnmesini sa\u011flamak i\u00e7in bu de\u011ferleri ayarlamaktan \u00e7ekinmeyin.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Bu \u00f6rnek i\u00e7in de\u011ferleri varsay\u0131lan ayarlar\u0131nda b\u0131rakaca\u011f\u0131z.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Son olarak \u00e7ubuklar\u0131n rengini de\u011fi\u015ftirmekten, grafi\u011fe bir ba\u015fl\u0131k eklemekten ve Y ekseni i\u00e7in bir etiket eklemekten \u00e7ekinmeyin:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-37204 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/clus4.png\" alt=\"\" width=\"551\" height=\"337\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Nihai grafik, A ve B \u00fcr\u00fcnlerinin sat\u0131\u015flar\u0131n\u0131 y ekseni boyunca, b\u00f6lgeler ise x ekseni boyunca g\u00f6r\u00fcnt\u00fclenir.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Ek kaynaklar<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">A\u015fa\u011f\u0131daki e\u011fitimlerde Excel&#8217;de di\u011fer yayg\u0131n g\u00f6rselle\u015ftirmelerin nas\u0131l olu\u015fturulaca\u011f\u0131 a\u00e7\u0131klanmaktad\u0131r:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/tr\/kumelenmis-yigilmis-cubuk-grafik-excel\/\" target=\"_blank\" rel=\"noopener\">Excel&#8217;de K\u00fcmelenmi\u015f Y\u0131\u011f\u0131lm\u0131\u015f \u00c7ubuk Grafik Nas\u0131l Olu\u015fturulur<\/a><br \/> <a href=\"https:\/\/statorials.org\/tr\/cift-corek-excel-grafigi\/\" target=\"_blank\" rel=\"noopener\">Excel&#8217;de \u00c7ift Halka Grafi\u011fi Nas\u0131l Olu\u015fturulur<\/a><br \/> <a href=\"https:\/\/statorials.org\/tr\/excel-ceyrek-grafigi\/\" target=\"_blank\" rel=\"noopener\">Excel&#8217;de \u00c7eyrek Grafik Nas\u0131l Olu\u015fturulur<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>3B grupland\u0131r\u0131lm\u0131\u015f histogram, kategorik bir de\u011fi\u015fkene g\u00f6re grupland\u0131r\u0131lm\u0131\u015f birden fazla say\u0131sal de\u011fi\u015fkenin de\u011ferlerini g\u00f6rselle\u015ftirmek i\u00e7in 3B \u00e7ubuklar kullanan bir grafik t\u00fcr\u00fcd\u00fcr. Bu e\u011fitimde, bir \u015firket i\u00e7in farkl\u0131 b\u00f6lgelerdeki iki farkl\u0131 \u00fcr\u00fcn\u00fcn sat\u0131\u015f\u0131n\u0131 g\u00f6steren a\u015fa\u011f\u0131daki 3B grupland\u0131r\u0131lm\u0131\u015f histogram\u0131n Excel&#8217;de nas\u0131l olu\u015fturulaca\u011f\u0131na ili\u015fkin ad\u0131m ad\u0131m bir \u00f6rnek sunulmaktad\u0131r: Hadi gidelim! 1. Ad\u0131m: Verileri girin \u00d6ncelikle bir firman\u0131n [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"class_list":["post-4766","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Excel&#039;de 3D K\u00fcmelenmi\u015f Histogram Nas\u0131l Olu\u015fturulur - Statoryaller<\/title>\n<meta name=\"description\" content=\"Bu e\u011fitimde, ad\u0131m ad\u0131m bir \u00f6rnekle Excel&#039;de 3B grupland\u0131r\u0131lm\u0131\u015f histogram\u0131n nas\u0131l olu\u015fturulaca\u011f\u0131 a\u00e7\u0131klanmaktad\u0131r.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/statorials.org\/tr\/excel-3d-kume-sutun-grafigi\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;de 3D K\u00fcmelenmi\u015f Histogram Nas\u0131l Olu\u015fturulur - Statoryaller\" \/>\n<meta property=\"og:description\" content=\"Bu e\u011fitimde, ad\u0131m ad\u0131m bir \u00f6rnekle Excel&#039;de 3B grupland\u0131r\u0131lm\u0131\u015f histogram\u0131n nas\u0131l olu\u015fturulaca\u011f\u0131 a\u00e7\u0131klanmaktad\u0131r.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/tr\/excel-3d-kume-sutun-grafigi\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-08T04:35:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/clus4.png\" \/>\n<meta name=\"author\" content=\"Dr.benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dr.benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/tr\/excel-3d-kume-sutun-grafigi\/\",\"url\":\"https:\/\/statorials.org\/tr\/excel-3d-kume-sutun-grafigi\/\",\"name\":\"Excel&#39;de 3D K\u00fcmelenmi\u015f Histogram Nas\u0131l Olu\u015fturulur - Statoryaller\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/tr\/#website\"},\"datePublished\":\"2023-07-08T04:35:09+00:00\",\"dateModified\":\"2023-07-08T04:35:09+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48\"},\"description\":\"Bu e\u011fitimde, ad\u0131m ad\u0131m bir \u00f6rnekle Excel&#39;de 3B grupland\u0131r\u0131lm\u0131\u015f histogram\u0131n nas\u0131l olu\u015fturulaca\u011f\u0131 a\u00e7\u0131klanmaktad\u0131r.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/tr\/excel-3d-kume-sutun-grafigi\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/tr\/excel-3d-kume-sutun-grafigi\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/tr\/excel-3d-kume-sutun-grafigi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/statorials.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel&#39;de 3b k\u00fcmelenmi\u015f histogram nas\u0131l olu\u015fturulur\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/tr\/#website\",\"url\":\"https:\/\/statorials.org\/tr\/\",\"name\":\"Statorials\",\"description\":\"\u0130statistik okuryazarl\u0131\u011f\u0131 rehberiniz!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/tr\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"tr\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48\",\"name\":\"Dr.benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Dr.benjamin anderson\"},\"description\":\"Merhaba, ben Benjamin, emekli bir istatistik profes\u00f6r\u00fc ve Statorials \u00f6\u011fretmenine d\u00f6n\u00fc\u015ft\u00fcm. \u0130statistik alan\u0131ndaki kapsaml\u0131 deneyimim ve uzmanl\u0131\u011f\u0131mla, \u00f6\u011frencilerimi Statorials arac\u0131l\u0131\u011f\u0131yla g\u00fc\u00e7lendirmek i\u00e7in bilgilerimi payla\u015fmaya can at\u0131yorum. Daha fazlas\u0131n\u0131 bil\",\"sameAs\":[\"https:\/\/statorials.org\/tr\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel&#39;de 3D K\u00fcmelenmi\u015f Histogram Nas\u0131l Olu\u015fturulur - Statoryaller","description":"Bu e\u011fitimde, ad\u0131m ad\u0131m bir \u00f6rnekle Excel&#39;de 3B grupland\u0131r\u0131lm\u0131\u015f histogram\u0131n nas\u0131l olu\u015fturulaca\u011f\u0131 a\u00e7\u0131klanmaktad\u0131r.","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:\/\/statorials.org\/tr\/excel-3d-kume-sutun-grafigi\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel&#39;de 3D K\u00fcmelenmi\u015f Histogram Nas\u0131l Olu\u015fturulur - Statoryaller","og_description":"Bu e\u011fitimde, ad\u0131m ad\u0131m bir \u00f6rnekle Excel&#39;de 3B grupland\u0131r\u0131lm\u0131\u015f histogram\u0131n nas\u0131l olu\u015fturulaca\u011f\u0131 a\u00e7\u0131klanmaktad\u0131r.","og_url":"https:\/\/statorials.org\/tr\/excel-3d-kume-sutun-grafigi\/","og_site_name":"Statorials","article_published_time":"2023-07-08T04:35:09+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/clus4.png"}],"author":"Dr.benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"Dr.benjamin anderson","Tahmini okuma s\u00fcresi":"2 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/tr\/excel-3d-kume-sutun-grafigi\/","url":"https:\/\/statorials.org\/tr\/excel-3d-kume-sutun-grafigi\/","name":"Excel&#39;de 3D K\u00fcmelenmi\u015f Histogram Nas\u0131l Olu\u015fturulur - Statoryaller","isPartOf":{"@id":"https:\/\/statorials.org\/tr\/#website"},"datePublished":"2023-07-08T04:35:09+00:00","dateModified":"2023-07-08T04:35:09+00:00","author":{"@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48"},"description":"Bu e\u011fitimde, ad\u0131m ad\u0131m bir \u00f6rnekle Excel&#39;de 3B grupland\u0131r\u0131lm\u0131\u015f histogram\u0131n nas\u0131l olu\u015fturulaca\u011f\u0131 a\u00e7\u0131klanmaktad\u0131r.","breadcrumb":{"@id":"https:\/\/statorials.org\/tr\/excel-3d-kume-sutun-grafigi\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/tr\/excel-3d-kume-sutun-grafigi\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/tr\/excel-3d-kume-sutun-grafigi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/statorials.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel&#39;de 3b k\u00fcmelenmi\u015f histogram nas\u0131l olu\u015fturulur"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/tr\/#website","url":"https:\/\/statorials.org\/tr\/","name":"Statorials","description":"\u0130statistik okuryazarl\u0131\u011f\u0131 rehberiniz!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/tr\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"tr"},{"@type":"Person","@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48","name":"Dr.benjamin anderson","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/image\/","url":"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Dr.benjamin anderson"},"description":"Merhaba, ben Benjamin, emekli bir istatistik profes\u00f6r\u00fc ve Statorials \u00f6\u011fretmenine d\u00f6n\u00fc\u015ft\u00fcm. \u0130statistik alan\u0131ndaki kapsaml\u0131 deneyimim ve uzmanl\u0131\u011f\u0131mla, \u00f6\u011frencilerimi Statorials arac\u0131l\u0131\u011f\u0131yla g\u00fc\u00e7lendirmek i\u00e7in bilgilerimi payla\u015fmaya can at\u0131yorum. Daha fazlas\u0131n\u0131 bil","sameAs":["https:\/\/statorials.org\/tr"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts\/4766","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/comments?post=4766"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts\/4766\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/media?parent=4766"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/categories?post=4766"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/tags?post=4766"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}