hehe...sepertinya saya itu odong deh bukan otong...hahaha.... oo...ya sudah klo mang datanya di pakai untuk beberapa chart kenapa tidak buat pivot chart saja...pivot chart bisa di buat beberapat chart dengan satu nilai sumber ( data source ). br,
odong nando Pada Rabu, 30 Desember 2015 14:01, "Zerlinda Seismica seism...@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis: MakasihMas Otong atas saranya...kebetulan sekali datanya itu dipake beberap chart jadi ada susah kalo di filter...krn between antara chart yg berbeda. SalamSeismica Pada Rabu, 30 Desember 2015 12:07, "odong nando odongna...@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis: yoo Seismica, sepertinya tinggal di kasih filter saja bagian tanggalnya blok semua data termasuk header-> klik ribon data-> klik filter... setelah itu klik filter pada header tanggal -> klik date filter-> pilih between, isi tanggal awal dan ahir yang anda inginkan. br, odong nando Pada Rabu, 30 Desember 2015 10:38, "Zerlinda Seismica seism...@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis: Assalamualaikum wrwb Hmmm.....sebelumnyasaya coba gugling untuk case yang saya temui, soalnya kelihatan sederhana tapibelum ketemu juga.Untukkesekian kalinya mohon masukannya....Adakahtipsnya range axis X dan Y ditentukan lewat cell yang sudah kita tentukan.Contohnyajika pada cell tgl awal (N2)=1 jan 15 dan tgl akhir (N3)=17 jan 15 makamaka data yang diseleksinya mengikuti tgl awal dan tgl akhir.seperti contoh di atas..Mohonmasukannya..MaturSuwunSalam Seismica #yiv7805862003 #yiv7805862003 -- #yiv7805862003ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7805862003 #yiv7805862003ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7805862003 #yiv7805862003ygrp-mkp #yiv7805862003hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv7805862003 #yiv7805862003ygrp-mkp #yiv7805862003ads {margin-bottom:10px;}#yiv7805862003 #yiv7805862003ygrp-mkp .yiv7805862003ad {padding:0 0;}#yiv7805862003 #yiv7805862003ygrp-mkp .yiv7805862003ad p {margin:0;}#yiv7805862003 #yiv7805862003ygrp-mkp .yiv7805862003ad a {color:#0000ff;text-decoration:none;}#yiv7805862003 #yiv7805862003ygrp-sponsor #yiv7805862003ygrp-lc {font-family:Arial;}#yiv7805862003 #yiv7805862003ygrp-sponsor #yiv7805862003ygrp-lc #yiv7805862003hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7805862003 #yiv7805862003ygrp-sponsor #yiv7805862003ygrp-lc .yiv7805862003ad {margin-bottom:10px;padding:0 0;}#yiv7805862003 #yiv7805862003actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7805862003 #yiv7805862003activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7805862003 #yiv7805862003activity span {font-weight:700;}#yiv7805862003 #yiv7805862003activity span:first-child {text-transform:uppercase;}#yiv7805862003 #yiv7805862003activity span a {color:#5085b6;text-decoration:none;}#yiv7805862003 #yiv7805862003activity span span {color:#ff7900;}#yiv7805862003 #yiv7805862003activity span .yiv7805862003underline {text-decoration:underline;}#yiv7805862003 .yiv7805862003attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv7805862003 .yiv7805862003attach div a {text-decoration:none;}#yiv7805862003 .yiv7805862003attach img {border:none;padding-right:5px;}#yiv7805862003 .yiv7805862003attach label {display:block;margin-bottom:5px;}#yiv7805862003 .yiv7805862003attach label a {text-decoration:none;}#yiv7805862003 blockquote {margin:0 0 0 4px;}#yiv7805862003 .yiv7805862003bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv7805862003 .yiv7805862003bold a {text-decoration:none;}#yiv7805862003 dd.yiv7805862003last p a {font-family:Verdana;font-weight:700;}#yiv7805862003 dd.yiv7805862003last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7805862003 dd.yiv7805862003last p span.yiv7805862003yshortcuts {margin-right:0;}#yiv7805862003 div.yiv7805862003attach-table div div a {text-decoration:none;}#yiv7805862003 div.yiv7805862003attach-table {width:400px;}#yiv7805862003 div.yiv7805862003file-title a, #yiv7805862003 div.yiv7805862003file-title a:active, #yiv7805862003 div.yiv7805862003file-title a:hover, #yiv7805862003 div.yiv7805862003file-title a:visited {text-decoration:none;}#yiv7805862003 div.yiv7805862003photo-title a, #yiv7805862003 div.yiv7805862003photo-title a:active, #yiv7805862003 div.yiv7805862003photo-title a:hover, #yiv7805862003 div.yiv7805862003photo-title a:visited {text-decoration:none;}#yiv7805862003 div#yiv7805862003ygrp-mlmsg #yiv7805862003ygrp-msg p a span.yiv7805862003yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7805862003 .yiv7805862003green {color:#628c2a;}#yiv7805862003 .yiv7805862003MsoNormal {margin:0 0 0 0;}#yiv7805862003 o {font-size:0;}#yiv7805862003 #yiv7805862003photos div {float:left;width:72px;}#yiv7805862003 #yiv7805862003photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv7805862003 #yiv7805862003photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7805862003 #yiv7805862003reco-category {font-size:77%;}#yiv7805862003 #yiv7805862003reco-desc {font-size:77%;}#yiv7805862003 .yiv7805862003replbq {margin:4px;}#yiv7805862003 #yiv7805862003ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv7805862003 #yiv7805862003ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7805862003 #yiv7805862003ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7805862003 #yiv7805862003ygrp-mlmsg select, #yiv7805862003 input, #yiv7805862003 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv7805862003 #yiv7805862003ygrp-mlmsg pre, #yiv7805862003 code {font:115% monospace;}#yiv7805862003 #yiv7805862003ygrp-mlmsg * {line-height:1.22em;}#yiv7805862003 #yiv7805862003ygrp-mlmsg #yiv7805862003logo {padding-bottom:10px;}#yiv7805862003 #yiv7805862003ygrp-msg p a {font-family:Verdana;}#yiv7805862003 #yiv7805862003ygrp-msg p#yiv7805862003attach-count span {color:#1E66AE;font-weight:700;}#yiv7805862003 #yiv7805862003ygrp-reco #yiv7805862003reco-head {color:#ff7900;font-weight:700;}#yiv7805862003 #yiv7805862003ygrp-reco {margin-bottom:20px;padding:0px;}#yiv7805862003 #yiv7805862003ygrp-sponsor #yiv7805862003ov li a {font-size:130%;text-decoration:none;}#yiv7805862003 #yiv7805862003ygrp-sponsor #yiv7805862003ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv7805862003 #yiv7805862003ygrp-sponsor #yiv7805862003ov ul {margin:0;padding:0 0 0 8px;}#yiv7805862003 #yiv7805862003ygrp-text {font-family:Georgia;}#yiv7805862003 #yiv7805862003ygrp-text p {margin:0 0 1em 0;}#yiv7805862003 #yiv7805862003ygrp-text tt {font-size:120%;}#yiv7805862003 #yiv7805862003ygrp-vital ul li:last-child {border-right:none !important;}#yiv7805862003