Mohon maaf mr kid memungkinkah bila saya menggunakan cara sheet "1" (karna 
sumber datanya tidak berubah seperti dalam pivot /sheet "2")  tetapi untuk 
garis horizontalnya bukan nama murid tetapi berdasarkan tanggal sehingga bila 
tanggalnya bertambah secara otomatis grafiknya juga bertambah/bergerak, dan 
karna muridnya banyak mungkinkah bila untuk mensort/ memilih murid tertentu 
dari sekian banyak murid. (jadi data memakai sheet "1" tetapi memakai cara 
sheet "2", (bila tanpa pivot) kurang lebih seperti itu)sebelumnya terima kasih 
untuk tanggapannya.


Tjahya Hartono




     Pada Sabtu, 5 September 2015 6:44, "'Mr. Kid' mr.nm...@gmail.com 
[belajar-excel]" <belajar-excel@yahoogroups.com> menulis:



     Hai Tjahya,


File terlampir dengan 2 cara.


Wassalam,
Kid




On Sat, Sep 5, 2015 at 5:40 AM, Tjahya Hartono tjahyahart...@yahoo.co.id 
[belajar-excel] <belajar-excel@yahoogroups.com> wrote:


     Mohon maaf email sebelumnya salah kirim lampirannya. berikut lampiran yang 
sudah benar.mohon maklum adanya.


Terima kasih


Tjahya 





     Pada Jumat, 4 September 2015 14:45, "Tjahya Hartono 
tjahyahart...@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> 
menulis:



     Dear master excel, Bagaimana caranya membuat grafik yang terupdate setiap 
hari dengan data terlampir
terima kasih


Tjahya








  






  #yiv2220013623 #yiv2220013623 -- #yiv2220013623ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2220013623 
#yiv2220013623ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2220013623 
#yiv2220013623ygrp-mkp #yiv2220013623hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv2220013623 #yiv2220013623ygrp-mkp #yiv2220013623ads 
{margin-bottom:10px;}#yiv2220013623 #yiv2220013623ygrp-mkp .yiv2220013623ad 
{padding:0 0;}#yiv2220013623 #yiv2220013623ygrp-mkp .yiv2220013623ad p 
{margin:0;}#yiv2220013623 #yiv2220013623ygrp-mkp .yiv2220013623ad a 
{color:#0000ff;text-decoration:none;}#yiv2220013623 #yiv2220013623ygrp-sponsor 
#yiv2220013623ygrp-lc {font-family:Arial;}#yiv2220013623 
#yiv2220013623ygrp-sponsor #yiv2220013623ygrp-lc #yiv2220013623hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2220013623 
#yiv2220013623ygrp-sponsor #yiv2220013623ygrp-lc .yiv2220013623ad 
{margin-bottom:10px;padding:0 0;}#yiv2220013623 #yiv2220013623actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2220013623 
#yiv2220013623activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2220013623
 #yiv2220013623activity span {font-weight:700;}#yiv2220013623 
#yiv2220013623activity span:first-child 
{text-transform:uppercase;}#yiv2220013623 #yiv2220013623activity span a 
{color:#5085b6;text-decoration:none;}#yiv2220013623 #yiv2220013623activity span 
span {color:#ff7900;}#yiv2220013623 #yiv2220013623activity span 
.yiv2220013623underline {text-decoration:underline;}#yiv2220013623 
.yiv2220013623attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv2220013623 .yiv2220013623attach div a 
{text-decoration:none;}#yiv2220013623 .yiv2220013623attach img 
{border:none;padding-right:5px;}#yiv2220013623 .yiv2220013623attach label 
{display:block;margin-bottom:5px;}#yiv2220013623 .yiv2220013623attach label a 
{text-decoration:none;}#yiv2220013623 blockquote {margin:0 0 0 
4px;}#yiv2220013623 .yiv2220013623bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv2220013623 
.yiv2220013623bold a {text-decoration:none;}#yiv2220013623 dd.yiv2220013623last 
p a {font-family:Verdana;font-weight:700;}#yiv2220013623 dd.yiv2220013623last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2220013623 
dd.yiv2220013623last p span.yiv2220013623yshortcuts 
{margin-right:0;}#yiv2220013623 div.yiv2220013623attach-table div div a 
{text-decoration:none;}#yiv2220013623 div.yiv2220013623attach-table 
{width:400px;}#yiv2220013623 div.yiv2220013623file-title a, #yiv2220013623 
div.yiv2220013623file-title a:active, #yiv2220013623 
div.yiv2220013623file-title a:hover, #yiv2220013623 div.yiv2220013623file-title 
a:visited {text-decoration:none;}#yiv2220013623 div.yiv2220013623photo-title a, 
#yiv2220013623 div.yiv2220013623photo-title a:active, #yiv2220013623 
div.yiv2220013623photo-title a:hover, #yiv2220013623 
div.yiv2220013623photo-title a:visited {text-decoration:none;}#yiv2220013623 
div#yiv2220013623ygrp-mlmsg #yiv2220013623ygrp-msg p a 
span.yiv2220013623yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2220013623 
.yiv2220013623green {color:#628c2a;}#yiv2220013623 .yiv2220013623MsoNormal 
{margin:0 0 0 0;}#yiv2220013623 o {font-size:0;}#yiv2220013623 
#yiv2220013623photos div {float:left;width:72px;}#yiv2220013623 
#yiv2220013623photos div div {border:1px solid 
#666666;height:62px;overflow:hidden;width:62px;}#yiv2220013623 
#yiv2220013623photos div label 
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2220013623
 #yiv2220013623reco-category {font-size:77%;}#yiv2220013623 
#yiv2220013623reco-desc {font-size:77%;}#yiv2220013623 .yiv2220013623replbq 
{margin:4px;}#yiv2220013623 #yiv2220013623ygrp-actbar div a:first-child 
{margin-right:2px;padding-right:5px;}#yiv2220013623 #yiv2220013623ygrp-mlmsg 
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2220013623 
#yiv2220013623ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2220013623 
#yiv2220013623ygrp-mlmsg select, #yiv2220013623 input, #yiv2220013623 textarea 
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv2220013623 
#yiv2220013623ygrp-mlmsg pre, #yiv2220013623 code {font:115% 
monospace;}#yiv2220013623 #yiv2220013623ygrp-mlmsg * 
{line-height:1.22em;}#yiv2220013623 #yiv2220013623ygrp-mlmsg #yiv2220013623logo 
{padding-bottom:10px;}#yiv2220013623 #yiv2220013623ygrp-msg p a 
{font-family:Verdana;}#yiv2220013623 #yiv2220013623ygrp-msg 
p#yiv2220013623attach-count span {color:#1E66AE;font-weight:700;}#yiv2220013623 
#yiv2220013623ygrp-reco #yiv2220013623reco-head 
{color:#ff7900;font-weight:700;}#yiv2220013623 #yiv2220013623ygrp-reco 
{margin-bottom:20px;padding:0px;}#yiv2220013623 #yiv2220013623ygrp-sponsor 
#yiv2220013623ov li a {font-size:130%;text-decoration:none;}#yiv2220013623 
#yiv2220013623ygrp-sponsor #yiv2220013623ov li 
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv2220013623 
#yiv2220013623ygrp-sponsor #yiv2220013623ov ul {margin:0;padding:0 0 0 
8px;}#yiv2220013623 #yiv2220013623ygrp-text 
{font-family:Georgia;}#yiv2220013623 #yiv2220013623ygrp-text p {margin:0 0 1em 
0;}#yiv2220013623 #yiv2220013623ygrp-text tt {font-size:120%;}#yiv2220013623 
#yiv2220013623ygrp-vital ul li:last-child {border-right:none 
!important;}#yiv2220013623


  
  • [belajar-excel] M... Tjahya Hartono tjahyahart...@yahoo.co.id [belajar-excel]
    • Bls: [belaja... Tjahya Hartono tjahyahart...@yahoo.co.id [belajar-excel]
      • Re: [bel... 'Mr. Kid' mr.nm...@gmail.com [belajar-excel]
        • Bls:... Tjahya Hartono tjahyahart...@yahoo.co.id [belajar-excel]
          • ... 'Mr. Kid' mr.nm...@gmail.com [belajar-excel]

Kirim email ke