{"id":1719,"date":"2023-11-09T19:51:50","date_gmt":"2023-11-09T19:51:50","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/adim-tablosu\/"},"modified":"2023-12-10T06:00:07","modified_gmt":"2023-12-10T06:00:07","slug":"adim-tablosu","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/adim-tablosu\/","title":{"rendered":"Excel&#39;de ad\u0131m grafi\u011fi nas\u0131l olu\u015fturulur?"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-3727675374\"><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>D\u00fczensiz aral\u0131klarla meydana gelen de\u011fi\u015fiklikleri g\u00f6stermek istiyorsan\u0131z ad\u0131m grafi\u011fi m\u00fckemmel bir grafiktir. \u0130\u015fte bu y\u00fczden <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/tr\/gelismis-grafikler\/\">geli\u015fmi\u015f kartlar listemizde<\/a> yer al\u0131yor. Trendi ve de\u011fi\u015fimin ger\u00e7ek zaman\u0131n\u0131 sunman\u0131za yard\u0131mc\u0131 olabilir. Ger\u00e7ekte ad\u0131m grafi\u011fi, \u00e7izgi grafi\u011fin geni\u015fletilmi\u015f versiyonudur. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/votre-tableau-des-etapes-est-pret-1.png\" sizes=\"\" srcset=\"\" alt=\"ad\u0131m grafi\u011finiz haz\u0131r\"><\/figure><\/div><p> \u00c7izgi grafi\u011fin aksine, veri noktalar\u0131n\u0131 k\u0131sa mesafeli bir \u00e7izgi kullanarak birbirine ba\u011flamaz. Asl\u0131nda veri noktalar\u0131n\u0131 birbirine ba\u011flamak i\u00e7in dikey ve yatay \u00e7izgiler kullan\u0131r. \u015eimdi k\u00f6t\u00fc haber \u015fu: Excel&#8217;de ad\u0131m grafi\u011fi olu\u015fturmak i\u00e7in varsay\u0131lan bir se\u00e7enek yoktur. Ancak k\u0131sa s\u00fcrede olu\u015fturmak i\u00e7in takip edilmesi kolay birka\u00e7 ad\u0131m\u0131 kullanabilirsiniz.<\/p><p> Bug\u00fcn bu makalede, Excel&#8217;de ad\u0131m ad\u0131m bir grafik olu\u015fturmak i\u00e7in sizinle ad\u0131m ad\u0131m bir s\u00fcre\u00e7 payla\u015fmak istiyorum. Ayr\u0131ca duruma g\u00f6re en iyi grafi\u011fi se\u00e7menize yard\u0131mc\u0131 olacak \u00e7izgi grafik ile ad\u0131m grafi\u011fi aras\u0131ndaki fark\u0131 da \u00f6\u011freneceksiniz.<\/p><h2 class=\"wp-block-heading\"> \u00c7izgi Grafi\u011fi ve Ad\u0131m Grafi\u011fi Kar\u015f\u0131la\u015ft\u0131rmas\u0131<\/h2><p> Burada \u00e7izgi grafi\u011fi ile ad\u0131m grafi\u011fi aras\u0131nda baz\u0131 farklar var ve bu noktalar ad\u0131m grafi\u011finin \u00f6nemini anlaman\u0131za yard\u0131mc\u0131 olacakt\u0131r.<\/p><h3 class=\"wp-block-heading\"> 1. De\u011fi\u015fimin tam zaman\u0131<\/h3><p> Bir d\u00f6n\u00fcm noktas\u0131 grafi\u011fi, bir de\u011fi\u015fikli\u011fin tam zaman\u0131n\u0131 sunman\u0131za yard\u0131mc\u0131 olabilir. \u00d6te yandan, \u00e7izgi grafik de\u011fi\u015fimden \u00e7ok e\u011filimleri g\u00f6stermekle ilgilidir. Eldeki stok verilerini kulland\u0131\u011f\u0131m\u0131z a\u015fa\u011f\u0131daki iki grafi\u011fe bak\u0131n. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/difference-entre-le-graphique-en-courbes-et-le-graphique-en-etapes-heure-exacte-du-changement-min-1.png\" sizes=\"\" srcset=\"\" alt=\"\u00c7izgi grafi\u011fi ile ad\u0131m grafi\u011fi aras\u0131ndaki fark tam de\u011fi\u015fim zaman\u0131\"><\/figure><\/div><p> Burada \u00e7izgi grafik \u015fubat ay\u0131ndan mart ay\u0131na kadar stoktaki d\u00fc\u015f\u00fc\u015f\u00fc g\u00f6steriyor. Ayn\u0131 d\u00f6nem i\u00e7in ad\u0131m grafi\u011finde art\u0131\u015f\u0131n yaln\u0131zca Nisan ay\u0131nda ger\u00e7ekle\u015fti\u011fini g\u00f6rebilirsiniz. K\u0131sacas\u0131 \u00e7izgi grafikte de\u011fi\u015fimin b\u00fcy\u00fckl\u00fc\u011f\u00fcn\u00fc g\u00f6remezsiniz ancak ad\u0131m grafi\u011finde de\u011fi\u015fimin b\u00fcy\u00fckl\u00fc\u011f\u00fcn\u00fc g\u00f6rebilirsiniz.<\/p><h3 class=\"wp-block-heading\"> 2. Ger\u00e7ek trend<\/h3><p> Ad\u0131m grafi\u011fi, bir trendle ilgili ger\u00e7ek i\u00e7g\u00f6r\u00fcy\u00fc g\u00f6stermenize yard\u0131mc\u0131 olabilir. \u00d6te yandan \u00e7izgi grafik bazen yan\u0131lt\u0131c\u0131 olabiliyor. Her iki grafi\u011fin alt\u0131nda da stokta may\u0131s ay\u0131nda bir d\u00fc\u015f\u00fc\u015f ve ard\u0131ndan haziran ay\u0131nda daha da bir art\u0131\u015f g\u00f6r\u00fcyorsunuz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/difference-entre-le-graphique-lineaire-et-le-graphique-en-escalier-tendance-reelle-min.png\" sizes=\"\" srcset=\"\" alt=\"\u00c7izgi grafi\u011fi ile ad\u0131m grafi\u011finin ger\u00e7ek e\u011filimi aras\u0131ndaki fark\"><\/figure><\/div><p> Ancak her iki grafi\u011fe de bakt\u0131\u011f\u0131n\u0131zda \u00f6nce d\u00fc\u015f\u00fc\u015f sonra art\u0131\u015f e\u011filiminin \u00e7izgi grafi\u011finde net bir \u015fekilde g\u00f6sterilmedi\u011fini g\u00f6receksiniz. \u00d6te yandan ad\u0131m grafi\u011finde art\u0131\u015ftan \u00f6nce sabit bir periyodun oldu\u011funu g\u00f6rebilirsiniz.<\/p><h3 class=\"wp-block-heading\"> 3. Sabit d\u00f6nemler<\/h3><p> \u00c7izgi grafik, de\u011ferlerin sabit oldu\u011fu d\u00f6nemleri g\u00f6steremez. Ancak ad\u0131m grafi\u011finde de\u011ferlerin sabit zaman dilimini kolayca g\u00f6sterebilirsiniz. Her iki grafi\u011fe de bak\u0131n. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/difference-entre-le-graphique-en-courbes-et-le-graphique-en-etapes-periodes-constantes-min-1.png\" sizes=\"\" srcset=\"\" alt=\"\u00e7izgi grafi\u011fin sabit periyotlar\u0131 ile ad\u0131m grafi\u011fi aras\u0131ndaki fark\"><\/figure><\/div><p> Ad\u0131m tablosunda, herhangi bir art\u0131\u015f ve azalmadan \u00f6nce her zaman sabit bir periyodun oldu\u011funu a\u00e7\u0131k\u00e7a g\u00f6rebilirsiniz. Ancak \u00e7izgi grafi\u011finde yaln\u0131zca azalma veya art\u0131\u015f\u0131n oldu\u011fu noktalar\u0131 g\u00f6rebilirsiniz.<\/p><h3 class=\"wp-block-heading\"> 4. Mevcut de\u011fi\u015fiklik say\u0131s\u0131<\/h3><p> A\u015fa\u011f\u0131daki iki grafikte temmuz-a\u011fustos aylar\u0131 aras\u0131nda ve ard\u0131ndan a\u011fustos-eyl\u00fcl aylar\u0131 aras\u0131nda bir art\u0131\u015f meydana geldi. Ancak \u00e7izgi grafi\u011fine bakt\u0131\u011f\u0131n\u0131zda iki de\u011fi\u015fimi net olarak g\u00f6remezsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/difference-entre-le-graphique-en-courbes-et-le-graphique-en-etapes-nombre-reel-de-changements-min-1.png\" sizes=\"\" srcset=\"\" alt=\"\u00c7izgi grafi\u011fi ile ad\u0131m grafi\u011findeki ger\u00e7ek de\u011fi\u015fiklik say\u0131s\u0131 aras\u0131ndaki fark\"><\/figure><\/div><p> <span style=\"font-size: 1em;\">\u015eimdi sahne grafi\u011fine gelirsek Temmuz ve Eyl\u00fcl aylar\u0131 aras\u0131nda iki de\u011fi\u015fikli\u011finiz oldu\u011fu a\u00e7\u0131k\u00e7a yaz\u0131yor. Eminim yukar\u0131daki t\u00fcm noktalar sizi \u00e7izgi grafi\u011fi yerine ad\u0131m grafi\u011fi kullanmaya ikna etmek i\u00e7in yeterlidir.<\/span><\/p><h2 class=\"wp-block-heading\"> Excel&#8217;de Ad\u0131m Grafi\u011fi Olu\u015fturman\u0131n Basit Ad\u0131mlar\u0131<\/h2><p> \u015eimdi ad\u0131m grafi\u011fi olu\u015fturman\u0131n zaman\u0131 geldi ve bunun i\u00e7in burada a\u015fa\u011f\u0131daki verileri kullanarak bu grafi\u011fi olu\u015fturmam\u0131z gerekiyor. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/donnees-boursieres-pour-creer-un-graphique-en-etapes-dans-Excel-min-1.png\" sizes=\"\" srcset=\"\" alt=\"Excel'de ad\u0131m grafi\u011fi olu\u015fturmak i\u00e7in borsa verileri\"><\/figure><\/div><p> Stokta meydana gelen art\u0131\u015f ve azal\u0131\u015flar\u0131n farkl\u0131 tarihlerdeki stok verileridir.<\/p><p> Devam etmek i\u00e7in <a href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/donnees-brutes-du-graphique-en-etapes-excel.xlsx\" rel=\"nofollow\">bu dosyay\u0131 buradan indirebilirsiniz<\/a> .<\/p><ol><li> \u00d6ncelikle a\u015fa\u011f\u0131daki y\u00f6ntemi kullanarak yeni bir tabloda veri olu\u015fturman\u0131z gerekir. Ba\u015fl\u0131klar\u0131 kopyalay\u0131p yeni h\u00fccrelere yap\u0131\u015ft\u0131r\u0131n. <br><img decoding=\"async\" title=\"Excel'de-dakikada-bir-ad\u0131m-grafi\u011fi-olu\u015fturmak i\u00e7in-ba\u015fl\u0131klar\u0131-kopyala-yap\u0131\u015ft\u0131r\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/copier-et-coller-des-en-tetes-pour-creer-un-tableau-des-etapes-dans-Excel-min-1.png\" sizes=\"\" srcset=\"\" alt=\"copy and paste headings to create a step chart in excel\"><\/li><li> \u015eimdi orijinal tablodan ikinci tarihten (A3&#8217;ten A12&#8217;ye) ba\u015flayan tarihleri se\u00e7in ve kopyalay\u0131n. <br><img decoding=\"async\" title=\"Excel'de-daki-ad\u0131m-grafik-olu\u015fturmak i\u00e7in orijinal-tablodan-tarihleri-kopyala\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/copier-les-dates-de-la-table-dorigine-pour-creer-un-graphique-en-etapes-dans-Excel-min-1.png\" sizes=\"\" srcset=\"\" alt=\"copy dates from original table to create a step chart in excel\"><\/li><li> Daha sonra yeni tablonuza giderek \u201cTarih\u201d ba\u015fl\u0131\u011f\u0131n\u0131n alt\u0131na (D2\u2019ye do\u011fru) tarihleri yap\u0131\u015ft\u0131r\u0131n. <br><img decoding=\"async\" title=\"Excel'de-daki-ad\u0131m-grafik-olu\u015fturmak i\u00e7in tarihleri-yeni-tabloya-yap\u0131\u015ft\u0131r\u0131n\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/coller-les-dates-dans-un-nouveau-tableau-pour-creer-un-tableau-des-etapes-dans-Excel-min-1.png\" sizes=\"\" srcset=\"\" alt=\"paste dates into new table to create a step chart in excel\"><\/li><li> Yine orijinal tablonuza gidin ve ilk de\u011ferden sondan bir \u00f6nceki de\u011fere kadar (B2&#8217;den B11&#8217;e kadar) hisse senedi de\u011ferlerini se\u00e7in ve kopyalay\u0131n. <br><img decoding=\"async\" title=\"Excel'de-dakika-ad\u0131m-grafik-olu\u015fturmak i\u00e7in stok de\u011ferlerini kopyala\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/copier-les-valeurs-de-stock-pour-creer-un-graphique-en-etapes-dans-Excel-min-1.png\" sizes=\"\" srcset=\"\" alt=\"copy stock values to create a step chart in excel\"><\/li><li> \u015eimdi bunu tarihlerin yan\u0131na &#8220;Eldeki Stok&#8221; ba\u015fl\u0131\u011f\u0131n\u0131n alt\u0131na yap\u0131\u015ft\u0131r\u0131n (E2&#8217;ye yap\u0131\u015ft\u0131r\u0131n). <br><img decoding=\"async\" title=\"Excel'de-dakikada-bir-ad\u0131m-grafi\u011fi-olu\u015fturmak i\u00e7in-yeni-tabloya-stok-de\u011ferlerini-yap\u0131\u015ft\u0131r\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/coller-les-valeurs-boursieres-dans-un-nouveau-tableau-pour-creer-un-graphique-en-etapes-dans-Excel-min-1.png\" sizes=\"\" srcset=\"\" alt=\"paste stock values in new table to create a step chart in excel\"><\/li><li> Bundan sonra orijinal veri tablonuza gidin ve kopyalay\u0131n. <br><img decoding=\"async\" title=\"-excel-dakikada-ad\u0131ml\u0131-grafik-olu\u015fturmak i\u00e7in\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/copier-le-tableau-dorigine-pour-creer-un-graphique-en-etapes-dans-Excel-min-1.png\" sizes=\"\" srcset=\"\" alt=\"copy original table to create a step chart in excel\"><\/li><li> \u015eimdi bunu az \u00f6nce olu\u015fturdu\u011funuz yeni tablonun alt\u0131na yap\u0131\u015ft\u0131r\u0131n. ve art\u0131k verileriniz buna benzer bir \u015feye benzeyecek. <br><img decoding=\"async\" title=\"e-yeni-tablonun alt\u0131nda-excel-dakikada-ad\u0131ml\u0131-grafik olu\u015fturmak i\u00e7in\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/coller-le-tableau-dorigine-sous-le-nouveau-tableau-pour-creer-un-graphique-en-etapes-dans-Excel-min-1.png\" sizes=\"\" srcset=\"\" alt=\"paste original table under new table to create a step chart in excel\"><\/li><li> Sonunda bu veri tablosunu se\u00e7in ve bir \u00e7izgi grafik olu\u015fturun. Veri sekmesine gidin -&gt; Ekle \u279c Grafikler \u279c \u00c7izgi Grafi\u011fi \u279c 2D \u00c7izgi Grafi\u011fi. <br><img decoding=\"async\" title=\"haz\u0131r\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/votre-tableau-des-etapes-est-pret-1.png\" sizes=\"\" srcset=\"\" alt=\"your step chart is ready\"><\/li><\/ol><p> <strong><span style=\"color: #ea493f;\">Tebrikler!<\/span><\/strong> ad\u0131m grafi\u011finiz sallanmaya haz\u0131r.<\/p><h3 class=\"wp-block-heading\"> Nas\u0131l \u00e7al\u0131\u015f\u0131r?<\/h3><p> \u0130lk ad\u0131m grafi\u011finizi olu\u015fturduktan sonra memnun kalaca\u011f\u0131n\u0131za eminim. Ancak burada kulland\u0131\u011f\u0131n\u0131z konseptin tamam\u0131n\u0131 anlaman\u0131n zaman\u0131 geldi. K\u00fc\u00e7\u00fck bir veri k\u00fcmesiyle bir \u00f6rnek alal\u0131m.<\/p><p> A\u015fa\u011f\u0131daki tabloda 01-Ocak-2016 ve 20-\u015eubat-2016 olmak \u00fczere iki tarihiniz var ve 20-\u015eubat-2016 tarihinde stok art\u0131\u015f\u0131n\u0131z var. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/un-petit-tableau-pour-creer-un-tableau-des-etapes-dans-excel-min-1.png\" sizes=\"\" srcset=\"\" alt=\"excel'de ad\u0131m grafi\u011fi olu\u015fturmak i\u00e7in k\u00fc\u00e7\u00fck bir tablo\"><\/figure><\/div><p> Bu verilerle basit bir \u00e7izgi grafi\u011fi olu\u015fturursan\u0131z a\u015fa\u011f\u0131daki gibi g\u00f6r\u00fcnecektir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/un-graphique-lineaire-par-defaut-avant-de-creer-un-graphique-en-etapes-dans-Excel-min-1.png\" sizes=\"\" srcset=\"\" alt=\"Excel'de ad\u0131ml\u0131 grafik olu\u015fturmadan \u00f6nce varsay\u0131lan olarak \u00e7izgi grafik\"><\/figure><\/div><p> \u015eimdi biraz geriye gidin ve bu makalenin ba\u015flar\u0131nda \u00f6\u011frendiklerinizi hat\u0131rlay\u0131n. Ad\u0131m grafi\u011finde bir art\u0131\u015f yaln\u0131zca ger\u00e7ekten meydana geldi\u011finde g\u00f6sterilecektir. Yani burada Ocak ay\u0131ndan \u015eubat ay\u0131na kadar olan bir trend \u00e7izgisi yerine \u015eubat ay\u0131ndaki de\u011fi\u015fimi g\u00f6stermeniz gerekiyor.<\/p><p> Bunun i\u00e7in 20 \u015eubat 2016 i\u00e7in ancak 01 Ocak 2016 hisse senedi de\u011feriyle yeni bir giri\u015f olu\u015fturman\u0131z gerekmektedir. Bu giri\u015f, art\u0131\u015f ger\u00e7ekle\u015fmedi\u011finde sat\u0131r\u0131 g\u00f6stermenize yard\u0131mc\u0131 olacakt\u0131r. Yani bu verilerle bir \u00e7izgi grafik olu\u015fturdu\u011funuzda, bu bir ad\u0131m grafi\u011fine d\u00f6n\u00fc\u015fecektir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/un-exemple-simple-de-diagramme-detape-min-1.png\" sizes=\"\" srcset=\"\" alt=\"basit bir ad\u0131m diyagram\u0131 \u00f6rne\u011fi\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Tarihler Olmadan Ad\u0131m Grafi\u011fi Nas\u0131l Olu\u015fturulur<\/h2><p> Bu makale i\u00e7in bir ad\u0131m grafi\u011fi olu\u015ftururken \u00e7izgi grafi\u011finin ad\u0131m grafi\u011fine g\u00f6re k\u00fc\u00e7\u00fck bir pozitif oldu\u011funu fark ettim.<\/p><p> Trendleri g\u00f6stermek i\u00e7in \u00e7o\u011fu zaman veya neredeyse her zaman \u00e7izgi grafi\u011fi kulland\u0131\u011f\u0131n\u0131zda b\u00f6yle d\u00fc\u015f\u00fcn\u00fcn. Ve trendler her zaman tarihlerle ve di\u011fer zaman \u00f6l\u00e7\u00fcmleriyle ba\u011flant\u0131l\u0131d\u0131r.<\/p><p> \u00c7izgi grafi\u011fi olu\u015fturdu\u011funuzda, ge\u00e7erli d\u00f6neme kadar olan aylar\u0131 veya y\u0131llar\u0131 (tarihler olmadan) kullanabilirsiniz. Ancak tarihler olmadan ad\u0131m grafi\u011fi olu\u015fturmaya \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131zda a\u015fa\u011f\u0131daki gibi g\u00f6r\u00fcnecektir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/probleme-un-graphique-en-etapes-sans-dates-min-1.png\" sizes=\"\" srcset=\"\" alt=\"tarihsiz ad\u0131m grafi\u011fi sorunu\"><\/figure><\/div><p> Burada tarihleri birle\u015ftirmek yerine Excel aylar\u0131 iki farkl\u0131 par\u00e7aya ay\u0131rd\u0131. Birincisi Ocak-Aral\u0131k, ard\u0131ndan ikinci Ocak-Aral\u0131k.<\/p><p> Art\u0131k tarih yerine metin kullan\u0131rsan\u0131z ad\u0131m grafi\u011fi olu\u015fturamayaca\u011f\u0131n\u0131z a\u00e7\u0131kt\u0131r. Bunu s\u00f6ylemek istemiyorum \u00e7\u00fcnk\u00fc bunun i\u00e7in bir \u00e7\u00f6z\u00fcm\u00fcm var. Aylar\u0131n\u0131z veya y\u0131llar\u0131n\u0131z oldu\u011funda, bunlar\u0131 bir tarihe d\u00f6n\u00fc\u015ft\u00fcrmeniz yeterlidir.<\/p><p> \u00d6rne\u011fin, Ocak, \u015eubat Mart vb. kullanmak yerine 01-Ocak-2016, 01-\u015eubat-2016, 01-Mart-2016 kullan\u0131n ve \u00f6zel bi\u00e7imlendirmeyi kullanarak <a href=\"https:\/\/exceladvisor.org\/tr\/ayin-adi\/\">tarihlerden bir ay al\u0131n<\/a> .<\/p><p> Bunun gibi. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/solution-un-graphique-en-etapes-sans-dates-min-1.png\" sizes=\"\" srcset=\"\" alt=\"tarihsiz ad\u0131m grafi\u011finin \u00e7\u00f6z\u00fcm\u00fc\"><\/figure><\/div><p> Ve bu sadece ad\u0131m tablonuzu yarat\u0131r.<\/p><p> <strong>SORUN \u00c7\u00d6Z\u00dcLD\u00dc.<\/strong><\/p><h2 class=\"wp-block-heading\"> Y\u00fckselticiler Olmadan S\u0131rt Tablosu Nas\u0131l Olu\u015fturulur<\/h2><p> Her \u015feyden \u00f6nce, y\u00fckselticiler olmadan bir s\u0131rt tablosu olu\u015fturma konusundaki <a href=\"http:\/\/peltiertech.com\/line-chart-without-risers\/\">bu harika fikir i\u00e7in Jon Peltier&#8217;e<\/a> te\u015fekk\u00fcr etmek istiyorum. Bu grafikte tam ad\u0131ml\u0131 bir grafik yerine yaln\u0131zca de\u011ferin sabit oldu\u011fu \u00e7izgilere sahip olacaks\u0131n\u0131z.<\/p><p> Bu grafi\u011fin en iyi kullan\u0131m\u0131, de\u011ferlerinizin sabit bir s\u00fcre sonra artmas\u0131 veya azalmas\u0131d\u0131r. \u00d6rne\u011fin konut kredisi oranlar\u0131, banka faiz oranlar\u0131 vb. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/tableau-steo-pret-a-lemploi-sans-contremarches-min-1.png\" sizes=\"\" srcset=\"\" alt=\"y\u00fckselticisiz kullan\u0131ma haz\u0131r steo board\"><\/figure><\/div><h3 class=\"wp-block-heading\"> Y\u00fckselticiler Olmadan Basamak Olu\u015fturma Ad\u0131mlar\u0131<\/h3><p> Bu grafi\u011fi olu\u015fturmak i\u00e7in verileri normal ad\u0131m grafi\u011finde yapt\u0131\u011f\u0131n\u0131z gibi yap\u0131land\u0131rmam\u0131z gerekir. Devam etmek i\u00e7in <a href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/tableau-des-etapes-excel.xlsx\">bu \u00f6rnek veri dosyas\u0131n\u0131 buradan indirin<\/a> .<\/p><p> <strong><span style=\"color: #ea493f;\">Ad\u0131m 1:<\/span><\/strong> \u00d6ncelikle bunun i\u00e7in bir tablo olu\u015fturmam\u0131z gerekiyor.<\/p><ol><li> Ba\u015fl\u0131klar\u0131 kopyalay\u0131p yeni h\u00fccrelere yap\u0131\u015ft\u0131r\u0131n.<\/li><li> \u015eimdi orijinal tablodan ikinci tarihten (A3&#8217;ten A12&#8217;ye) ba\u015flayan tarihleri se\u00e7in ve kopyalay\u0131n.<\/li><li> Daha sonra yeni tablonuza gidin ve tarihleri &#8220;Tarih&#8221; ba\u015fl\u0131\u011f\u0131n\u0131n alt\u0131na (D2&#8217;ye do\u011fru) yap\u0131\u015ft\u0131r\u0131n.<\/li><li> Yine orijinal tablonuza gidin ve ilk de\u011ferden sondan bir \u00f6nceki de\u011fere kadar (B2&#8217;den B11&#8217;e kadar) hisse senedi de\u011ferlerini se\u00e7in ve kopyalay\u0131n.<\/li><li> \u015eimdi bunu tarihlerin yan\u0131na \u201cFaiz Oran\u0131\u201d ba\u015fl\u0131\u011f\u0131 alt\u0131na yap\u0131\u015ft\u0131r\u0131n (E2&#8217;ye yap\u0131\u015ft\u0131r\u0131n).<\/li><\/ol><p> <strong><span style=\"color: #ea493f;\">Ad\u0131m 2:<\/span><\/strong> \u015eimdi tarihleri ilkinden sonuncuya kopyalay\u0131n ve yeni veri tablosunun alt\u0131na yap\u0131\u015ft\u0131r\u0131n. Oran i\u00e7in bo\u015f h\u00fccreler konusunda endi\u015felenmeyin.<\/p><p> <strong><span style=\"color: #ea493f;\">Ad\u0131m 3:<\/span><\/strong> Bundan sonra orijinal veri tablonuzu tekrar kopyalay\u0131n ve yeni veri tablosunun alt\u0131na yap\u0131\u015ft\u0131r\u0131n. Burada verileriniz bunun gibi \u00fc\u00e7 k\u00fcme halinde var. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/tableau-de-donnees-pour-creer-un-diagramme-en-gradins-sans-contremarches-min-1.png\" sizes=\"\" srcset=\"\" alt=\"y\u00fckselticiler olmadan ad\u0131m diyagram\u0131 olu\u015fturmak i\u00e7in veri tablosu\"><\/figure><\/div><p> <strong><span style=\"color: #ea493f;\">Ad\u0131m 4:<\/span><\/strong> Verileri se\u00e7in ve onunla bir \u00e7izgi grafi\u011fi olu\u015fturun.<\/p><p> <strong>Boom!<\/strong> y\u00fckselticiler olmadan ad\u0131m \u00e7izelgeniz haz\u0131r.<\/p><h2 class=\"wp-block-heading\"> \u00d6rnek dosya<\/h2><p> <span style=\"color: #0092df;\"><strong><a href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/tableau-des-etapes-excel.xlsx\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">T\u00fcm \u00f6rnek dosyalar\u0131 buradan indirin<\/a><\/strong><\/span><\/p><h2 class=\"wp-block-heading\"> \u00c7\u00f6z\u00fcm<\/h2><p> Yukar\u0131da \u00f6\u011frendi\u011finiz gibi ad\u0131m grafi\u011fi, \u00e7izgi grafi\u011fin geli\u015fmi\u015f versiyonudur. Size yaln\u0131zca trendleri g\u00f6stermekle kalmayacak, ayn\u0131 zamanda \u00e7izgi grafikle elde edilmesi zor olan \u00f6nemli bilgileri de g\u00f6sterecektir.<\/p><p> Belki ilk bak\u0131\u015fta biraz zor g\u00f6r\u00fcnebilir, ancak veri yap\u0131m\u0131nda ustala\u015ft\u0131ktan sonra onu saniyeler i\u00e7inde olu\u015fturabilirsiniz.<\/p><p> \u015eimdi bana bir \u015fey s\u00f6yle.<\/p><p> <strong>Hangi grafi\u011fin daha kullan\u0131\u015fl\u0131 oldu\u011funu d\u00fc\u015f\u00fcn\u00fcyorsunuz Ad\u0131m Grafi\u011fi mi yoksa \u00c7izgi Grafi\u011fi mi?<\/strong><\/p><p> D\u00fc\u015f\u00fcncelerinizi yorum b\u00f6l\u00fcm\u00fcnde payla\u015f\u0131n, sizden haber almay\u0131 \u00e7ok isterim. Ve bu ipucunu arkada\u015flar\u0131n\u0131zla payla\u015fmay\u0131 unutmay\u0131n.<\/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\/kursun-tahtasi\/\">Madde i\u015fareti grafi\u011fi<\/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-1719","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 ad\u0131m grafi\u011fi nas\u0131l olu\u015fturulur? (2023 K\u0131lavuzu)<\/title>\n<meta name=\"description\" content=\"Bu e\u011fitimde, Excel&#039;de bir ADIM GRAF\u0130\u011e\u0130 olu\u015fturmak i\u00e7in basit bir s\u00fcreci ve ihtiyac\u0131n\u0131z olan t\u00fcm \u00f6nemli bilgileri payla\u015ft\u0131m.\" \/>\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\/adim-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 ad\u0131m grafi\u011fi nas\u0131l olu\u015fturulur? (2023 K\u0131lavuzu)\" \/>\n<meta property=\"og:description\" content=\"Bu e\u011fitimde, Excel&#039;de bir ADIM GRAF\u0130\u011e\u0130 olu\u015fturmak i\u00e7in basit bir s\u00fcreci ve ihtiyac\u0131n\u0131z olan t\u00fcm \u00f6nemli bilgileri payla\u015ft\u0131m.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/adim-tablosu\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:00:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/votre-tableau-des-etapes-est-pret-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=\"8 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/adim-tablosu\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/adim-tablosu\/\",\"name\":\"Excel&#39;de ad\u0131m grafi\u011fi nas\u0131l olu\u015fturulur? (2023 K\u0131lavuzu)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/adim-tablosu\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/adim-tablosu\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/votre-tableau-des-etapes-est-pret-1.png\",\"datePublished\":\"2023-11-09T19:51:50+00:00\",\"dateModified\":\"2023-12-10T06:00:07+00:00\",\"description\":\"Bu e\u011fitimde, Excel&#39;de bir ADIM GRAF\u0130\u011e\u0130 olu\u015fturmak i\u00e7in basit bir s\u00fcreci ve ihtiyac\u0131n\u0131z olan t\u00fcm \u00f6nemli bilgileri payla\u015ft\u0131m.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/adim-tablosu\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/adim-tablosu\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/adim-tablosu\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/votre-tableau-des-etapes-est-pret-1.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/votre-tableau-des-etapes-est-pret-1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/adim-tablosu\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel&#39;de ad\u0131m 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 ad\u0131m grafi\u011fi nas\u0131l olu\u015fturulur? (2023 K\u0131lavuzu)","description":"Bu e\u011fitimde, Excel&#39;de bir ADIM GRAF\u0130\u011e\u0130 olu\u015fturmak i\u00e7in basit bir s\u00fcreci ve ihtiyac\u0131n\u0131z olan t\u00fcm \u00f6nemli bilgileri payla\u015ft\u0131m.","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\/adim-tablosu\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel&#39;de ad\u0131m grafi\u011fi nas\u0131l olu\u015fturulur? (2023 K\u0131lavuzu)","og_description":"Bu e\u011fitimde, Excel&#39;de bir ADIM GRAF\u0130\u011e\u0130 olu\u015fturmak i\u00e7in basit bir s\u00fcreci ve ihtiyac\u0131n\u0131z olan t\u00fcm \u00f6nemli bilgileri payla\u015ft\u0131m.","og_url":"https:\/\/exceladvisor.org\/tr\/adim-tablosu\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:00:07+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/votre-tableau-des-etapes-est-pret-1.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tahmini okuma s\u00fcresi":"8 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/adim-tablosu\/","url":"https:\/\/exceladvisor.org\/tr\/adim-tablosu\/","name":"Excel&#39;de ad\u0131m grafi\u011fi nas\u0131l olu\u015fturulur? (2023 K\u0131lavuzu)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/adim-tablosu\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/adim-tablosu\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/votre-tableau-des-etapes-est-pret-1.png","datePublished":"2023-11-09T19:51:50+00:00","dateModified":"2023-12-10T06:00:07+00:00","description":"Bu e\u011fitimde, Excel&#39;de bir ADIM GRAF\u0130\u011e\u0130 olu\u015fturmak i\u00e7in basit bir s\u00fcreci ve ihtiyac\u0131n\u0131z olan t\u00fcm \u00f6nemli bilgileri payla\u015ft\u0131m.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/adim-tablosu\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/adim-tablosu\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/adim-tablosu\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/votre-tableau-des-etapes-est-pret-1.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/votre-tableau-des-etapes-est-pret-1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/adim-tablosu\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel&#39;de ad\u0131m 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\/1719","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=1719"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1719\/revisions"}],"predecessor-version":[{"id":2380,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1719\/revisions\/2380"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=1719"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}