Cara Menyisipkan Sumbu Y Kedua pada Grafik Excel

Unduh PDF
Disusun bersama Staf wikiHow

Unduh PDF

Menampilkan beberapa data tren pada satu grafik di Excel memang membantu. Sayangnya, jika data Anda memiliki unit-unit yang berbeda, Anda mungkin merasa tidak bisa atau kesulitan membuat grafik yang diperlukan. Tenang! Anda bisa melakukannya. Proses pembuatan grafik seperti ini pun cukup mudah! Artikel wikiHow ini akan menunjukkan kepada Anda cara menambahkan sumbu Y kedua pada grafik di Microsoft Excel.

Bagian 1
Bagian 1 dari 2:

Menambahkan Sumbu Y Kedua

Unduh PDF
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/0\/06\/Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-1-Version-3.jpg\/v4-460px-Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-1-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/0\/06\/Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-1-Version-3.jpg\/v4-728px-Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-1-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Setiap data harus ditambahkan ke kotak terpisah dengan baris dan kolom yang sudah dilabeli.
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/c\/cb\/Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-2-Version-3.jpg\/v4-460px-Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-2-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/c\/cb\/Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-2-Version-3.jpg\/v4-728px-Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-2-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Klik dan seret kursor untuk menandai semua data yang ingin dijadikan grafik. Pastikan Anda menandai semua entri data dan label.
    • Jika Anda tidak ingin membuat grafik dari lembar lajur secara keseluruhan, Anda bisa memilih beberapa kotak dengan menahan tombol Ctrl dan mengeklik setiap kotak yang ingin dijadikan sumber data grafik.
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/f\/f5\/Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-3-Version-2.jpg\/v4-460px-Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-3-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/f\/f5\/Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-3-Version-2.jpg\/v4-728px-Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-3-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Opsi ini berada pada bilah menu di atas halaman. Panel “ Insert ” akan ditampilkan di atas jendela Excel.
  4. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/e\/e3\/Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-4-Version-3.jpg\/v4-460px-Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-4-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/e3\/Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-4-Version-3.jpg\/v4-728px-Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-4-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Setelah itu, grafik akan dibuat berdasarkan data terpilih.
  5. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/f\/fa\/Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-5-Version-3.jpg\/v4-460px-Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-5-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/f\/fa\/Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-5-Version-3.jpg\/v4-728px-Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-5-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Jika Anda mengeklik satu kali, setiap entri data pada garis akan ditandai. Jika Anda mengeklik dua kali, menu " Format Data Point " akan ditampilkan di sisi kanan grafik. [1]
  6. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/1\/11\/Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-6-Version-3.jpg\/v4-460px-Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-6-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/1\/11\/Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-6-Version-3.jpg\/v4-728px-Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-6-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Ikon ini merupakan ikon opsi " Series Options ". Anda bisa melihatnya di bagian atas menu “ Format Data Point ”, di sisi kanan.
  7. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/5\/55\/Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-7-Version-2.jpg\/v4-460px-Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-7-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/5\/55\/Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-7-Version-2.jpg\/v4-728px-Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-7-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Tombol ini berada di bawah " Series Options " pada menu “ Format Data Point ”. Garis pada sumbu kedua dengan nomor di sisi kanannya akan ditampilkan.
    Iklan
Bagian 2
Bagian 2 dari 2:

Mengubah Jenis Grafik Sumbu Kedua

Unduh PDF
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/4\/40\/Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-8-Version-3.jpg\/v4-460px-Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-8-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/40\/Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-8-Version-3.jpg\/v4-728px-Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-8-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Grafik biasanya ditampilkan di tengah lembar lajur Excel. Menu baru akan ditampilkan di samping garis grafik.
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/e\/e2\/Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-9.jpg\/v4-460px-Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-9.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/e2\/Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-9.jpg\/v4-728px-Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-9.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Jendela penyuntingan grafik akan ditampilkan setelahnya.
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/a\/aa\/Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-10.jpg\/v4-460px-Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-10.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/aa\/Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-10.jpg\/v4-728px-Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-10.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Untuk menambahkan garis lain ke sumbu Y, klik kotak centang di bawah " Y-axis ", di sisi kanan seri atau rangkaian data di pojok kanan bawah jendela.
  4. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/7\/7c\/Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-11.jpg\/v4-460px-Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-11.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/7\/7c\/Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-11.jpg\/v4-728px-Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-11.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Selain membuat grafik dari rangkaian data terpilih untuk sumbu Y terpisah, Anda juga bisa mempresentasikan data dengan jenis grafik lain. Gunakan menu drop-down untuk memilih jenis grafik untuk setiap rangkaian atau seri data di pojok kanan bawah jendela.
  5. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/0\/09\/Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-12.jpg\/v4-460px-Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-12.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/0\/09\/Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-12.jpg\/v4-728px-Add-a-Second-Y-Axis-to-a-Graph-in-Microsoft-Excel-Step-12.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Perubahan yang dibuat pada grafik akan disimpan.
    • Jika Anda ingin mengubah jenis grafik untuk grafik secara keseluruhan, klik jenis grafik pada menu di sisi kiri jendela dan klik dua kali gaya grafik yang diinginkan pada jendela.
    Iklan

wikiHow Terkait

Cara
Menambah Tanda Centang ke Dokumen Word
Cara
Membuka Proteksi Lembar Kerja Excel
Cara
Membuat Teks Rata Tengah di Microsoft Word
Cara
Menghapus Halaman Kosong di Word
Cara
Mengubah Koma Menjadi Titik pada Microsoft Excel
Cara
Menampilkan Baris Tersembunyi di Excel
Cara
Menyisipkan Gambar di Excel yang Bisa Menyesuaikan Ukuran Sel secara Otomatis
Cara
Mengubah Huruf Kecil Menjadi Huruf Besar di Excel
Cara
Mengubah Dokumen Hasil Scan Ke File Microsoft Word
Cara
Menampilkan Kembali Kolom Tersembunyi di Excel
Cara
Menambahkan Nomor Halaman di Microsoft Word
Cara
Menghilangkan Status 'Read Only' pada Dokumen MS Word
Cara
Membuat Simbol X Garis Atas di Microsoft Word
Cara Mudah Membuat Tanda Panah di Word pada Komputer Windows atau Mac
Iklan

Referensi

  1. ↑ https://www.youtube.com/watch?v=JXbruxNmFhg

Tentang wikiHow ini

Bahasa lain
Halaman ini telah diakses sebanyak 44.778 kali.

Apakah artikel ini membantu Anda?

Iklan