{"id":1718,"date":"2023-11-09T20:07:58","date_gmt":"2023-11-09T20:07:58","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/pivot-tablo-2\/"},"modified":"2023-12-10T06:02:02","modified_gmt":"2023-12-10T06:02:02","slug":"pivot-tablo-2","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/pivot-tablo-2\/","title":{"rendered":"Excel&#39;de pivot tablo nas\u0131l olu\u015fturulur?"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-1614771477\"><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>P\u0130VOT TABLO, verilerinizi Excel&#8217;de sunman\u0131n en iyi yollar\u0131ndan biridir.<\/p><p> Bunu neden s\u00f6yl\u00fcyorum? G\u00f6rsel olarak veriler yaln\u0131zca kullan\u0131c\u0131n\u0131n onu anlamas\u0131na yard\u0131mc\u0131 olmakla kalmaz, ayn\u0131 zamanda onun daha net bir resmini sunman\u0131za ve y\u00f6nlendirilmi\u015f \u00e7abalarla amac\u0131n\u0131z\u0131 netle\u015ftirmenize de yard\u0131mc\u0131 olur.<\/p><p> Ve Excel hakk\u0131nda konu\u015ftu\u011fumuzda, kulland\u0131\u011f\u0131n\u0131z \u00e7ok say\u0131da grafik vard\u0131r, ancak bunlar\u0131n aras\u0131nda \u00f6ne \u00e7\u0131kan bir tanesi vard\u0131r ve o da P\u0130VOT GRAF\u0130KT\u0130R.<\/p><p> Veri g\u00f6rselle\u015ftirme becerilerinizi ger\u00e7ekten bir sonraki seviyeye ta\u015f\u0131mak istiyorsan\u0131z pivot tablonun nas\u0131l olu\u015fturulaca\u011f\u0131n\u0131 \u00f6\u011frenmeniz gerekir.<\/p><p> Rehberde ise pivot tablonun nas\u0131l \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131 anlamak i\u00e7in bilmeniz gereken t\u00fcm detaylar\u0131 anlataca\u011f\u0131m. Ama ondan \u00f6nce Wikipedia&#8217;dan birka\u00e7 kelime vereyim.<\/p><p> <em>PivotChart, veri analizi i\u00e7in en iyi grafik t\u00fcr\u00fcd\u00fcr. En kullan\u0131\u015fl\u0131 \u00f6zellik, pivot tablo raporu gibi verilerin hangi b\u00f6l\u00fcm\u00fcn\u00fcn g\u00f6r\u00fcnt\u00fclenece\u011fini h\u0131zl\u0131 bir \u015fekilde de\u011fi\u015ftirebilme yetene\u011fidir. Bu, pivot tabloyu sat\u0131\u015f raporlar\u0131ndaki verileri sunmak i\u00e7in ideal hale getirir.<\/em> <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-8198\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/difference-tableau-croise-dynamique-excel-et-tableau-excel-normal-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"Excel Pivot Tablosu ile Normal Excel Tablosu aras\u0131ndaki fark\" width=\"848\" height=\"196\"><\/figure><\/div><h2 id=\"tab-con-1\" class=\"wp-block-heading\"> PivotChart ile Normal Grafik aras\u0131ndaki fark<\/h2><ul><li> Standart bir grafik bir dizi h\u00fccreyi kullan\u0131rken, pivot grafik bir pivot tabloda \u00f6zetlenen verilere dayan\u0131r.<\/li><li> PivotChart zaten bir PivotChart&#8217;t\u0131r ancak <a href=\"https:\/\/exceladvisor.org\/tr\/etkilesimli-grafikler\/\">standart bir grafi\u011fi PivotChart&#8217;a<\/a> d\u00f6n\u00fc\u015ft\u00fcrmek i\u00e7in verileri de\u011fi\u015ftirmeniz gerekir.<\/li><\/ul><h2 id=\"tab-con-2\" class=\"wp-block-heading\"> Excel&#8217;de Pivot Tablo Olu\u015fturma Ad\u0131mlar\u0131<\/h2><p> Pivot tabloyu iki \u015fekilde olu\u015fturabilirsiniz. Biri mevcut pivot tablonuza pivot tablo eklemek, di\u011feri ise s\u0131f\u0131rdan pivot tablo olu\u015fturmak.<\/p><h3 id=\"tab-con-3\" class=\"wp-block-heading\"> 1. S\u0131f\u0131rdan PivotTable Olu\u015fturun<\/h3><p> S\u0131f\u0131rdan bir pivot tablo olu\u015fturmak <a href=\"https:\/\/exceladvisor.org\/tr\/pivot-tablo-1\/\" data-wpil=\"url\">, bir pivot tablo olu\u015fturmak kadar kolayd\u0131r<\/a> . Tek ihtiyac\u0131n\u0131z olan bir veri sayfas\u0131. Burada Excel 2013 kullan\u0131yorum, ancak siz 2007&#8217;den 2016&#8217;ya kadar t\u00fcm s\u00fcr\u00fcmlerdeki ad\u0131mlar\u0131 kullan\u0131yorsunuz.<\/p><ol><li> Veri sayfan\u0131zdaki h\u00fccrelerden birini se\u00e7in ve Ekle sekmesi \u2192 Grafikler \u2192 PivotChart&#8217;a gidin. <br><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/inserer-un-tableau-croise-dynamique-Excel-a-partir-de-longlet-Insertion-1.png\" sizes=\"\" srcset=\"\" alt=\"&quot;vba-\u00f6zel-i\u015flev-tan\u0131m sonras\u0131-ad-arg\u00fcmanlar\u0131\"><\/li><li> A\u00e7\u0131l\u0131r pencere otomatik olarak t\u00fcm veri aral\u0131\u011f\u0131n\u0131 se\u00e7ecektir ve pivot tablonuzu nereye eklemek istedi\u011finizi se\u00e7me se\u00e7ene\u011fine sahip olacaks\u0131n\u0131z. <br><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/selectionner-un-lieu-inserer-un-tableau-croise-dynamique-Excel-1.png\" sizes=\"\" srcset=\"\" alt=\"&quot;vba-\u00f6zel-i\u015flev-tan\u0131m sonras\u0131-ad-arg\u00fcmanlar\u0131\"><\/li><li> Tamam&#8217;\u0131 t\u0131klay\u0131n.<\/li><li> Art\u0131k yeni bir \u00e7al\u0131\u015fma sayfas\u0131nda bo\u015f bir PivotTable ve PivotTable&#8217;\u0131n\u0131z var. <br><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/tableau-croise-dynamique-vierge-et-tableau-croise-dynamique-excel-1.png\" sizes=\"\" srcset=\"\" alt=\"&quot;vba-\u00f6zel-i\u015flev-tan\u0131m sonras\u0131-ad-arg\u00fcmanlar\u0131\"><\/li><\/ol><p class=\"qt-tip\"> <strong>Not:<\/strong> Bir pivot tablo ekledi\u011finizde, otomatik olarak onunla birlikte bir pivot tablo da eklenir. Ayr\u0131ca yaln\u0131zca bir pivot tablo eklemek istiyorsan\u0131z verilerinizi Power Pivot veri modeline ekleyebilirsiniz.<\/p><ol><li> Pivot tablo alanlar\u0131nda, pivot tabloda oldu\u011fu gibi d\u00f6rt bile\u015fenimiz var.<ol><li> <strong>Eksen<\/strong> : Pivot tablodaki eksen, pivot tablomuzdaki sat\u0131rlarla ayn\u0131d\u0131r.<\/li><li> <strong>A\u00e7\u0131klama<\/strong> : Pivot tablodaki efsane, pivot tablomuzun s\u00fctunlar\u0131ndaki efsaneyle ayn\u0131d\u0131r.<\/li><li> <strong>De\u011ferler<\/strong> : De\u011fer olarak miktar\u0131 kullan\u0131r\u0131z.<\/li><li> <strong>Rapor Filtresi<\/strong> : Pivot tablonuzu filtrelemek i\u00e7in rapor filtresini kullanabilirsiniz. <\/li><\/ol><br><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/utiliser-les-champs-du-graphique-pour-definir-la-valeur-du-tableau-croise-dynamique-Excel-1.png\" sizes=\"\" srcset=\"\" alt=\"&quot;vba-\u00f6zel-i\u015flev-tan\u0131m sonras\u0131-ad-arg\u00fcmanlar\u0131\"><\/li><li> \u0130\u015fte tamamen dinamik pivot tablonuz. <br><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/creer-un-tableau-croise-dynamique-excel-a-partir-de-zero-1.gif\" sizes=\"\" srcset=\"\" alt=\"&quot;vba-\u00f6zel-i\u015flev-tan\u0131m sonras\u0131-ad-arg\u00fcmanlar\u0131\"><\/li><\/ol><h3 id=\"tab-con-4\" class=\"wp-block-heading\"> 2. Mevcut PivotTable&#8217;dan PivotChart Olu\u015fturun<\/h3><p> \u00c7al\u0131\u015fma sayfan\u0131zda zaten bir pivot tablonuz varsa, a\u015fa\u011f\u0131daki basit ad\u0131mlar\u0131 izleyerek bir pivot tablo ekleyebilirsiniz.<\/p><ol><li> Pivot tablonuzdaki h\u00fccrelerden birini se\u00e7in. <br><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/selectionnez-nimporte-quelle-cellule-pour-inserer-un-tableau-croise-dynamique-Excel-1.png\" sizes=\"\" srcset=\"\" alt=\"&quot;vba-\u00f6zel-i\u015flev-tan\u0131m sonras\u0131-ad-arg\u00fcmanlar\u0131\"><\/li><li> Ekle sekmesi \u2192 Grafikler \u2192 \u00d6zet Grafik&#8217;e gidin ve kullanmak istedi\u011finiz grafi\u011fi se\u00e7in. <br><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/inserez-un-tableau-croise-dynamique-Excel-si-vous-avez-deja-un-tableau-croise-dynamique-1.png\" sizes=\"\" srcset=\"\" alt=\"&quot;vba-\u00f6zel-i\u015flev-tan\u0131m sonras\u0131-ad-arg\u00fcmanlar\u0131\"><\/li><li> Tamam&#8217;\u0131 t\u0131klay\u0131n.<\/li><\/ol><p> Pivot tablonuzun bulundu\u011fu ayn\u0131 \u00e7al\u0131\u015fma sayfas\u0131na yeni bir pivot tablo ekleyecektir. Ayr\u0131ca, pivot tablo sat\u0131rlar\u0131n\u0131 eksen olarak, s\u00fctunlar\u0131 ise pivot tablodaki g\u00f6sterge olarak kullanacakt\u0131r.<\/p><p class=\"qt-tip\"> <strong>\u00d6nemli<\/strong> : Bir ba\u015fka ak\u0131ll\u0131 ve h\u0131zl\u0131 yol da <a href=\"https:\/\/exceladvisor.org\/tr\/klavye-kisayollari\/\">k\u0131sayol tu\u015funu<\/a> kullanmakt\u0131r. Pivot tablonuzdaki h\u00fccrelerden birini se\u00e7in ve pivot tablo eklemek i\u00e7in F11 tu\u015funa bas\u0131n.<\/p><h2 class=\"wp-block-heading\"> PivotChart&#8217;lar hakk\u0131nda daha fazla bilgi<\/h2><p> Bir pivot tabloyu y\u00f6netmek basittir ve burada bunu sorunsuz bir \u015fekilde yapman\u0131za yard\u0131mc\u0131 olacak baz\u0131 bilgiler bulunmaktad\u0131r.<\/p><h3 class=\"wp-block-heading\"> 1. Grafik t\u00fcr\u00fcn\u00fc de\u011fi\u015ftirin<\/h3><p> Yeni bir pivot tablo girdi\u011finizde kullanmak istedi\u011finiz grafik t\u00fcr\u00fcn\u00fc se\u00e7melisiniz. Grafik t\u00fcr\u00fcn\u00fc de\u011fi\u015ftirmek isterseniz bunun i\u00e7in a\u015fa\u011f\u0131daki ad\u0131mlar\u0131 kullanabilirsiniz.<\/p><ol><li> Pivot tablonuzu se\u00e7in ve Tasar\u0131m sekmesi \u2192 T\u00fcr \u2192 Grafik T\u00fcr\u00fcn\u00fc De\u011fi\u015ftir se\u00e7ene\u011fine gidin. <br><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exce-tableau-croise-dynamique-changer-le-type-de-graphique-1.png\" sizes=\"\" srcset=\"\" alt=\"&quot;vba-\u00f6zel-i\u015flev-tan\u0131m sonras\u0131-ad-arg\u00fcmanlar\u0131\"><\/li><li> Tercih etti\u011finiz grafik t\u00fcr\u00fcn\u00fc se\u00e7in. <br><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/selectionner-un-nouveau-type-de-graphique-pour-le-tableau-croise-dynamique-Excel-1.png\" sizes=\"\" srcset=\"\" alt=\"&quot;vba-\u00f6zel-i\u015flev-tan\u0131m sonras\u0131-ad-arg\u00fcmanlar\u0131\"><\/li><li> Tamam&#8217;\u0131 t\u0131klay\u0131n.<\/li><\/ol><h3 id=\"tab-con-7\" class=\"wp-block-heading\"> 2. Pivot tabloyu yenileyin<\/h3><p> PivotTable&#8217;\u0131 yenilemek <a href=\"https:\/\/exceladvisor.org\/tr\/her-seyi-yenile\/\">PivotTable&#8217;\u0131 yenilemekle<\/a> ayn\u0131d\u0131r. Pivot tablonuz otomatik olarak yenilenirse pivot tablonuz da bununla g\u00fcncellenecektir.<\/p><h4 id=\"tab-con-9\" class=\"wp-block-heading\"> Y\u00f6ntem 1<\/h4><ul><li> Grafi\u011finize sa\u011f t\u0131klay\u0131n, ard\u0131ndan PivotChart Se\u00e7enekleri&#8217;ne t\u0131klay\u0131n. <br><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/clic-droit-sur-le-tableau-croise-dynamique-excel-pour-activer-loption-dactualisation-1.png\" sizes=\"\" srcset=\"\" alt=\"&quot;vba-\u00f6zel-i\u015flev-tan\u0131m sonras\u0131-ad-arg\u00fcmanlar\u0131\"><\/li><li> Veri sekmesine gidin ve \u201cDosyay\u0131 a\u00e7arken verileri yenile\u201d se\u00e7ene\u011fini i\u015faretleyin. Ve ard\u0131ndan Tamam&#8217;\u0131 t\u0131klay\u0131n. <br><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/mettre-a-jour-automatiquement-le-tableau-croise-dynamique-excel-a-louverture-dun-fichier-1.png\" sizes=\"\" srcset=\"\" alt=\"&quot;vba-\u00f6zel-i\u015flev-tan\u0131m sonras\u0131-ad-arg\u00fcmanlar\u0131\"><\/li><\/ul><h4 id=\"tab-con-10\" class=\"wp-block-heading\"> Y\u00f6ntem-2<\/h4><p> \u00c7al\u0131\u015fma kitab\u0131n\u0131zdaki <a href=\"https:\/\/exceladvisor.org\/tr\/her-seyi-yenile\/\">her t\u00fcrl\u00fc pivot tabloyu ve pivot grafi\u011fini yenilemek<\/a> i\u00e7in a\u015fa\u011f\u0131daki VBA kodunu kullan\u0131n.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub auto_open() Dim PC As PivotCache For Each PC In ActiveWorkbook.PivotCaches PC.Refresh Next PC End Sub<\/code><\/pre><p> Belirli bir pivot tabloyu yenilemek istiyorsan\u0131z yukar\u0131daki kodun yan\u0131 s\u0131ra a\u015fa\u011f\u0131daki VBA kodunu da kullanabilirsiniz.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub auto_open() ActiveSheet.ChartObjects(\"Chart 5\").Activate ActiveChart.PivotLayout.PivotTable.PivotCache.Refresh End Sub<\/code><\/pre><h3 id=\"tab-con-8\" class=\"wp-block-heading\"> <span style=\"font-size: 22px;\">3. Filtrenin pivot tablosu vard\u0131r<\/span><\/h3><p> T\u0131pk\u0131 bir pivot tablo gibi, pivot tablonuzu da belirli belirli de\u011ferleri g\u00f6sterecek \u015fekilde filtreleyebilirsiniz. A\u00e7\u0131k olan bir \u015fey var ki, bir pivot tablo ve bir pivot tablo birbirine ba\u011fl\u0131d\u0131r.<\/p><p> Yani bir pivot tabloyu filtreledi\u011finizde grafi\u011finiz de otomatik olarak filtrelenir. Ayr\u0131ca, pivot tablonuza bir filtre ekledi\u011finizde, bu filtre otomatik olarak pivot tablonuza eklenecektir veya bunun tersi de ge\u00e7erlidir. Bunun i\u00e7in l\u00fctfen \u015fu ad\u0131mlar\u0131 izleyin.<\/p><ol><li> Pivot tablonuza sa\u011f t\u0131klay\u0131n ve \u201cAlan Listesini G\u00f6ster\u201d se\u00e7ene\u011fine t\u0131klay\u0131n. <br><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/afficher-la-liste-des-champs-pour-ajouter-un-filtre-dans-le-tableau-croise-dynamique-Excel-1.png\" sizes=\"\" srcset=\"\" alt=\"&quot;vba-\u00f6zel-i\u015flev-tan\u0131m sonras\u0131-ad-arg\u00fcmanlar\u0131\"><\/li><li> Pivot tablonuzun alan listesindeki alanlar\u0131 filtre kutusuna s\u00fcr\u00fckleyin. <br><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/ajouter-des-champs-a-la-zone-de-filtrage-dans-le-tableau-croise-dynamique-Excel-1.png\" sizes=\"\" srcset=\"\" alt=\"&quot;vba-\u00f6zel-i\u015flev-tan\u0131m sonras\u0131-ad-arg\u00fcmanlar\u0131\"><\/li><\/ol><p class=\"qt-tip\"> <strong>Not<\/strong> : Varsay\u0131lan olarak, eksen kategorilerini filtrelemek i\u00e7in pivot tablonuzun alt k\u0131sm\u0131nda bir filtre se\u00e7ene\u011finiz vard\u0131r.<\/p><h3 id=\"tab-con-11\" class=\"wp-block-heading\"> 4. De\u011fi\u015fen toplam\u0131 bir pivot tabloda g\u00f6sterin<\/h3><p> A\u015fa\u011f\u0131daki pivot tabloda d\u00f6nem boyunca b\u00fcy\u00fcmeyi g\u00f6stermek i\u00e7in s\u00fcrekli bir toplam kulland\u0131m. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/ajouter-le-total-cumule-dans-le-tableau-croise-dynamique-Excel-a-partir-des-parametres-de-valeur-1.png\" sizes=\"\" srcset=\"\" alt=\"de\u011fer ayarlar\u0131ndan excel pivot tablosuna toplam toplam\u0131 ekleme\"><\/figure><\/div><p> PivotTable&#8217;a de\u011fi\u015fen toplam girmek, <a href=\"https:\/\/exceladvisor.org\/tr\/birikimli-toplam\/\">PivotTable&#8217;a de\u011fi\u015fen toplam<\/a> girmekle ayn\u0131d\u0131r. Ancak grafik format\u0131nda baz\u0131 basit de\u011fi\u015fiklikler yapmam\u0131z gerekiyor.<\/p><ol><li> Pivot tablonuzun alan listesinde de\u011fer alan\u0131n\u0131z\u0131 iki kez de\u011fer kutusuna s\u00fcr\u00fckleyin. <br><img decoding=\"async\" title=\"exce-pivot-grafik-de\u011fi\u015fim-grafik-t\u00fcr\u00fc-1\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exce-tableau-croise-dynamique-changer-le-type-de-graphique-1.png\" sizes=\"\" srcset=\"\" alt=\"exce-pivot-chart-change-chart-type-1\"><\/li><li> \u015eimdi ikinci de\u011fer alan\u0131nda \u201cDe\u011fer Alan\u0131 Ayarlar\u0131\u201dn\u0131 a\u00e7\u0131n.<\/li><li> &#8220;De\u011feri farkl\u0131 g\u00f6ster&#8221; sekmesine gidin ve a\u00e7\u0131l\u0131r listeden cari toplam\u0131 se\u00e7in. <br><img loading=\"lazy\" decoding=\"async\" title=\"de\u011fi\u015fen toplam\u0131 bir Excel pivot grafi\u011fine eklemek i\u00e7in ikincil bir eksen ekleyin\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/ajouter-un-axe-secondaire-pour-ajouter-le-total-cumule-dans-le-tableau-croise-dynamique-Excel-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"add-secondary-axis-to-add-running-total-in-excel-pivot-chart\" width=\"456\" height=\"136\"><\/li><li> Tamam&#8217;a t\u0131klay\u0131n (\u0130\u015fte toplam\u0131n yer ald\u0131\u011f\u0131 pivot tablonuz, ancak onu m\u00fckemmel hale getirmek i\u00e7in yapmam\u0131z gereken bir \u015fey daha var).<\/li><li> Birincil ekseninizi se\u00e7in ve de\u011ferleri <a href=\"https:\/\/exceladvisor.org\/tr\/ikincil-eksen\/\" target=\"_blank\" rel=\"noopener noreferrer\" data-wpil=\"url\">ikincil ekseninize<\/a> g\u00f6re de\u011fi\u015ftirin. <br><img loading=\"lazy\" decoding=\"async\" title=\"eksen-de\u011ferini-ekmek-ak\u0131m-toplam-pivot-grafik-excel-e1470287104819 i\u00e7in ayarlay\u0131n\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/ajuster-la-valeur-de-laxe-pour-ajouter-le-total-cumule-dans-le-tableau-croise-dynamique-Excel-e1470287104819.png\" sizes=\"auto, \" srcset=\"\" alt=\"adjust-axis-value-to-add-running-total-in-excel-pivot-chart-e1470287104819\" width=\"474\" height=\"191\"><\/li><\/ol><h3 id=\"tab-con-12\" class=\"wp-block-heading\"> 5. PivotTable&#8217;\u0131 Yeni Bir Sayfaya Ta\u015f\u0131y\u0131n<\/h3><p> Standart bir grafik gibi, Excel pivot tablonuzu da bir grafik sayfas\u0131na veya ba\u015fka bir \u00e7al\u0131\u015fma sayfas\u0131na ta\u015f\u0131yabilirsiniz. Pivot tablonuzu ta\u015f\u0131mak i\u00e7in.<\/p><ol><li> Grafi\u011finizi se\u00e7in ve sa\u011f t\u0131klay\u0131n.<\/li><li> Hareket grafi\u011fine t\u0131klay\u0131n ve bir a\u00e7\u0131l\u0131r pencere g\u00f6receksiniz. <br><img loading=\"lazy\" decoding=\"async\" title=\"hareket-pivot-grafik-excel\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/deplacer-un-tableau-croise-dynamique-excel-1.png\" sizes=\"auto, \" srcset=\"\" alt=\"move-excel-pivot-chart\" width=\"445\" height=\"191\"><ul><li> Yeni grafik sayfas\u0131.<\/li><li> Ba\u015fka bir \u00e7al\u0131\u015fma sayfas\u0131.<\/li><\/ul><\/li><li> \u0130stedi\u011finiz se\u00e7ene\u011fi se\u00e7in ve Tamam&#8217;a t\u0131klay\u0131n.<\/li><\/ol><p> Ayn\u0131 ad\u0131mlar\u0131 kullanarak grafi\u011finizi orijinal sayfaya da ta\u015f\u0131yabilirsiniz.<\/p><h2 id=\"tab-con-13\" class=\"wp-block-heading\"> Ek \u00d6zet Grafik \u0130pu\u00e7lar\u0131<\/h2><p> Daha iyi kontrol etmek i\u00e7in baz\u0131 ek ipu\u00e7lar\u0131.<\/p><h3 id=\"tab-con-14\" class=\"wp-block-heading\"> 1. Filtrelemek i\u00e7in pivot tablolu bir dilimleyici kullanma<\/h3><p> Daha \u00f6nce de belirtti\u011fim gibi pivot tablonuzla birlikte dilimleyici kullanabilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-8240\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/ajouter-un-segment-dans-le-tableau-croise-dynamique-Excel-1.gif\" sizes=\"auto, \" srcset=\"\" alt=\"excel pivot tablosuna dilimleyici ekleme\" width=\"532\" height=\"364\"><\/figure><\/div><p> Ve en iyi yan\u0131, tek bir dilimleyiciyle <a href=\"https:\/\/exceladvisor.org\/tr\/dilimleyiciyi-birkac-pivot-tabloya-baglama\/\" target=\"\" rel=\"noopener noreferrer\" data-tcb-events=\"\">birden fazla pivot tabloyu ve pivot grafi\u011fini filtreleyebilmenizdir<\/a> . Bu ad\u0131mlar\u0131 takip et.<\/p><ol><li> Pivot tablonuzu se\u00e7in ve Analiz sekmesi \u2192 Filtre \u2192 Dilimleyici Ekle&#8217;ye gidin. <br><img decoding=\"async\" title=\"excel-pivot-tabloda-dilimleyici ekle\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/inserer-un-slicer-dans-un-tableau-croise-dynamique-excel-1.png\" sizes=\"\" srcset=\"\" alt=\"insert-slicer-in-excel-pivot-table\"><\/li><li> Filtre olarak kullanmak istedi\u011finiz alan\u0131 se\u00e7in. <br><img decoding=\"async\" title=\"excel-pivot-tabloya-dilimleyiciyi-uygulayacak-alan\u0131 se\u00e7in\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/selectionnez-le-champ-pour-appliquer-le-segment-au-tableau-croise-dynamique-Excel-1.png\" sizes=\"\" srcset=\"\" alt=\"select-field-to-apply-slicer-to-excel-pivot-table\"><\/li><li> Tamam&#8217;\u0131 t\u0131klay\u0131n.<\/li><\/ol><p> Dilimleyici kullanmak her zaman standart filtreden daha iyi bir se\u00e7enektir.<\/p><h3 id=\"tab-con-15\" class=\"wp-block-heading\"> 2. Pivot tablodaki tarihleri filtrelemek i\u00e7in bir zaman \u00e7izelgesi ekleyin<\/h3><p> Pivot tablonuzu tarih alan\u0131 kullanarak filtrelemek istiyorsan\u0131z dilimleyici yerine zaman \u00e7izelgesi kullanabilirsiniz. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-8244\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/ajouter-une-chronologie-dans-un-tableau-croise-dynamique-Excel-1.gif\" sizes=\"auto, \" srcset=\"\" alt=\"Excel pivot tablosuna zaman \u00e7izelgesi ekleme\" width=\"532\" height=\"432\"><\/figure><\/div><p> <a href=\"https:\/\/exceladvisor.org\/tr\/zaman-cizelgesi-filtresi\/\">Tarihleri zaman \u00e7izelgesiyle filtrelemek<\/a> son derece kolayd\u0131r. Tarihleri g\u00fcn, ay, \u00e7eyrek ve y\u0131l baz\u0131nda filtrelemek i\u00e7in kullanabilece\u011finiz geli\u015fmi\u015f bir filtre gibidir.<\/p><ul><li> Pivot tablonuzu se\u00e7in ve Analiz sekmesi \u2192 Filtre \u2192 Zaman \u00c7izelgesi Ekle&#8217;ye gidin. <br><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/cliquez-sur-inserer-la-chronologie-pour-inserer-dans-le-tableau-croise-dynamique-Excel-1.png\" sizes=\"\" srcset=\"\" alt=\"&quot;vba-\u00f6zel-i\u015flev-tan\u0131m sonras\u0131-ad-arg\u00fcmanlar\u0131\"><\/li><li> A\u00e7\u0131l\u0131r pencerede tarih alan\u0131n\u0131z\u0131 se\u00e7in; size tarihlerin bulundu\u011fu alanlar\u0131 g\u00f6sterecektir, ard\u0131ndan Tamam&#8217;\u0131 t\u0131klay\u0131n.<\/li><\/ul><h3 id=\"tab-con-16\" class=\"wp-block-heading\"> 3. Tarihleri grupland\u0131rarak aylar\u0131 bir pivot tabloda sunun<\/h3><p> \u015eimdi diyelim ki verilerinizde tarihler var ve ayl\u0131k olarak pivot tablo olu\u015fturmak istiyorsunuz. Kolay bir yol, verilerinize bir ay s\u00fctunu eklemek ve bunu pivot tablonuzda kullanmakt\u0131r.<\/p><p> Ama i\u015fte burada bir de\u011fi\u015fiklik var. <a href=\"https:\/\/exceladvisor.org\/tr\/grup-tarihleri\/\">Pivot tablonuzda tarihleri grupland\u0131rabilirsiniz;<\/a> bu, kaynak verilerde aylar olmasa bile aylar\u0131 i\u00e7eren bir pivot tablo olu\u015fturman\u0131za daha fazla yard\u0131mc\u0131 olacakt\u0131r.<\/p><ol><li> Pivot tablonuza gidin ve tarih alan\u0131 s\u00fctununuzdaki h\u00fccrelerden birini se\u00e7in.<\/li><li> \u00dczerine sa\u011f t\u0131klay\u0131n ve grubu se\u00e7in. <br><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/regrouper-les-dates-dans-un-tableau-croise-dynamique-dans-un-tableau-croise-dynamique-Excel-1.png\" sizes=\"\" srcset=\"\" alt=\"&quot;vba-\u00f6zel-i\u015flev-tan\u0131m sonras\u0131-ad-arg\u00fcmanlar\u0131\"><\/li><li> A\u00e7\u0131lan pencerede ay\u0131 se\u00e7in ve Tamam&#8217;a t\u0131klay\u0131n. <\/li><\/ol><div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\"><h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Excel dosyas\u0131n\u0131 al\u0131n<\/h2> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/tableau-croise-dynamique-excel.xlsx\" rel=\"nofollow\">\u0130ndirmek<\/a><\/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-1718","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>\u25b7 Excel&#039;de pivot tablo nas\u0131l olu\u015fturulur?<\/title>\n<meta name=\"description\" content=\"Bu, sahip oldu\u011funuz t\u00fcm bilgileri i\u00e7eren, Excel&#039;de bir pivot tablo olu\u015fturmaya y\u00f6nelik ad\u0131m ad\u0131m bir k\u0131lavuzdur.\" \/>\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\/pivot-tablo-2\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Excel&#039;de pivot tablo nas\u0131l olu\u015fturulur?\" \/>\n<meta property=\"og:description\" content=\"Bu, sahip oldu\u011funuz t\u00fcm bilgileri i\u00e7eren, Excel&#039;de bir pivot tablo olu\u015fturmaya y\u00f6nelik ad\u0131m ad\u0131m bir k\u0131lavuzdur.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/pivot-tablo-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:02:02+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/difference-tableau-croise-dynamique-excel-et-tableau-excel-normal-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=\"7 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/pivot-tablo-2\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/pivot-tablo-2\/\",\"name\":\"\u25b7 Excel&#39;de pivot tablo nas\u0131l olu\u015fturulur?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/pivot-tablo-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/pivot-tablo-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/difference-tableau-croise-dynamique-excel-et-tableau-excel-normal-1.png\",\"datePublished\":\"2023-11-09T20:07:58+00:00\",\"dateModified\":\"2023-12-10T06:02:02+00:00\",\"description\":\"Bu, sahip oldu\u011funuz t\u00fcm bilgileri i\u00e7eren, Excel&#39;de bir pivot tablo olu\u015fturmaya y\u00f6nelik ad\u0131m ad\u0131m bir k\u0131lavuzdur.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/pivot-tablo-2\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/pivot-tablo-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/pivot-tablo-2\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/difference-tableau-croise-dynamique-excel-et-tableau-excel-normal-1.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/difference-tableau-croise-dynamique-excel-et-tableau-excel-normal-1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/pivot-tablo-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel&#39;de pivot tablo 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":"\u25b7 Excel&#39;de pivot tablo nas\u0131l olu\u015fturulur?","description":"Bu, sahip oldu\u011funuz t\u00fcm bilgileri i\u00e7eren, Excel&#39;de bir pivot tablo olu\u015fturmaya y\u00f6nelik ad\u0131m ad\u0131m bir k\u0131lavuzdur.","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\/pivot-tablo-2\/","og_locale":"tr_TR","og_type":"article","og_title":"\u25b7 Excel&#39;de pivot tablo nas\u0131l olu\u015fturulur?","og_description":"Bu, sahip oldu\u011funuz t\u00fcm bilgileri i\u00e7eren, Excel&#39;de bir pivot tablo olu\u015fturmaya y\u00f6nelik ad\u0131m ad\u0131m bir k\u0131lavuzdur.","og_url":"https:\/\/exceladvisor.org\/tr\/pivot-tablo-2\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:02:02+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/difference-tableau-croise-dynamique-excel-et-tableau-excel-normal-1.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\/pivot-tablo-2\/","url":"https:\/\/exceladvisor.org\/tr\/pivot-tablo-2\/","name":"\u25b7 Excel&#39;de pivot tablo nas\u0131l olu\u015fturulur?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/pivot-tablo-2\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/pivot-tablo-2\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/difference-tableau-croise-dynamique-excel-et-tableau-excel-normal-1.png","datePublished":"2023-11-09T20:07:58+00:00","dateModified":"2023-12-10T06:02:02+00:00","description":"Bu, sahip oldu\u011funuz t\u00fcm bilgileri i\u00e7eren, Excel&#39;de bir pivot tablo olu\u015fturmaya y\u00f6nelik ad\u0131m ad\u0131m bir k\u0131lavuzdur.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/pivot-tablo-2\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/pivot-tablo-2\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/pivot-tablo-2\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/difference-tableau-croise-dynamique-excel-et-tableau-excel-normal-1.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/difference-tableau-croise-dynamique-excel-et-tableau-excel-normal-1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/pivot-tablo-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel&#39;de pivot tablo 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\/1718","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=1718"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1718\/revisions"}],"predecessor-version":[{"id":2573,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1718\/revisions\/2573"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=1718"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}