Bls: [belajar-excel] Membuat grafik tiap hari
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]" 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] 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]"
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:#ff;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
#66;height:62px;overflow:hidden;width:62px;}#yiv2220013623
#yiv2220013623photos div label
{color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2220013623
#yiv2220013623reco-category {font-
Bls: [belajar-excel] Membuat grafik tiap hari [1 Attachment]
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]"
menulis:
Dear master excel, Bagaimana caranya membuat grafik yang terupdate setiap
hari dengan data terlampir
terima kasih
Tjahya
#yiv2251324979 #yiv2251324979 -- #yiv2251324979ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2251324979
#yiv2251324979ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2251324979
#yiv2251324979ygrp-mkp #yiv2251324979hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv2251324979 #yiv2251324979ygrp-mkp #yiv2251324979ads
{margin-bottom:10px;}#yiv2251324979 #yiv2251324979ygrp-mkp .yiv2251324979ad
{padding:0 0;}#yiv2251324979 #yiv2251324979ygrp-mkp .yiv2251324979ad p
{margin:0;}#yiv2251324979 #yiv2251324979ygrp-mkp .yiv2251324979ad a
{color:#ff;text-decoration:none;}#yiv2251324979 #yiv2251324979ygrp-sponsor
#yiv2251324979ygrp-lc {font-family:Arial;}#yiv2251324979
#yiv2251324979ygrp-sponsor #yiv2251324979ygrp-lc #yiv2251324979hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2251324979
#yiv2251324979ygrp-sponsor #yiv2251324979ygrp-lc .yiv2251324979ad
{margin-bottom:10px;padding:0 0;}#yiv2251324979 #yiv2251324979actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2251324979
#yiv2251324979activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2251324979
#yiv2251324979activity span {font-weight:700;}#yiv2251324979
#yiv2251324979activity span:first-child
{text-transform:uppercase;}#yiv2251324979 #yiv2251324979activity span a
{color:#5085b6;text-decoration:none;}#yiv2251324979 #yiv2251324979activity span
span {color:#ff7900;}#yiv2251324979 #yiv2251324979activity span
.yiv2251324979underline {text-decoration:underline;}#yiv2251324979
.yiv2251324979attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv2251324979 .yiv2251324979attach div a
{text-decoration:none;}#yiv2251324979 .yiv2251324979attach img
{border:none;padding-right:5px;}#yiv2251324979 .yiv2251324979attach label
{display:block;margin-bottom:5px;}#yiv2251324979 .yiv2251324979attach label a
{text-decoration:none;}#yiv2251324979 blockquote {margin:0 0 0
4px;}#yiv2251324979 .yiv2251324979bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv2251324979
.yiv2251324979bold a {text-decoration:none;}#yiv2251324979 dd.yiv2251324979last
p a {font-family:Verdana;font-weight:700;}#yiv2251324979 dd.yiv2251324979last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2251324979
dd.yiv2251324979last p span.yiv2251324979yshortcuts
{margin-right:0;}#yiv2251324979 div.yiv2251324979attach-table div div a
{text-decoration:none;}#yiv2251324979 div.yiv2251324979attach-table
{width:400px;}#yiv2251324979 div.yiv2251324979file-title a, #yiv2251324979
div.yiv2251324979file-title a:active, #yiv2251324979
div.yiv2251324979file-title a:hover, #yiv2251324979 div.yiv2251324979file-title
a:visited {text-decoration:none;}#yiv2251324979 div.yiv2251324979photo-title a,
#yiv2251324979 div.yiv2251324979photo-title a:active, #yiv2251324979
div.yiv2251324979photo-title a:hover, #yiv2251324979
div.yiv2251324979photo-title a:visited {text-decoration:none;}#yiv2251324979
div#yiv2251324979ygrp-mlmsg #yiv2251324979ygrp-msg p a
span.yiv2251324979yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2251324979
.yiv2251324979green {color:#628c2a;}#yiv2251324979 .yiv2251324979MsoNormal
{margin:0 0 0 0;}#yiv2251324979 o {font-size:0;}#yiv2251324979
#yiv2251324979photos div {float:left;width:72px;}#yiv2251324979
#yiv2251324979photos div div {border:1px solid
#66;height:62px;overflow:hidden;width:62px;}#yiv2251324979
#yiv2251324979photos div label
{color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2251324979
#yiv2251324979reco-category {font-size:77%;}#yiv2251324979
#yiv2251324979reco-desc {font-size:77%;}#yiv2251324979 .yiv2251324979replbq
{margin:4px;}#yiv2251324979 #yiv2251324979ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv2251324979 #yiv2251324979ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2251324979
#yiv2251324979ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2251324979
#yiv2251324979ygrp-mlmsg select, #yiv2251324979 input, #yiv2251324979 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv2251324979
#yiv2251324979ygrp-mlmsg pre, #yiv2251324979 code {font:115%
monospace;}#yiv2251324979 #yiv2251324979ygrp-mlmsg *
{line-height:1.22em;}#yiv2251324979 #yiv2251324979ygrp-mlmsg #yiv2251324979logo
{padding-bottom:10px;}#yiv2251324979 #yiv2251324979ygrp-msg p a
{font-family:Verdana;}#yiv2251324979 #yiv22513249
