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