Bu e\u011fitimde, iki y\u0131l boyunca her ay \u00fcr\u00fcn sat\u0131\u015flar\u0131ndaki fark\u0131 g\u00f6steren a\u015fa\u011f\u0131daki \u00e7ubuk grafi\u011fin nas\u0131l olu\u015fturulaca\u011f\u0131na ili\u015fkin ad\u0131m ad\u0131m bir \u00f6rnek sunulmaktad\u0131r:<\/span> <\/p>\n Hadi gidelim!<\/span><\/p>\n \u00d6ncelikle bir \u015firketin iki y\u0131l \u00fcst \u00fcste her ay yapt\u0131\u011f\u0131 toplam \u00fcr\u00fcn sat\u0131\u015f\u0131n\u0131 g\u00f6steren a\u015fa\u011f\u0131daki veri setini olu\u015ftural\u0131m:<\/span> <\/p>\n Diyelim ki iki y\u0131l aras\u0131ndaki her ay toplam sat\u0131\u015flardaki fark\u0131 g\u00f6rselle\u015ftirmek i\u00e7in bir \u00e7ubuk grafik olu\u015fturmak istiyoruz.<\/span><\/p>\n Bu grafi\u011fi olu\u015fturmadan \u00f6nce, Ocak ay\u0131 i\u00e7in 1. y\u0131l ile 2. y\u0131l aras\u0131ndaki sat\u0131\u015flardaki y\u00fczde fark\u0131n\u0131 hesaplamak i\u00e7in ilk olarak D2<\/strong> h\u00fccresine a\u015fa\u011f\u0131daki form\u00fcl\u00fc yazabiliriz:<\/span><\/p>\n Daha sonra bu form\u00fcl\u00fc t\u0131klay\u0131p D s\u00fctunundaki kalan her h\u00fccreye s\u00fcr\u00fckleyebiliriz:<\/span> <\/p>\n S\u00fctun D art\u0131k birinci y\u0131l ile ikinci y\u0131l aras\u0131nda her ay sat\u0131\u015flardaki y\u00fczde de\u011fi\u015fimi g\u00f6steriyor:<\/span><\/p>\n Ard\u0131ndan, A1:C13<\/strong> h\u00fccre aral\u0131\u011f\u0131n\u0131 vurgulay\u0131n, ard\u0131ndan \u00fcst \u015feritteki Ekle<\/strong> sekmesine t\u0131klay\u0131n ve ard\u0131ndan Grafikler<\/strong> grubunda Grupland\u0131r\u0131lm\u0131\u015f S\u00fctun’a<\/strong> t\u0131klay\u0131n.<\/span> <\/p>\n A\u015fa\u011f\u0131daki grafik olu\u015fturulacakt\u0131r:<\/span> <\/p>\n Mavi \u00e7ubuklar 1. y\u0131l\u0131n her ay\u0131ndaki \u00fcr\u00fcn sat\u0131\u015flar\u0131n\u0131, turuncu \u00e7ubuklar ise 2. y\u0131l\u0131n her ay\u0131ndaki \u00fcr\u00fcn sat\u0131\u015flar\u0131n\u0131 g\u00f6sterir.<\/span><\/p>\n Daha sonra grafikteki turuncu \u00e7ubuklardan birine t\u0131klay\u0131n. Ard\u0131ndan grafi\u011fin sa\u011f \u00fcst k\u00f6\u015fesindeki k\u00fc\u00e7\u00fck ye\u015fil art\u0131 i\u015faretini t\u0131klay\u0131n, ard\u0131ndan Veri Etiketleri’nin<\/strong> yan\u0131ndaki a\u00e7\u0131l\u0131r oku ve ard\u0131ndan Di\u011fer Se\u00e7enekler’i<\/strong> t\u0131klay\u0131n:<\/span> <\/p>\n G\u00f6r\u00fcnt\u00fclenen Veri Etiketlerini Bi\u00e7imlendir<\/strong> panelinde H\u00fccrelerden De\u011fer’in<\/strong> yan\u0131ndaki kutuyu i\u015faretleyin, ard\u0131ndan Veri Etiketi Aral\u0131\u011f\u0131<\/strong> olarak D1:D13’\u00fc<\/strong> se\u00e7in ve ard\u0131ndan Tamam’\u0131<\/strong> t\u0131klay\u0131n. Ard\u0131ndan De\u011fer’in<\/strong> yan\u0131ndaki kutunun i\u015faretini kald\u0131r\u0131n.<\/span> <\/p>\n Veri etiketleri, birinci ve ikinci y\u0131llar aras\u0131ndaki her ay i\u00e7in sat\u0131\u015flardaki y\u00fczde de\u011fi\u015fimi g\u00f6stermek \u00fczere grafikteki her turuncu \u00e7ubu\u011fun \u00fczerinde g\u00f6r\u00fcnecektir:<\/span> <\/p>\n Konuyu daha estetik hale getirmek i\u00e7in ba\u015fl\u0131k eklemekten, renkleri \u00f6zelle\u015ftirmekten ve \u00e7ubuklar\u0131n geni\u015fli\u011fini ayarlamaktan \u00e7ekinmeyin:<\/span> <\/p>\n A\u015fa\u011f\u0131daki e\u011fitimlerde Excel’deki di\u011fer ortak g\u00f6revlerin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi a\u00e7\u0131klanmaktad\u0131r:<\/span><\/p>\n Excel: Bart grafi\u011findeki \u00e7ubuklar nas\u0131l s\u0131ralan\u0131r<\/a> \u00c7o\u011fu zaman Excel’de iki seri aras\u0131ndaki de\u011ferler aras\u0131ndaki fark\u0131 g\u00f6rselle\u015ftirmek i\u00e7in bir \u00e7ubuk grafik olu\u015fturmak isteyebilirsiniz. Bu e\u011fitimde, iki y\u0131l boyunca her ay \u00fcr\u00fcn sat\u0131\u015flar\u0131ndaki fark\u0131 g\u00f6steren a\u015fa\u011f\u0131daki \u00e7ubuk grafi\u011fin nas\u0131l olu\u015fturulaca\u011f\u0131na ili\u015fkin ad\u0131m ad\u0131m bir \u00f6rnek sunulmaktad\u0131r: Hadi gidelim! 1. Ad\u0131m: Verileri girin \u00d6ncelikle bir \u015firketin iki y\u0131l \u00fcst \u00fcste her ay yapt\u0131\u011f\u0131 toplam […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"class_list":["post-4883","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"\n![\"\u0130ki](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cdiff7.png\")
<\/p>\n 1. Ad\u0131m: Verileri girin<\/strong><\/span><\/h2>\n
![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cdiff1.png\")
<\/p>\n Ad\u0131m 2: \u0130ki seri aras\u0131ndaki farklar\u0131 hesaplay\u0131n<\/strong><\/span><\/h2>\n
=IF(MAX( B2:C2<\/span> )= C2<\/span> ,\"+\"&ROUND(( C2<\/span> - B2<\/span> )\/ B2<\/span> *100,1)&\"%\",ROUND(( C2<\/span> - B2<\/span> )\/ B2<\/span> *100,1)&\" %\")\n<\/strong><\/pre>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cdiff2.png\")
<\/p>\n Ad\u0131m 3: Farkl\u0131l\u0131klar\u0131 Olan Bir \u00c7ubuk Grafik Olu\u015fturun<\/strong><\/span><\/h2>\n
![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/diagramme-a-bandes.jpg\")
<\/p>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cdiff3.png\")
<\/p>\n Ad\u0131m 4: \u00c7ubuk Grafi\u011fe Etiketler Ekleme<\/strong><\/span><\/h2>\n
![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cdiff4.png\")
<\/p>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cdiff5.png\")
<\/p>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/cdiff6.png\")
<\/p>\n 5. Ad\u0131m: Grafi\u011fi \u00f6zelle\u015ftirin (iste\u011fe ba\u011fl\u0131)<\/strong><\/span><\/h2>\n
<\/p>\n Ek kaynaklar<\/strong><\/span><\/h2>\n
Excel: \u00c7ubuk Grafi\u011fe Ortalama \u00c7izgi Nas\u0131l Eklenir?<\/a>
Excel: Y\u0131\u011f\u0131lm\u0131\u015f \u00c7ubuk Grafi\u011fe Toplam De\u011ferler Nas\u0131l Eklenir?<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"