{"id":1663,"date":"2023-11-12T16:27:53","date_gmt":"2023-11-12T16:27:53","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/kasirga-tablosu\/"},"modified":"2023-12-10T06:01:21","modified_gmt":"2023-12-10T06:01:21","slug":"kasirga-tablosu","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/kasirga-tablosu\/","title":{"rendered":"Excel&#39;de kas\u0131rga grafi\u011fi nas\u0131l olu\u015fturulur?"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-1238572831\"><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>Excel Tornado grafi\u011fi, daha iyi karar vermek i\u00e7in verilerini analiz etmek isteyenler i\u00e7in kullan\u0131\u015fl\u0131d\u0131r. Bunun en iyi kullan\u0131m\u0131 duyarl\u0131l\u0131k analizidir, ancak kar\u015f\u0131la\u015ft\u0131rma amac\u0131yla da kullanabilirsiniz. Bu nedenle Excel dan\u0131\u015fman\u0131ndaki <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/tr\/gelismis-grafikler\/\">geli\u015fmi\u015f grafikler<\/a> listemizin bir par\u00e7as\u0131d\u0131r.<\/p><h2 id=\"t-1598010525958\" class=\"wp-block-heading\"> Excel Kas\u0131rga Grafi\u011fi Nedir?<\/h2><p> Excel Tornado grafi\u011fi, birbirinin kar\u015f\u0131s\u0131nda iki veri \u00e7ubu\u011funun bulundu\u011fu \u00e7ift tarafl\u0131 bir \u00e7ubuk grafi\u011fe (kas\u0131rgaya benzer) benzer ve bunlar\u0131 kar\u015f\u0131la\u015ft\u0131rmay\u0131 kolayla\u015ft\u0131r\u0131r. Dedi\u011fim gibi duyarl\u0131l\u0131k analizi i\u00e7in kullan\u0131\u015fl\u0131 bir ara\u00e7 ama de\u011ferleri kar\u015f\u0131la\u015ft\u0131rman\u0131z gerekti\u011finde kullanabilirsiniz.<\/p><p> <a href=\"https:\/\/en.wikipedia.org\/wiki\/Tornado_diagram\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">Wikipedia&#8217;ya<\/a> g\u00f6re:<\/p><p> Bu, verilerin dikey olarak en y\u00fcksekten en d\u00fc\u015f\u00fc\u011fe do\u011fru s\u0131raland\u0131\u011f\u0131 \u00f6zel bir \u00e7ubuk grafik t\u00fcr\u00fcd\u00fcr. Bu \u015fekliyle bir kas\u0131rgaya benziyor.<\/p><h2 id=\"t-1598010525959\" class=\"wp-block-heading\"> Excel&#8217;de Kas\u0131rga Grafi\u011fi Nas\u0131l Olu\u015fturulur<\/h2><p> Excel&#8217;de kas\u0131rga grafi\u011fi olu\u015fturmak i\u00e7in varsay\u0131lan bir se\u00e7enek yoktur, ancak varsay\u0131lan \u00e7ubuk grafi\u011fini kullanabilir ve \u00f6zelle\u015ftirebilirsiniz. Bug\u00fcn bu yaz\u0131da onu nas\u0131l olu\u015fturaca\u011f\u0131m\u0131z\u0131 \u00f6\u011frenece\u011fiz.<\/p><p> Devam etmek i\u00e7in bu \u00f6rnek dosyay\u0131 buradan indirdi\u011finizden emin olun. Excel&#8217;de kas\u0131rga grafi\u011fi olu\u015fturmak i\u00e7in a\u015fa\u011f\u0131daki ad\u0131mlar\u0131 izlemeniz gerekir:<\/p><ol><li> \u00d6ncelikle Store-1 verisini negatif de\u011fere \u00e7evirmeniz gerekmektedir. Bu, veri \u00e7ubuklar\u0131n\u0131 farkl\u0131 y\u00f6nlerde g\u00f6r\u00fcnt\u00fclemenize yard\u0131mc\u0131 olacakt\u0131r. Bunu yapmak i\u00e7in -1 ile \u00e7arpman\u0131z yeterlidir (bu <a href=\"https:\/\/exceladvisor.org\/tr\/ozel-carpim-yapistir\/\">\u00f6zel ak\u0131ll\u0131 hamur ipucuna<\/a> bir g\u00f6z at\u0131n, buna bay\u0131laca\u011f\u0131n\u0131za bahse girerim). <br><img loading=\"lazy\" decoding=\"async\" title=\"ad\u0131m 1-bu-veri-tablosunu-negatif-de\u011ferlerle-kullanarak-excel'de-kas\u0131rga-grafi\u011fi-olu\u015fturun\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/step1-creer-un-graphique-tornade-dans-Excel-en-utilisant-cette-table-de-donnees-avec-des-valeurs-negatives.png\" sizes=\"auto, \" srcset=\"\" alt=\"step1-create-tornado-chart-in-excel-by-using-this-data-table-with-negative-values\" width=\"465\" height=\"259\"><\/li><li> Daha sonra bu verileri kullanarak bir \u00e7ubuk grafik ekleyin. Ekle sekmesine gidin \u279c Grafikler \u279c \u00c7ubuk grafik ve bununla a\u015fa\u011f\u0131daki gibi iki taraf\u0131n\u0131z\u0131n oldu\u011fu bir \u00e7ubuk grafik elde edeceksiniz (bir taraf pozitif de\u011ferler i\u00e7in, di\u011feri negatif de\u011ferler i\u00e7indir). <br><img loading=\"lazy\" decoding=\"async\" title=\"ad\u0131m2-kas\u0131rga-grafi\u011fini-olu\u015fturmak i\u00e7in-bir-\u00e7ubuk-grafi\u011fini-ekleyin\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/step2-inserez-un-graphique-a-barres-pour-creer-un-graphique-en-tornade.png\" sizes=\"auto, \" srcset=\"\" alt=\"step2-insert-a-bar-chart-to-create-tornado-chart\" width=\"453\" height=\"283\"><\/li><li> Buradan eksen etiketini se\u00e7in ve bi\u00e7imlendirme se\u00e7eneklerini a\u00e7\u0131n ve bi\u00e7imlendirme se\u00e7eneklerinde eksen se\u00e7enekleri \u279c Etiketler \u279c Etiket konumu&#8217;na gidin. Etiket konumunu \u201cAlt\u201d olarak de\u011fi\u015ftirin. <br><img loading=\"lazy\" decoding=\"async\" title=\"3. ad\u0131m eksen etiketi konumunu a\u015fa\u011f\u0131 konuma de\u011fi\u015ftirmektir\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/letape-3-consiste-a-changer-la-position-de-letiquette-de-laxe-en-bas.png\" sizes=\"auto, \" srcset=\"\" alt=\"step3 is to change axis label position to low\" width=\"269\" height=\"381\"><\/li><li> Daha sonra eksen konumunu ters s\u0131rada de\u011fi\u015ftirmeniz gerekir. Bu, her iki taraftaki \u00e7ubuklar\u0131 ayarlayacakt\u0131r ve bunu yapmak i\u00e7in Eksen Se\u00e7enekleri \u279c Eksen Konumu \u279c \u201cKategori ters s\u0131rada\u201d se\u00e7ene\u011fini i\u015faretleyin. <br><img loading=\"lazy\" decoding=\"async\" title=\"ad\u0131m 4-bir kas\u0131rga grafi\u011fi olu\u015fturmak i\u00e7in \u00e7ubuk grafi\u011fine ters kategoriyi uygulay\u0131n\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/etape-4-appliquez-la-categorie-inverse-au-graphique-a-barres-pour-creer-un-graphique-en-tornade.png\" sizes=\"auto, \" srcset=\"\" alt=\"step4-apply-reverse-category-to-the-bar-chart-to-create-a-tornado-chart\" width=\"299\" height=\"165\"><\/li><li> \u015eimdi seri bo\u015flu\u011funu ve bo\u015fluk geni\u015fli\u011fini de\u011fi\u015ftirmeniz gerekiyor. Bu, veri \u00e7ubuklar\u0131n\u0131n birbiriyle uyumlu hale getirilmesine yard\u0131mc\u0131 olacakt\u0131r ve bunun i\u00e7in Seri Se\u00e7enekleri -&gt; Seri \u00d6rt\u00fc\u015fmesini %100&#8217;e ve Bo\u015fluk Geni\u015fli\u011fini %10&#8217;a De\u011fi\u015ftir se\u00e7ene\u011fine gidin. <br><img loading=\"lazy\" decoding=\"async\" title=\"ad\u0131m5-seriyi-bo\u015fluk-ve-bo\u015fluk-geni\u015fli\u011fini de\u011fi\u015ftir\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/step5-change-change-series-gap-et-gap-width.png\" sizes=\"auto, \" srcset=\"\" alt=\"step5-change-change-series-gap-and-gap-width\" width=\"382\" height=\"316\"><\/li><li> Ve yatay eksen numaras\u0131 format\u0131n\u0131 de\u011fi\u015ftirmeniz gerekiyor. Bunun i\u00e7in Eksen Se\u00e7enekleri \u279c Say\u0131 \u279c \u00f6zel se\u00e7ene\u011fini se\u00e7in \u279c a\u015fa\u011f\u0131daki format\u0131 yap\u0131\u015ft\u0131r\u0131n ve ekle&#8217;ye t\u0131klay\u0131n. <br><img loading=\"lazy\" decoding=\"async\" title=\"ad\u0131m6-say\u0131-bi\u00e7imlendirmesini de\u011fi\u015ftir\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/step6-changer-le-formatage-des-nombres.png\" sizes=\"auto, \" srcset=\"\" alt=\"step6-change-number-formatting\" width=\"269\" height=\"191\"><\/li><li> Sonunda, t\u0131pk\u0131 yukar\u0131daki ad\u0131mda oldu\u011fu gibi, Ma\u011faza-1&#8217;in veri etiketleri format\u0131n\u0131 olumsuz i\u015faretler g\u00f6stermeyecek \u015fekilde de\u011fi\u015ftirmeniz gerekir ve bu go-to-etiket se\u00e7ene\u011fi i\u00e7in \u279c Say\u0131 \u279c \u00f6zel se\u00e7in \u279c a\u015fa\u011f\u0131daki format\u0131 yap\u0131\u015ft\u0131r\u0131n ve Ekle&#8217;yi t\u0131klay\u0131n.<\/li><\/ol><p> <strong>Tebrikler<\/strong> , art\u0131k e-tablonuzda a\u015fa\u011f\u0131daki gibi ilk kas\u0131rga grafi\u011finiz var. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-36152\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/graphique-tornade-utilisant-un-graphique-a-barres.png\" sizes=\"auto, \" srcset=\"\" alt=\"\u00e7ubuk grafik kullanan kas\u0131rga grafi\u011fi\" width=\"555\" height=\"335\"><\/figure><\/div><p> Grafi\u011finiz i\u00e7in <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/tr\/dinamik-grafik-araligi\/\">dinamik bir grafik aral\u0131\u011f\u0131<\/a> da olu\u015fturabilirsiniz, b\u00f6ylece verileri g\u00fcncellemeniz gerekti\u011finde grafi\u011fi tekrar tekrar g\u00fcncellemenize gerek kalmaz.<\/p><h2 id=\"t-1598010525960\" class=\"wp-block-heading\"> Ko\u015fullu bi\u00e7imlendirmeyi kullanarak Tornado grafi\u011fi olu\u015fturma<\/h2><p> Yukar\u0131daki y\u00f6ntemin aksine, ko\u015fullu bi\u00e7imlendirmeyi de kullanabilirsiniz. Ko\u015fullu bi\u00e7imlendirmeyle kas\u0131rga grafi\u011fi olu\u015fturmak i\u00e7in:<\/p><ul><li> A\u015fa\u011f\u0131daki anl\u0131k g\u00f6r\u00fcnt\u00fcde oldu\u011fu gibi verilerinizi \u00e7izmeniz yeterlidir. G\u00f6rd\u00fc\u011f\u00fcn\u00fcz gibi tabloda her iki ma\u011fazaya (ma\u011faza 1 ve ma\u011faza 2) ait verileriniz var. <br><img loading=\"lazy\" decoding=\"async\" title=\"1-ko\u015fullu-bi\u00e7imlendirmeyi kullanarak-excel'de-kas\u0131rga-grafi\u011fi-olu\u015fturma tarihi\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-date-pour-creer-un-graphique-tornade-dans-Excel-en-utilisant-la-mise-en-forme-conditionnelle.png\" sizes=\"auto, \" srcset=\"\" alt=\"1-date-to-create-a-tornado-chart-in-excel-using-conditional-formatting\" width=\"571\" height=\"279\"><\/li><li> Bu nedenle \u00f6ncelikle ma\u011faza 1&#8217;in s\u00fctununu sa\u011fa ve ma\u011faza 2&#8217;nin s\u00fctununu sola hizalay\u0131n. <br><img loading=\"lazy\" decoding=\"async\" title=\"2-metin hizalamas\u0131n\u0131 de\u011fi\u015ftir\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-modifier-lalignement-du-texte.png\" sizes=\"auto, \" srcset=\"\" alt=\"2-change-text-alignment\" width=\"616\" height=\"301\"><\/li><li> Bir sonraki \u015fey, ko\u015fullu bi\u00e7imlendirmeyi uygulamakt\u0131r. Her iki s\u00fctuna da tek tek uygulaman\u0131z gerekir.<\/li><li> Oradan, 1. s\u00fctunu depola&#8217;y\u0131 se\u00e7in ve Ana Sayfa sekmesine gidin \u279c Stiller \u279c Ko\u015fullu Bi\u00e7imlendirme \u279c Veri \u00c7ubuklar\u0131 \u279c Di\u011fer Kurallar. <br><img loading=\"lazy\" decoding=\"async\" title=\"3-art\u0131ya-git kurallar\u0131\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-aller-a-plus-de-regles.png\" sizes=\"auto, \" srcset=\"\" alt=\"3- go-to-more-rules\" width=\"364\" height=\"423\"><\/li><li> &#8220;Di\u011fer Kurallar&#8221; ileti\u015fim kutusunda, veri \u00e7ubuklar\u0131 olu\u015fturmak i\u00e7in a\u015fa\u011f\u0131daki \u00f6\u011feleri tan\u0131mlaman\u0131z gerekir:<ul><li> Renk: \u0130stedi\u011finiz renk.<\/li><li> Kenarl\u0131k: Kat\u0131 (istenirse)<\/li><li> Y\u00f6n: sa\u011fdan sola. <br><img loading=\"lazy\" decoding=\"async\" title=\"4-veri \u00e7ubu\u011fu-depolama-1 i\u00e7in-ekleme se\u00e7ene\u011fi\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-ajouter-une-option-pour-le-magasin-de-barre-de-donnees-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"4-add-option-for-data-bar-store-1\" width=\"404\" height=\"554\"><\/li><\/ul><\/li><li> Bundan sonra, verileri ma\u011faza 1 s\u00fctununa uygulamak i\u00e7in Tamam&#8217;\u0131 t\u0131klay\u0131n.<\/li><li> Yapman\u0131z gereken bir sonraki \u015fey, ikincisinde kulland\u0131\u011f\u0131n\u0131z y\u00f6ntemi kullanarak 2 s\u00fctunu depolamak i\u00e7in bir \u00e7ubuk uygulamakt\u0131r. A\u015fa\u011f\u0131daki ayarlar\u0131 kullanarak s\u00fctunu se\u00e7ip ek kurallardan veri \u00e7ubuklar\u0131n\u0131 uygulaman\u0131z yeterlidir:<ul><li> Renk : \u0130stedi\u011finiz renk<\/li><li> Kenarl\u0131k: Kat\u0131 (istenirse)<\/li><li> Y\u00f6n: soldan sa\u011fa. <br><img loading=\"lazy\" decoding=\"async\" title=\"5-veri \u00e7ubu\u011fu-depolama-2 i\u00e7in-ekleme se\u00e7ene\u011fi\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-ajouter-une-option-pour-le-magasin-de-barres-de-donnees-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"5-add-option-for-data-bar-store-2\" width=\"399\" height=\"547\"><\/li><\/ul><\/li><li> Bu noktada, veri \u00e7ubuklar\u0131n\u0131 ko\u015fullu bi\u00e7imlendirmeyle uygulad\u0131\u011f\u0131n\u0131z kas\u0131rga grafi\u011fini i\u00e7eren bir tablonuz var. <br><img loading=\"lazy\" decoding=\"async\" title=\"6-son-kas\u0131rga-grafi\u011fi-cf ile\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-carte-finale-de-tornade-avec-cf.png\" sizes=\"auto, \" srcset=\"\" alt=\"6-final-tornado-chart-with-cf\" width=\"508\" height=\"248\"><\/li><\/ul><h2 id=\"t-1598010525961\" class=\"wp-block-heading\"> Excel&#8217;de Kas\u0131rga H\u00fccre \u0130\u00e7i Grafi\u011fi Olu\u015fturmak i\u00e7in REPT \u0130\u015flevini Kullan\u0131n<\/h2><p> \u0130\u015fleri farkl\u0131 bir \u015fekilde yapmay\u0131 veya eski \u015feyleri yapman\u0131n yeni, al\u0131\u015f\u0131lmad\u0131k yollar\u0131n\u0131 denemeyi seviyorum. Bu noktada, \u00e7ubuk grafikle ve ayr\u0131ca ko\u015fullu bi\u00e7imlendirmeyle kas\u0131rga grafi\u011finin nas\u0131l olu\u015fturulaca\u011f\u0131n\u0131 biliyorsunuz.<\/p><p> Ancak deneyebilece\u011fimiz bir \u015fey daha var, o da REPT i\u015flevidir (bunun hakk\u0131nda daha fazla bilgi edinmek istiyorsan\u0131z bu i\u015flev sayfas\u0131na g\u00f6z at\u0131n). REPT fonksiyonu ile TORNADO grafi\u011fi olu\u015fturmak i\u00e7in a\u015fa\u011f\u0131daki ad\u0131mlar\u0131 takip edebilirsiniz:<\/p><ol><li> \u00d6ncelikle a\u015fa\u011f\u0131daki anl\u0131k g\u00f6r\u00fcnt\u00fcde yapt\u0131\u011f\u0131m\u0131z gibi verilerinizi ayarlaman\u0131z gerekir. Burada \u00fcr\u00fcn adlar\u0131n\u0131 i\u00e7eren bir s\u00fctununuz ve her ma\u011faza i\u00e7in iki s\u00fctununuz var (biri de\u011ferler i\u00e7in, ikincisi de\u011ferler i\u00e7in). <br><img loading=\"lazy\" decoding=\"async\" title=\"1-kas\u0131rga grafi\u011fi i\u00e7in-veri-tekrarlama-fonksiyonu\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-donnees-utiliser-la-fonction-rept-pour-le-graphique-tornade.png\" sizes=\"auto, \" srcset=\"\" alt=\"1-data-touse-rept-function-for-tornado-chart\" width=\"610\" height=\"240\"><\/li><li> Buradan 1. ma\u011fazan\u0131n veri \u00e7ubu\u011fu s\u00fctununa REPT fonksiyonunu eklememiz gerekiyor ve bunun i\u00e7in a\u015fa\u011f\u0131daki form\u00fcl\u00fc ilk h\u00fccreye ekleyip son h\u00fccreye s\u00fcr\u00fcklememiz gerekiyor.=REPT(\u201c|\u201d,D3\/10) <br><img loading=\"lazy\" decoding=\"async\" title=\"2-uygulama-rept-fonksiyonu-depolama-bir-s\u00fctun\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-appliquer-la-fonction-rept-stocker-une-colonne.png\" sizes=\"auto, \" srcset=\"\" alt=\"2-apply-rept-function-store-one-column\" width=\"543\" height=\"283\"><\/li><li> Bundan sonra s\u00fctunun tamam\u0131n\u0131 se\u00e7in ve a\u015fa\u011f\u0131dakileri d\u00fczenleyin:<ul><li> Yaz\u0131 tipi \u201cPlayBill\u201ddir (bu yaz\u0131 tipiyle veri \u00e7ubu\u011fu g\u00f6r\u00fcn\u00fcm\u00fcne sahip olabilirsiniz).<\/li><li> S\u00fctun geni\u015fli\u011fini en b\u00fcy\u00fck veri \u00e7ubu\u011funa veya daha b\u00fcy\u00fck bir de\u011fere de\u011fi\u015ftirin.<\/li><li> Yaz\u0131 tipi rengini turuncu olarak de\u011fi\u015ftirin.<\/li><li> Metin hizalamas\u0131n\u0131 sa\u011fdan sola de\u011fi\u015ftirin. <br><img loading=\"lazy\" decoding=\"async\" style=\"display: block; margin-left: auto; margin-right: auto;\" title=\"3-yaz\u0131 tipi hizalama rengini de\u011fi\u015ftir\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-changer-la-couleur-dalignement-de-la-police.png\" sizes=\"auto, \" srcset=\"\" alt=\"3-change-font-alignment-color\" width=\"497\" height=\"395\"><\/li><\/ul><\/li><li> Daha sonra, ma\u011faza2 s\u00fctununa veri \u00e7ubuklar\u0131 eklemek ve a\u015fa\u011f\u0131dakileri de\u011fi\u015ftirmek i\u00e7in ayn\u0131 y\u00f6ntemi izlemeniz gerekir:<ul><li> Yaz\u0131 tipi \u201cPlayBill\u201ddir (bu yaz\u0131 tipiyle veri \u00e7ubu\u011fu g\u00f6r\u00fcn\u00fcm\u00fcne sahip olabilirsiniz).<\/li><li> S\u00fctun geni\u015fli\u011fini en b\u00fcy\u00fck veri \u00e7ubu\u011funa veya daha b\u00fcy\u00fck bir de\u011fere de\u011fi\u015ftirin.<\/li><li> Yaz\u0131 tipi rengi ekleme<\/li><li> Metin hizalamas\u0131n\u0131 soldan sa\u011fa de\u011fi\u015ftirin. <br><img loading=\"lazy\" decoding=\"async\" style=\"display: block; margin-left: auto; margin-right: auto;\" title=\"4-tekrarlama fonksiyonlu son grafik\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-graphique-final-avec-fonction-rept.png\" sizes=\"auto, \" srcset=\"\" alt=\"4-final-chart-with-rept-function\" width=\"866\" height=\"346\"><\/li><\/ul><\/li><\/ol><h2 id=\"t-1598010525962\" class=\"wp-block-heading\"> \u00d6rnek dosya<\/h2><p> Daha fazla bilgi edinmek i\u00e7in <a href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/comment-creer-un-graphique-de-tornade-dans-excel.xlsx\" rel=\"nofollow\">bu \u00f6rnek dosyay\u0131 buradan indirin<\/a> .<\/p><h2 id=\"t-1598010525963\" class=\"wp-block-heading\"> \u00c7\u00f6z\u00fcm<\/h2><p> Baz\u0131lar\u0131 bu kas\u0131rga diyagramlar\u0131n\u0131, kar\u015f\u0131la\u015ft\u0131rma yaparak karar vermede yararl\u0131 bir ara\u00e7 olarak adland\u0131r\u0131yor. \u0130ki farkl\u0131 \u00f6\u011feyi veya tek bir \u00f6\u011feyi farkl\u0131 zaman dilimleri i\u00e7in kar\u015f\u0131la\u015ft\u0131rabilirsiniz.<\/p><p> \u0130\u015fte kas\u0131rga haritalar\u0131n\u0131n t\u00fcm hikayesi bu ve EVET bunlar\u0131 olu\u015fturmak i\u00e7in yaln\u0131zca 7 ADIM&#8217;a ihtiyac\u0131n\u0131z var. Size s\u00f6ylemeyi unuttu\u011fum bir \u015fey de, h\u00fccrede bir kas\u0131rga grafi\u011fi olu\u015fturmak i\u00e7in ko\u015fullu bi\u00e7imlendirmeyi veya REPT i\u015flevini de kullanabilece\u011finizdir.<\/p><p> Umar\u0131m faydal\u0131 bulmu\u015fsunuzdur ve becerilerinizi bir sonraki seviyeye ta\u015f\u0131man\u0131za yard\u0131mc\u0131 olacakt\u0131r.<\/p><p> \u015eimdi bana bir \u015fey s\u00f6yle. <strong>Hi\u00e7 kas\u0131rga haritas\u0131 kulland\u0131n\u0131z m\u0131?<\/strong> L\u00fctfen yorum b\u00f6l\u00fcm\u00fcnde benimle payla\u015f\u0131n, sizden haber almay\u0131 \u00e7ok isterim. Ve bu ipucunu arkada\u015flar\u0131n\u0131zla payla\u015fmay\u0131 unutmay\u0131n. Eminim takdir edeceklerdir.<\/p><div class=\"gb-container gb-container-a61970aa gb-container-mt\"> <a class=\"gb-button gb-button-b4293c6c gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/tr\/excel-cizelgeleri\/\">Excel Grafik T\u00fcrleri<\/a><h2 class=\"gb-headline gb-headline-5bf2e581 gb-headline-text gb-headline-mt-heading\"> \u0130lgili e\u011fitimler <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-9b70abf1 gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-97a95c29\"><div class=\"gb-container gb-container-97a95c29\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/tr\/gozleme-grafigi\/\">KABARTMALI LEVHA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/huni-grafigi\/\">Huni grafi\u011fi<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/gantt-semasi\/\">Gantt \u015femas\u0131<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/sicaklik-haritasi\/\">S\u0131cakl\u0131k haritas\u0131<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-0636840f\"><div class=\"gb-container gb-container-0636840f\"><\/div><\/div><\/div><\/div>","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-1663","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 Kas\u0131rga Grafi\u011fi nas\u0131l olu\u015fturulur? (E\u011fitim 2023)<\/title>\n<meta name=\"description\" content=\"Bu, birbirinin kar\u015f\u0131s\u0131nda iki veri \u00e7ubu\u011funun bulundu\u011fu \u00e7ift tarafl\u0131 bir \u00e7ubuk grafi\u011fine (kas\u0131rgaya benzeyen) benzer.\" \/>\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\/kasirga-tablosu\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;de Kas\u0131rga Grafi\u011fi nas\u0131l olu\u015fturulur? (E\u011fitim 2023)\" \/>\n<meta property=\"og:description\" content=\"Bu, birbirinin kar\u015f\u0131s\u0131nda iki veri \u00e7ubu\u011funun bulundu\u011fu \u00e7ift tarafl\u0131 bir \u00e7ubuk grafi\u011fine (kas\u0131rgaya benzeyen) benzer.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/kasirga-tablosu\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:01:21+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/step1-creer-un-graphique-tornade-dans-Excel-en-utilisant-cette-table-de-donnees-avec-des-valeurs-negatives.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=\"7 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/kasirga-tablosu\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/kasirga-tablosu\/\",\"name\":\"Excel&#39;de Kas\u0131rga Grafi\u011fi nas\u0131l olu\u015fturulur? (E\u011fitim 2023)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/kasirga-tablosu\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/kasirga-tablosu\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/step1-creer-un-graphique-tornade-dans-Excel-en-utilisant-cette-table-de-donnees-avec-des-valeurs-negatives.png\",\"datePublished\":\"2023-11-12T16:27:53+00:00\",\"dateModified\":\"2023-12-10T06:01:21+00:00\",\"description\":\"Bu, birbirinin kar\u015f\u0131s\u0131nda iki veri \u00e7ubu\u011funun bulundu\u011fu \u00e7ift tarafl\u0131 bir \u00e7ubuk grafi\u011fine (kas\u0131rgaya benzeyen) benzer.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/kasirga-tablosu\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/kasirga-tablosu\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/kasirga-tablosu\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/step1-creer-un-graphique-tornade-dans-Excel-en-utilisant-cette-table-de-donnees-avec-des-valeurs-negatives.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/step1-creer-un-graphique-tornade-dans-Excel-en-utilisant-cette-table-de-donnees-avec-des-valeurs-negatives.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/kasirga-tablosu\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel&#39;de kas\u0131rga grafi\u011fi 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 Kas\u0131rga Grafi\u011fi nas\u0131l olu\u015fturulur? (E\u011fitim 2023)","description":"Bu, birbirinin kar\u015f\u0131s\u0131nda iki veri \u00e7ubu\u011funun bulundu\u011fu \u00e7ift tarafl\u0131 bir \u00e7ubuk grafi\u011fine (kas\u0131rgaya benzeyen) benzer.","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\/kasirga-tablosu\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel&#39;de Kas\u0131rga Grafi\u011fi nas\u0131l olu\u015fturulur? (E\u011fitim 2023)","og_description":"Bu, birbirinin kar\u015f\u0131s\u0131nda iki veri \u00e7ubu\u011funun bulundu\u011fu \u00e7ift tarafl\u0131 bir \u00e7ubuk grafi\u011fine (kas\u0131rgaya benzeyen) benzer.","og_url":"https:\/\/exceladvisor.org\/tr\/kasirga-tablosu\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:01:21+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/step1-creer-un-graphique-tornade-dans-Excel-en-utilisant-cette-table-de-donnees-avec-des-valeurs-negatives.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tahmini okuma s\u00fcresi":"7 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/kasirga-tablosu\/","url":"https:\/\/exceladvisor.org\/tr\/kasirga-tablosu\/","name":"Excel&#39;de Kas\u0131rga Grafi\u011fi nas\u0131l olu\u015fturulur? (E\u011fitim 2023)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/kasirga-tablosu\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/kasirga-tablosu\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/step1-creer-un-graphique-tornade-dans-Excel-en-utilisant-cette-table-de-donnees-avec-des-valeurs-negatives.png","datePublished":"2023-11-12T16:27:53+00:00","dateModified":"2023-12-10T06:01:21+00:00","description":"Bu, birbirinin kar\u015f\u0131s\u0131nda iki veri \u00e7ubu\u011funun bulundu\u011fu \u00e7ift tarafl\u0131 bir \u00e7ubuk grafi\u011fine (kas\u0131rgaya benzeyen) benzer.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/kasirga-tablosu\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/kasirga-tablosu\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/kasirga-tablosu\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/step1-creer-un-graphique-tornade-dans-Excel-en-utilisant-cette-table-de-donnees-avec-des-valeurs-negatives.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/step1-creer-un-graphique-tornade-dans-Excel-en-utilisant-cette-table-de-donnees-avec-des-valeurs-negatives.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/kasirga-tablosu\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel&#39;de kas\u0131rga grafi\u011fi 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\/1663","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=1663"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1663\/revisions"}],"predecessor-version":[{"id":2509,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1663\/revisions\/2509"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=1663"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}