{"id":5114,"date":"2023-07-03T09:27:11","date_gmt":"2023-07-03T09:27:11","guid":{"rendered":"https:\/\/statorials.org\/id\/tabel-excel-tiga-dimensi\/"},"modified":"2023-07-03T09:27:11","modified_gmt":"2023-07-03T09:27:11","slug":"tabel-excel-tiga-dimensi","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/tabel-excel-tiga-dimensi\/","title":{"rendered":"Cara membuat tabel tiga dimensi di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Seringkali, Anda mungkin ingin membuat tabel tiga dimensi di Excel untuk menampilkan data dari tiga tabel berbeda secara bersamaan.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, Anda mungkin ingin membuat sesuatu yang mirip dengan tabel 3D ini yang menampilkan nilai penjualan untuk tiga variabel (toko, tahun, dan produk) sekaligus:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-39864\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/troistable8.png\" alt=\"tabel tiga dimensi di Excel\" width=\"479\" height=\"382\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Contoh langkah demi langkah berikut menunjukkan dengan tepat bagaimana melakukan hal ini.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan data untuk setiap tabel<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Pertama, kita akan memasukkan nilai penjualan untuk masing-masing dari tiga tabel yang akan kita gunakan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-39857 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/troistable1.png\" alt=\"\" width=\"468\" height=\"444\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 2: Tambahkan Alat Kamera ke Bilah Alat Akses Cepat<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Selanjutnya, kita akan menambahkan <strong>alat Kamera<\/strong> ke Quick Access Toolbar.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk melakukannya, klik panah drop-down kecil di bagian atas buku kerja, lalu klik <strong>Pesanan Lainnya<\/strong> di menu drop-down:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36982 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/floata4.png\" alt=\"\" width=\"417\" height=\"542\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Di jendela baru yang muncul, klik <strong>Quick Access Toolbar<\/strong> di menu samping, lalu klik <strong>Commands Not on Ribbon<\/strong> di menu drop-down, lalu gulir ke bawah hingga Anda melihat <strong>Camera<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Klik pada <strong>Kamera<\/strong> lalu klik <strong>Tambah<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36983 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/floata5.png\" alt=\"\" width=\"672\" height=\"529\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setelah Anda mengklik <strong>OK<\/strong> , ikon kamera kecil akan ditambahkan ke Quick Access Toolbar:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36984 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/floata6.png\" alt=\"\" width=\"477\" height=\"153\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 3: Gunakan Alat Kamera untuk Membuat Tabel Mengambang<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Selanjutnya, sorot rentang sel <strong>A2:D6<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kemudian klik ikon <strong>Kamera<\/strong> di Quick Access Toolbar.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kemudian klik sel mana pun di lembar kerja dan tabel mengambang akan otomatis disisipkan di sana.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk contoh ini, kita akan mengklik sel <strong>F2<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-39858 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/troistable2.png\" alt=\"\" width=\"602\" height=\"414\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, sorot cell range <strong>A8:D11<\/strong> , lalu klik ikon <strong>Kamera<\/strong> , lalu masukkan tabel ke dalam sel <strong>F8<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, sorot cell range <strong>B14:D18<\/strong> , lalu klik ikon <strong>Kamera<\/strong> , lalu masukkan tabel ini ke dalam sel <strong>F13<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-39859 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/troistable3.png\" alt=\"\" width=\"611\" height=\"410\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 4: Putar tabel untuk membuat tabel tiga dimensi<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Selanjutnya klik floating table pertama, lalu ketik <strong>Ctrl + 1<\/strong> untuk menampilkan panel <strong>Format Picture<\/strong> .<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-39860 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/troistable4.png\" alt=\"\" width=\"297\" height=\"555\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Klik label tarik-turun <strong>Rotasi 3D<\/strong> , lalu klik ikon di samping <strong>Preset<\/strong> , lalu pilih <strong>Isometrik: Kiri Bawah<\/strong> dari opsi:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-39861 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/troistable5.png\" alt=\"\" width=\"239\" height=\"578\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Tabel akan otomatis berputar:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-39862 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/troistable6.png\" alt=\"\" width=\"464\" height=\"432\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Ulangi proses ini untuk dua tabel berikutnya, pilih <strong>Isometrik: bawah ke bawah<\/strong> untuk tabel kedua dan <strong>Isometrik: atas ke atas<\/strong> untuk tabel ketiga.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Terakhir, seret ketiga tabel tersebut hingga membentuk tabel tiga dimensi:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-39863 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/troistable7-1.png\" alt=\"\" width=\"513\" height=\"412\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa Anda mungkin perlu menyesuaikan ukuran setiap papan sebelum memutar dan memindahkannya agar terpasang dengan benar.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Terakhir, jangan ragu untuk menerapkan pemformatan ke tiga tabel asli, yang secara otomatis akan memperbarui pemformatan tabel di tabel tiga dimensi akhir:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-39864\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/troistable8.png\" alt=\"tabel tiga dimensi di Excel\" width=\"479\" height=\"382\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan operasi umum lainnya di Excel:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/excel-membuat-laporan-dalam-bentuk-tabel\/\" target=\"_blank\" rel=\"noopener\">Excel: cara membuat laporan dalam bentuk tabel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-mengonversi-tabel-menjadi-daftar\/\" target=\"_blank\" rel=\"noopener\">Excel: cara mengubah tabel menjadi daftar<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/tabel-mengambang-excel\/\" target=\"_blank\" rel=\"noopener\">Excel: cara membuat tabel mengambang<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-membandingkan-dua-tabel\/\" target=\"_blank\" rel=\"noopener\">Excel: cara membandingkan dua tabel<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seringkali, Anda mungkin ingin membuat tabel tiga dimensi di Excel untuk menampilkan data dari tiga tabel berbeda secara bersamaan. Misalnya, Anda mungkin ingin membuat sesuatu yang mirip dengan tabel 3D ini yang menampilkan nilai penjualan untuk tiga variabel (toko, tahun, dan produk) sekaligus: Contoh langkah demi langkah berikut menunjukkan dengan tepat bagaimana melakukan hal ini. [&hellip;]<\/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":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Cara membuat tabel tiga dimensi di Excel - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membuat tabel tiga dimensi di Excel, beserta contoh lengkapnya.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/statorials.org\/id\/tabel-excel-tiga-dimensi\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara membuat tabel tiga dimensi di Excel - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membuat tabel tiga dimensi di Excel, beserta contoh lengkapnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/tabel-excel-tiga-dimensi\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-03T09:27:11+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/troistable8.png\" \/>\n<meta name=\"author\" content=\"Benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Ditulis oleh\" \/>\n\t<meta name=\"twitter:data1\" content=\"Benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/tabel-excel-tiga-dimensi\/\",\"url\":\"https:\/\/statorials.org\/id\/tabel-excel-tiga-dimensi\/\",\"name\":\"Cara membuat tabel tiga dimensi di Excel - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-03T09:27:11+00:00\",\"dateModified\":\"2023-07-03T09:27:11+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membuat tabel tiga dimensi di Excel, beserta contoh lengkapnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/tabel-excel-tiga-dimensi\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/tabel-excel-tiga-dimensi\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/tabel-excel-tiga-dimensi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara membuat tabel tiga dimensi di excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/id\/#website\",\"url\":\"https:\/\/statorials.org\/id\/\",\"name\":\"Statorials\",\"description\":\"Panduan anda untuk kompetensi statistik!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/id\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"id\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\",\"name\":\"Benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Benjamin anderson\"},\"description\":\"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya\",\"sameAs\":[\"http:\/\/statorials.org\/id\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Cara membuat tabel tiga dimensi di Excel - Statologi","description":"Tutorial ini menjelaskan cara membuat tabel tiga dimensi di Excel, beserta contoh lengkapnya.","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:\/\/statorials.org\/id\/tabel-excel-tiga-dimensi\/","og_locale":"id_ID","og_type":"article","og_title":"Cara membuat tabel tiga dimensi di Excel - Statologi","og_description":"Tutorial ini menjelaskan cara membuat tabel tiga dimensi di Excel, beserta contoh lengkapnya.","og_url":"https:\/\/statorials.org\/id\/tabel-excel-tiga-dimensi\/","og_site_name":"Statorials","article_published_time":"2023-07-03T09:27:11+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/troistable8.png"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/tabel-excel-tiga-dimensi\/","url":"https:\/\/statorials.org\/id\/tabel-excel-tiga-dimensi\/","name":"Cara membuat tabel tiga dimensi di Excel - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-03T09:27:11+00:00","dateModified":"2023-07-03T09:27:11+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membuat tabel tiga dimensi di Excel, beserta contoh lengkapnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/tabel-excel-tiga-dimensi\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/tabel-excel-tiga-dimensi\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/tabel-excel-tiga-dimensi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara membuat tabel tiga dimensi di excel"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/id\/#website","url":"https:\/\/statorials.org\/id\/","name":"Statorials","description":"Panduan anda untuk kompetensi statistik!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/id\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"id"},{"@type":"Person","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81","name":"Benjamin anderson","image":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/","url":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Benjamin anderson"},"description":"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya","sameAs":["http:\/\/statorials.org\/id"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/5114"}],"collection":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/comments?post=5114"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/5114\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=5114"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=5114"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=5114"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}