Neyse ki, bunu yapmak olduk\u00e7a basit ve a\u015fa\u011f\u0131daki ad\u0131m ad\u0131m \u00f6rnek, Excel’de a\u015fa\u011f\u0131daki zaman \u00e7izelgesinin nas\u0131l olu\u015fturulaca\u011f\u0131n\u0131 g\u00f6steriyor:<\/span> <\/p>\n Hadi gidelim!<\/span><\/p>\n \u00d6ncelikle a\u015fa\u011f\u0131daki verileri Excel’e girece\u011fiz:<\/span> <\/p>\n Ard\u0131ndan A2:B11<\/strong> h\u00fccre aral\u0131\u011f\u0131n\u0131 vurgulay\u0131n.<\/span><\/p>\n Ard\u0131ndan \u00fcst \u015feritteki Ekle<\/strong> sekmesine t\u0131klay\u0131n ve ard\u0131ndan Grupland\u0131r\u0131lm\u0131\u015f S\u00fctun<\/strong> adl\u0131 simgeye t\u0131klay\u0131n:<\/span> <\/p>\n A\u015fa\u011f\u0131daki \u00e7ubuk grafi\u011fi olu\u015fturulacakt\u0131r:<\/span> <\/p>\n Ard\u0131ndan grafi\u011fin sa\u011f \u00fcst k\u00f6\u015fesindeki ye\u015fil art\u0131 i\u015faretini t\u0131klay\u0131n, ard\u0131ndan Veri Etiketleri’ni<\/strong> ve ard\u0131ndan Di\u011fer Se\u00e7enekler’i<\/strong> t\u0131klay\u0131n:<\/span> <\/p>\n Ekran\u0131n sa\u011f taraf\u0131nda g\u00f6r\u00fcnen panelde De\u011ferler’in<\/strong> yan\u0131ndaki kutunun i\u015faretini kald\u0131r\u0131n, ard\u0131ndan H\u00fccrelerden De\u011fer’in<\/strong> yan\u0131ndaki kutuyu i\u015faretleyin.<\/span><\/p>\n G\u00f6r\u00fcnt\u00fclenen pencerede C2:C11<\/strong> aral\u0131\u011f\u0131n\u0131 se\u00e7in ve ard\u0131ndan Tamam’a<\/strong> t\u0131klay\u0131n:<\/span> <\/p>\n \u201cG\u00f6rev Ad\u0131\u201d s\u00fctunundaki de\u011ferler grafi\u011fe eklenecektir:<\/span> <\/p>\n Daha sonra grafikteki herhangi bir \u00e7ubu\u011fa t\u0131klay\u0131n. Ekran\u0131n sa\u011f taraf\u0131ndaki Veri Serisini Bi\u00e7imlendir<\/strong> panelinde Dolgu yok’u<\/strong> se\u00e7in:<\/span> <\/p>\n Ard\u0131ndan grafi\u011fin sa\u011f \u00fcst k\u00f6\u015fesindeki k\u00fc\u00e7\u00fck art\u0131 i\u015faretini t\u0131klay\u0131n, ard\u0131ndan Hata \u00c7ubuklar\u0131’n\u0131<\/strong> ve ard\u0131ndan Di\u011fer Se\u00e7enekler’i<\/strong> t\u0131klay\u0131n:<\/span> <\/p>\n Ekran\u0131n sa\u011f taraf\u0131nda g\u00f6r\u00fcnen Hata \u00c7ubuklar\u0131n\u0131 Bi\u00e7imlendir<\/strong> panelinde Y\u00f6n olarak Eksi’yi<\/strong> se\u00e7in, ard\u0131ndan Hata Tutar\u0131 olarak Y\u00fczde’yi<\/strong> t\u0131klay\u0131n ve %100<\/strong> yaz\u0131n:<\/span> <\/p>\n Grafik \u00e7ubuklar\u0131 art\u0131k \u00e7izgiler halinde g\u00f6r\u00fcnecektir:<\/span> <\/p>\n Son olarak, a\u015fa\u011f\u0131daki de\u011fi\u015fiklikleri yaparak grafi\u011fi \u00f6zelle\u015ftirmekten \u00e7ekinmeyin:<\/span><\/p>\n Son zaman \u00e7izelgesi \u015f\u00f6yle g\u00f6r\u00fcnecek:<\/span> <\/p>\n Not<\/strong> : X ekseni alt\u0131nda herhangi bir olay\u0131n g\u00f6r\u00fcnt\u00fclenmesini istemiyorsan\u0131z, elektronik tablodaki “G\u00f6rev Y\u00fcksekli\u011fi” s\u00fctunundaki t\u00fcm de\u011ferleri pozitif yapman\u0131z yeterlidir.<\/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’de \u0130lerleme \u00c7ubuklar\u0131 Nas\u0131l Olu\u015fturulur<\/a> Genellikle belirli olaylar\u0131n ne zaman ger\u00e7ekle\u015fece\u011fini g\u00f6rselle\u015ftirmek i\u00e7in Excel’de bir zaman \u00e7izelgesi olu\u015fturmak isteyebilirsiniz. Neyse ki, bunu yapmak olduk\u00e7a basit ve a\u015fa\u011f\u0131daki ad\u0131m ad\u0131m \u00f6rnek, Excel’de a\u015fa\u011f\u0131daki zaman \u00e7izelgesinin nas\u0131l olu\u015fturulaca\u011f\u0131n\u0131 g\u00f6steriyor: Hadi gidelim! 1. Ad\u0131m: Verileri girin \u00d6ncelikle a\u015fa\u011f\u0131daki verileri Excel’e girece\u011fiz: Ad\u0131m 2: \u00c7ubuk Grafik Ekleme Ard\u0131ndan A2:B11 h\u00fccre aral\u0131\u011f\u0131n\u0131 vurgulay\u0131n. Ard\u0131ndan \u00fcst […]<\/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-4637","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/chronologie10.png\")
<\/p>\n 1. Ad\u0131m: Verileri girin<\/span><\/strong><\/h2>\n
![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/chronologie1-1.png\")
<\/p>\n Ad\u0131m 2: \u00c7ubuk Grafik Ekleme<\/span><\/strong><\/h2>\n
![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/diagramme-a-bandes.jpg\")
<\/p>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/chronologie2.png\")
<\/p>\n 3. Ad\u0131m: Veri Etiketlerini Ekleyin<\/span><\/strong><\/h2>\n
![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/chronologie3.png\")
<\/p>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/chronologie4.png\")
<\/p>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/chronologie5.png\")
<\/p>\n Ad\u0131m 4: \u00c7ubuklar\u0131 D\u00fczenleyin<\/strong><\/span><\/h2>\n
![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/chronologie6.png\")
<\/p>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/chronologie7.png\")
<\/p>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/chronologie8.png\")
<\/p>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/chronologie9.png\")
<\/p>\n 5. Ad\u0131m: Grafi\u011fi \u00f6zelle\u015ftirin<\/strong><\/span><\/h2>\n
\n
<\/p>\n Ek kaynaklar<\/span><\/strong><\/h2>\n
Excel’de \u00c7ift Halka Grafi\u011fi Nas\u0131l Olu\u015fturulur<\/a>
Excel’de Pasta Grafi\u011fi \u00c7ubu\u011fu Nas\u0131l Olu\u015fturulur<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"