Grafik Oluşturma

WEBVTT 00:00:02.017 --> 00:00:07.639 In Übung 13 werden wir an den Grafiken zum Verkaufsbericht arbeiten. 00:00:08.199 --> 00:00:16.922 Was wir über die Grafiken wissen müssen, ist, dass die Grafiken, die ich hier erstellt habe, ein Bild sind. 00:00:16.982 --> 00:00:23.765 Ich habe Ihnen hier Beispiele gezeigt. 00:00:24.025 --> 00:00:30.272 Unser Ziel ist es jetzt, diese Grafiken selbst zu erstellen. 00:00:30.412 --> 00:00:34.814 Wir sehen bereits die Arten von Grafiken, die von uns verlangt werden. 00:00:34.894 --> 00:00:35.954 Was machen wir also? 00:00:36.254 --> 00:00:42.077 Wie Sie sehen können, ist es möglich, den Verkaufsbericht so zu formatieren, wie ich es getan habe oder wie Sie im Beispiel sehen. 00:00:43.757 --> 00:00:47.299 Das liegt ganz bei Ihnen. 00:00:48.680 --> 00:01:00.384 Nachdem wir den Bereich des Verkaufsberichts ausgewählt haben, gehe ich wie wir uns erinnern in das Feld "Einfügen" und was hier von uns verlangt wird, ist zuerst 00:01:00.544 --> 00:01:01.444 eine Säule von uns. 00:01:03.805 --> 00:01:18.209 Wenn wir eine Säule auswählen, wie Sie sehen können, Istanbul, Ankara, Izmir, Samsun und Tekirdağ, entschuldigen Sie, das wird nicht Tekirdağ sein, das wird insgesamt sein. 00:01:20.212 --> 00:01:24.936 Wie Sie sehen können, wenn ich es in "Gesamt" ändere, hat es sich automatisch in diesem Bereich geändert. 00:01:25.496 --> 00:01:30.479 Ich wähle den Titel des Diagramms und nenne es Verkaufsbericht. 00:01:31.679 --> 00:01:39.743 Und wir sehen, wie die Werte wie Inlandsbau, Werkzeuge und Garten insgesamt in den Städten sind. 00:01:40.344 --> 00:01:46.327 Eine weitere Sache, die Sie hier sehen, ist, dass der Prozentsatz nicht nach der Summe berechnet wird, weil unsere y-Achse hier ist. 00:01:49.254 --> 00:01:56.416 Da der Wert nicht über den TRL-Wert, sondern über den TL-Wert erfolgt, ist es hier nicht möglich, den Prozentsatzwert anzugeben. 00:01:56.476 --> 00:01:57.557 Was machen wir dann? 00:01:58.697 --> 00:01:59.837 Wir wählen das Diagramm aus. 00:02:01.518 --> 00:02:04.278 Nachdem wir das Diagramm ausgewählt haben, gehen wir zum Befehl "Daten auswählen". 00:02:04.378 --> 00:02:12.987 Wenn wir in den Befehl "Daten auswählen" gehen, entfernen wir die Option "Nach Summe %" auswählen. 00:02:13.067 --> 00:02:19.351 Wenn wir vollständig drücken, wird unser Diagramm automatisch in die gewünschte Form gebracht, wie Sie sehen. 00:02:20.492 --> 00:02:21.773 Was machen wir als Nächstes? 00:02:22.493 --> 00:02:24.054 Wir möchten Werte hinzufügen. 00:02:24.094 --> 00:02:26.956 Um Datenetiketten hinzuzufügen, haben wir den gesamten Bereich ausgewählt. 00:02:30.398 --> 00:02:42.909 Wenn wir Datenetiketten hinzufügen, möchten wir Datenetiketten hinzufügen. 00:02:42.969 --> 00:02:44.269 Datenetiketten hinzufügen. 00:02:48.711 --> 00:03:01.517 Wie Sie sehen, führen wir denselben Vorgang für TL-Werte für alle Serien durch. 00:03:01.637 --> 00:03:06.319 Wir wählen zuerst die linke Fernlichtzahlung aus und öffnen dann das Dialogfeld mit der rechten Fernlichtzahlung. 00:03:08.200 --> 00:03:11.903 Nachdem der Vorgang abgeschlossen ist, sind wir uns bewusst, dass der Bildschirm überfüllt ist. 00:03:12.163 --> 00:03:13.364 Was werden wir dafür tun? 00:03:15.106 --> 00:03:16.367 Wir werden unser Diagramm vergrößern. 00:03:16.967 --> 00:03:18.909 Wenn wir unser Diagramm vergrößern, werden die Zahlen... 00:03:21.291 --> 00:03:23.192 die Werte ordentlicher angeordnet sein. 00:03:23.833 --> 00:03:26.294 Ich verkleinere ein wenig die Bildschirmanzeige. 00:03:27.895 --> 00:03:29.757 Was habe ich getan? 00:03:29.837 --> 00:03:31.819 Damit ich es bequem machen kann. 00:03:33.220 --> 00:03:35.962 Ja, wir haben unser erstes Diagramm erstellt. 00:03:36.343 --> 00:03:36.603 Okay. 00:03:39.491 --> 00:03:40.251 Was machen wir jetzt? 00:03:40.311 --> 00:03:42.512 Lassen Sie uns dieses Diagramm kopieren und einfügen. 00:03:50.454 --> 00:03:51.735 Dafür wählen wir das Diagramm aus. 00:03:51.835 --> 00:03:54.055 Strg C, dann Strg V. 00:03:55.336 --> 00:03:56.276 Das ausgewählte Diagramm... 00:04:01.753 --> 00:04:06.856 führen wir hier die Operationen durch, um das Format zu ändern. 00:04:06.896 --> 00:04:14.121 Wie Sie sehen können, können wir hier verschiedene Änderungen im Grafikdesign vornehmen. 00:04:17.202 --> 00:04:23.826 Was könnten wir sonst noch ändern, was dieses Diagramm betrifft? 00:04:24.967 --> 00:04:33.106 Wir können beispielsweise eine Anpassung nach Produktgruppe vornehmen, wie im Beispiel hier gezeigt. 00:04:33.946 --> 00:04:41.767 Der Vorgang, den wir durchführen werden, um eine Anpassung nach Produktgruppe vorzunehmen. 00:04:42.549 --> 00:04:47.430 Ändern Sie den Diagrammtyp, gehen Sie zum Datenbereich. 00:04:48.551 --> 00:04:54.424 Im Datenbereich möchte ich die horizontalen Kategorieachsen erneut anpassen. 00:04:55.064 --> 00:05:00.649 Als ich auf Anpassen klickte, wählte ich die horizontalen Kategorieachsen so aus. 00:05:02.390 --> 00:05:03.051 Danach... 00:05:08.555 --> 00:05:10.697 ...in den Anzeigeeingaben... 00:05:14.901 --> 00:05:18.924 ...klicke auf Anpassen und wähle zwei Städte aus. 00:05:27.779 --> 00:05:44.123 Wenn ich auf "Okay" klicke und die Kamera schließe, sehen Sie, dass wir die Verteilung im Garten, Werkzeugen, Bau und Gesamtflächen zeigen.

WEBVTT 00:00:02.017 --> 00:00:07.639 We will work on the graphs related to the sales report in Exercise 13. 00:00:08.199 --> 00:00:16.922 One thing we need to know about the graphs is that the graphs I have created here are images. 00:00:16.982 --> 00:00:23.765 I have presented these as examples to you. 00:00:24.025 --> 00:00:30.272 Now our goal will be to create these graphs ourselves. 00:00:30.412 --> 00:00:34.814 We already see the types of graphs requested from us here. 00:00:34.894 --> 00:00:35.954 So what do we do? 00:00:36.254 --> 00:00:42.077 As you can see, it is possible to format the sales report as I did or as you saw in the example. 00:00:43.757 --> 00:00:47.299 This is entirely up to you. 00:00:48.680 --> 00:01:00.384 Now, after selecting the area of the sales report, I come to the inserted field as we remember, and what is requested from us here, beyond the recommendations initially 00:01:00.544 --> 00:01:01.444 is that we are asked for columns. 00:01:03.805 --> 00:01:18.209 When we select as columns, as you can see, Istanbul, Ankara, Izmir, Samsun, and Tekirdag, sorry, this is not Tekirdag, this will be the total here. 00:01:20.212 --> 00:01:24.936 As you can see, when I changed it to total, it automatically changed in this area. 00:01:25.496 --> 00:01:30.479 I select the graph title and say sales report. 00:01:31.679 --> 00:01:39.743 And we see how the values of domestic construction, tools and equipment, and garden total are in the cities. 00:01:40.344 --> 00:01:46.327 Another thing you see here is that the percentage does not appear according to the total because our y-axis is here. 00:01:49.254 --> 00:01:56.416 Since it is based on TRL, it is not possible for the % value to appear here. 00:01:56.476 --> 00:01:57.557 So what do we do? 00:01:58.697 --> 00:01:59.837 We select the graph. 00:02:01.518 --> 00:02:04.278 After selecting the graph, we go to the data selection command. 00:02:04.378 --> 00:02:12.987 When we enter the data selection command, we remove the option for % according to the sum. 00:02:13.067 --> 00:02:19.351 As you can see, our graph automatically takes the shape we want when we press it completely. 00:02:20.492 --> 00:02:21.773 What should we do next? 00:02:22.493 --> 00:02:24.054 We want to add values. 00:02:24.094 --> 00:02:26.956 We selected the entire area to add data labels. 00:02:30.398 --> 00:02:42.909 When we add data labels, we want to add data labels. 00:02:42.969 --> 00:02:44.269 Add data labels. 00:02:48.711 --> 00:03:01.517 As you can see, we perform the same process for TL values for all series. 00:03:01.637 --> 00:03:06.319 First, we select the left headlight payment, then we open the dialog box with the right headlight payment. 00:03:08.200 --> 00:03:11.903 After the process is completed, we are aware that the screen is crowded. 00:03:12.163 --> 00:03:13.364 What will we do for this purpose? 00:03:15.106 --> 00:03:16.367 We will enlarge our graph. 00:03:16.967 --> 00:03:18.909 When we enlarge our graph, the numbers will align more smoothly... 00:03:21.291 --> 00:03:23.192 the values will sit more neatly. 00:03:23.833 --> 00:03:26.294 I'm reducing the screen display a bit. 00:03:27.895 --> 00:03:29.757 I performed the operations. 00:03:29.837 --> 00:03:31.819 So that I can perform comfortably. 00:03:33.220 --> 00:03:35.962 Yes, we have created our first graph. 00:03:36.343 --> 00:03:36.603 Okay. 00:03:39.491 --> 00:03:40.251 Now what should we do? 00:03:40.311 --> 00:03:42.512 Let's copy and paste this graph. 00:03:50.454 --> 00:03:51.735 We select the graph for this. 00:03:51.835 --> 00:03:54.055 Ctrl C, then Ctrl V. 00:03:55.336 --> 00:03:56.276 The selected graph... 00:04:01.753 --> 00:04:06.856 we perform the operations here to change the format. 00:04:06.896 --> 00:04:14.121 As you can see, it is possible to make various changes related to graphic design from here. 00:04:17.202 --> 00:04:23.826 On the other hand, what are the things we can change about this graph? 00:04:24.967 --> 00:04:33.106 For example, as we see in the example, we can make an arrangement according to the product group. 00:04:33.946 --> 00:04:41.767 The operation we will perform to make an arrangement according to the product group. 00:04:42.549 --> 00:04:47.430 Change the graph type, come to the data selection area. 00:04:48.551 --> 00:04:54.424 In the data selection area, I want to rearrange the horizontal category axes. 00:04:55.064 --> 00:05:00.649 When I say edit, I selected the horizontal category axes like this. 00:05:02.390 --> 00:05:03.051 Then... 00:05:08.555 --> 00:05:10.697 ...within the indicator inputs... 00:05:14.901 --> 00:05:18.924 ...I want to select two cities by saying edit. 00:05:27.779 --> 00:05:44.123 As you can see, when I say 'okay' and close it, we see the distribution in the garden, tools, construction, and total areas.

WEBVTT 00:00:02.017 --> 00:00:07.639 Alıştırma 13'te satış raporuyla ilgili grafikler üzerinde çalışacağız. 00:00:08.199 --> 00:00:16.922 Grafiklerle ilgili bilmemiz gereken şey burada oluşturduğum grafiklerin bir resim olduğu. 00:00:16.982 --> 00:00:23.765 Size örnek olarak bunları sundum. 00:00:24.025 --> 00:00:30.272 Şimdi bizim amacımız bu grafikleri kendimiz oluşturmak olacak. 00:00:30.412 --> 00:00:34.814 Bizden istenen grafiklerin çeşitlerini burada zaten görüyoruz. 00:00:34.894 --> 00:00:35.954 O zaman ne yapıyoruz? 00:00:36.254 --> 00:00:42.077 Gördüğünüz gibi satış raporunu benim yaptığım gibi veya örnekte gördüğünüz gibi biçimlendirmeniz mümkün. 00:00:43.757 --> 00:00:47.299 Bu tamamen size kalmış bir şey. 00:00:48.680 --> 00:01:00.384 Şimdi satış raporunun alanını seçtikten sonra ekli alanına geliyorum hatırladığımız gibi ve buradan bizden istenen şey, önerilenlerden ötesinde ilk başta 00:01:00.544 --> 00:01:01.444 sütun isteniyor bizden. 00:01:03.805 --> 00:01:18.209 Sütun olarak seçtiğimizde gördüğünüz gibi İstanbul, Ankara, İzmir, Samsun ve Tekirdağ da pardon bu Tekirdağ değil burası toplam olacak. 00:01:20.212 --> 00:01:24.936 Toplam gördüğünüz gibi değiştirdiğimde otomatik olarak bu alanda değişmiş oldu. 00:01:25.496 --> 00:01:30.479 Grafik başlığını seçip satış raporu diyorum. 00:01:31.679 --> 00:01:39.743 Ve domestik inşaat, alet edevat ve bahçe toplam gibi değerlerin şehirlerde ne durumda olduğunu görüyoruz. 00:01:40.344 --> 00:01:46.327 Burada gördüğünüz diğer bir şey toplama göre % alanın çıkmaması çünkü y aksisimiz burada. 00:01:49.254 --> 00:01:56.416 TRL yani tl değeri üzerinden olduğu için % değerinin burada belirmesi mümkün değil. 00:01:56.476 --> 00:01:57.557 O zaman ne yapıyoruz? 00:01:58.697 --> 00:01:59.837 Grafiği seçiyoruz. 00:02:01.518 --> 00:02:04.278 Grafiği seçtikten sonra veri seç komutuna geliyoruz. 00:02:04.378 --> 00:02:12.987 Veri seç komutunun içerisine geldiğimizde Toplama göre % seçeneğini kaldırıyoruz. 00:02:13.067 --> 00:02:19.351 Tamamen bastığımızda gördüğünüz gibi grafiyemiz otomatik olarak istediğimiz şekle geldi. 00:02:20.492 --> 00:02:21.773 Daha sonra ne yapalım? 00:02:22.493 --> 00:02:24.054 Değer eklemek istiyoruz. 00:02:24.094 --> 00:02:26.956 Veri etiketleri ekledemek için tüm alanı seçtik. 00:02:30.398 --> 00:02:42.909 Veri etiketi eklediğimizde veri etiketi eklemek istiyoruz. 00:02:42.969 --> 00:02:44.269 Veri etiketleri ekle. 00:02:48.711 --> 00:03:01.517 Gördüğünüz gibi TL değerleri tüm seriler için aynı işlemi gerçekleştiriyoruz. 00:03:01.637 --> 00:03:06.319 Önce sol farö ödümesi seçiyoruz, sonra sağ farö ödümesi ile iletişim kutusunu açıyoruz. 00:03:08.200 --> 00:03:11.903 İşlem gerçekleştikten sonra ekranın kalabalık olduğunun farkındayız. 00:03:12.163 --> 00:03:13.364 Bu amaçla ne yapacağız? 00:03:15.106 --> 00:03:16.367 Grafimizi büyüteceğiz. 00:03:16.967 --> 00:03:18.909 Grafimizi büyüttüğümüzde rakamlar daha... 00:03:21.291 --> 00:03:23.192 değerler daha düzgün oturacak. 00:03:23.833 --> 00:03:26.294 Biraz ekranın görüntüsünü küçültüyorum. 00:03:27.895 --> 00:03:29.757 Ki gerçekleştirdim işlemleri. 00:03:29.837 --> 00:03:31.819 Rahat bir şekilde gerçekleştirebileyim. 00:03:33.220 --> 00:03:35.962 Evet, birinci grafimizi oluşturmuş olduk. 00:03:36.343 --> 00:03:36.603 Peki. 00:03:39.491 --> 00:03:40.251 Şimdi ne yapalım? 00:03:40.311 --> 00:03:42.512 Bu grafiği alıp kopyalayıp yapıştıralım. 00:03:50.454 --> 00:03:51.735 Bunun için grafiği seçiyoruz. 00:03:51.835 --> 00:03:54.055 Ctrl C, sonra Ctrl V. 00:03:55.336 --> 00:03:56.276 Seçilen grafiği... 00:04:01.753 --> 00:04:06.856 biçim olarak değiştirmek için buradan işlemleri gerçekleştiriyoruz. 00:04:06.896 --> 00:04:14.121 Grafik tasarımı ile ilgili çeşitli değişiklikleri de gördüğünüz gibi buradan yapabilmemiz mümkün. 00:04:17.202 --> 00:04:23.826 Diğer bir yandan bu grafikle ilgili değiştirebileceğimiz şeyler mesela ne olabilir? 00:04:24.967 --> 00:04:33.106 Burada örnekte gördüğümüz gibi Bir de ürün grubuna göre bir düzenleme yapabiliriz. 00:04:33.946 --> 00:04:41.767 Ürün grubuna göre düzenleme yapmak için gerçekleştireceğimiz işlem. 00:04:42.549 --> 00:04:47.430 Grafik türünü değiştir, veri seç alanına geliyoruz. 00:04:48.551 --> 00:04:54.424 Veri seç alanında Yatay kategori eksenlerini tekrar düzenlemek istiyorum. 00:04:55.064 --> 00:05:00.649 Düzenle dediğimde yatay kategori eksenlerini bu şekilde seçtim. 00:05:02.390 --> 00:05:03.051 Daha sonra... 00:05:08.555 --> 00:05:10.697 ...gösterge girdilerin içerisinde... 00:05:14.901 --> 00:05:18.924 ...düzenle deyip iki tane şehir seçmek istiyorum. 00:05:27.779 --> 00:05:44.123 Tamam deyip kapattığımda gördüğünüz gibi bahçe, alet edevat, inşaat ve toplam alanlarda dağılımı göstermiş oluyoruz.