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 [email protected]
[belajar-excel]" <[email protected]> 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 [email protected]
[belajar-excel]" <[email protected]> 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 [email protected]
[belajar-excel]" <[email protected]> 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