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' [email protected]
[belajar-excel]" <[email protected]> menulis:
Hai Tjahya,
File terlampir dengan 2 cara.
Wassalam,
Kid
On Sat, Sep 5, 2015 at 5:40 AM, Tjahya Hartono [email protected]
[belajar-excel] <[email protected]> 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
[email protected] [belajar-excel]" <[email protected]>
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
