Bls: [belajar-excel] Klasifikasi Kuadran Dealer berdasarkan Penjualan dan Share [1 Attachment]

2016-11-30 Terurut Topik Toby kenzo tobyke...@yahoo.co.id [belajar-excel] 
Dear Herry,
Saya coba buat dengan menggunakan Scatter chart untuk Mappingnya.Semoga bisa 
membantu.
TerimaKasih. 

Pada Rabu, 30 November 2016 16:24, "Toby kenzo tobyke...@yahoo.co.id 
[belajar-excel]"  menulis:
 

     Dear Harry,
Penggunaan grafik Kuadran biasanya di gunakan untuk analisa SWOT, tapi untuk 
kasus anda, anda bisa gunakan Scatter.
TerimaKasih 

Pada Rabu, 30 November 2016 4:40, "harry budiman sendtohar...@gmail.com 
[belajar-excel]"  menulis:
 

     Selamat Sore

Mohon pencerahannya mengenai Grafik ataupun Kuadran yang dapat berubah
ketika kita memasukan criteria tertentu

Untuk kasus terlampir

Terima kasih atas bantuannya

Salam    Sent from Mail for Windows 10    

 #yiv3728487415 #yiv3728487415 -- #yiv3728487415ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3728487415 
#yiv3728487415ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3728487415 
#yiv3728487415ygrp-mkp #yiv3728487415hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv3728487415 #yiv3728487415ygrp-mkp #yiv3728487415ads 
{margin-bottom:10px;}#yiv3728487415 #yiv3728487415ygrp-mkp .yiv3728487415ad 
{padding:0 0;}#yiv3728487415 #yiv3728487415ygrp-mkp .yiv3728487415ad p 
{margin:0;}#yiv3728487415 #yiv3728487415ygrp-mkp .yiv3728487415ad a 
{color:#ff;text-decoration:none;}#yiv3728487415 #yiv3728487415ygrp-sponsor 
#yiv3728487415ygrp-lc {font-family:Arial;}#yiv3728487415 
#yiv3728487415ygrp-sponsor #yiv3728487415ygrp-lc #yiv3728487415hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3728487415 
#yiv3728487415ygrp-sponsor #yiv3728487415ygrp-lc .yiv3728487415ad 
{margin-bottom:10px;padding:0 0;}#yiv3728487415 #yiv3728487415actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3728487415 
#yiv3728487415activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3728487415
 #yiv3728487415activity span {font-weight:700;}#yiv3728487415 
#yiv3728487415activity span:first-child 
{text-transform:uppercase;}#yiv3728487415 #yiv3728487415activity span a 
{color:#5085b6;text-decoration:none;}#yiv3728487415 #yiv3728487415activity span 
span {color:#ff7900;}#yiv3728487415 #yiv3728487415activity span 
.yiv3728487415underline {text-decoration:underline;}#yiv3728487415 
.yiv3728487415attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv3728487415 .yiv3728487415attach div a 
{text-decoration:none;}#yiv3728487415 .yiv3728487415attach img 
{border:none;padding-right:5px;}#yiv3728487415 .yiv3728487415attach label 
{display:block;margin-bottom:5px;}#yiv3728487415 .yiv3728487415attach label a 
{text-decoration:none;}#yiv3728487415 blockquote {margin:0 0 0 
4px;}#yiv3728487415 .yiv3728487415bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv3728487415 
.yiv3728487415bold a {text-decoration:none;}#yiv3728487415 dd.yiv3728487415last 
p a {font-family:Verdana;font-weight:700;}#yiv3728487415 dd.yiv3728487415last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3728487415 
dd.yiv3728487415last p span.yiv3728487415yshortcuts 
{margin-right:0;}#yiv3728487415 div.yiv3728487415attach-table div div a 
{text-decoration:none;}#yiv3728487415 div.yiv3728487415attach-table 
{width:400px;}#yiv3728487415 div.yiv3728487415file-title a, #yiv3728487415 
div.yiv3728487415file-title a:active, #yiv3728487415 
div.yiv3728487415file-title a:hover, #yiv3728487415 div.yiv3728487415file-title 
a:visited {text-decoration:none;}#yiv3728487415 div.yiv3728487415photo-title a, 
#yiv3728487415 div.yiv3728487415photo-title a:active, #yiv3728487415 
div.yiv3728487415photo-title a:hover, #yiv3728487415 
div.yiv3728487415photo-title a:visited {text-decoration:none;}#yiv3728487415 
div#yiv3728487415ygrp-mlmsg #yiv3728487415ygrp-msg p a 
span.yiv3728487415yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3728487415 
.yiv3728487415green {color:#628c2a;}#yiv3728487415 .yiv3728487415MsoNormal 
{margin:0 0 0 0;}#yiv3728487415 o {font-size:0;}#yiv3728487415 
#yiv3728487415photos div {float:left;width:72px;}#yiv3728487415 
#yiv3728487415photos div div {border:1px solid 
#66;height:62px;overflow:hidden;width:62px;}#yiv3728487415 
#yiv3728487415photos div label 
{color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3728487415
 #yiv3728487415reco-category {font-size:77%;}#yiv3728487415 
#yiv3728487415reco-desc {font-size:77%;}#yiv3728487415 .yiv3728487415replbq 
{margin:4px;}#yiv3728487415 #yiv3728487415ygrp-actbar div a:first-child 
{margin-right:2px;padding-right:5px;}#yiv3728487415 #yiv3728487415ygrp-mlmsg 
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3728487415 
#yiv3728487415ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3728487415 
#yiv3728487415ygrp-mlmsg select, #yiv3728487415 input, #yiv3728487415

Bls: [belajar-excel] Klasifikasi Kuadran Dealer berdasarkan Penjualan dan Share

2016-11-30 Terurut Topik Toby kenzo tobyke...@yahoo.co.id [belajar-excel] 
Dear Harry,
Penggunaan grafik Kuadran biasanya di gunakan untuk analisa SWOT, tapi untuk 
kasus anda, anda bisa gunakan Scatter.
TerimaKasih 

Pada Rabu, 30 November 2016 4:40, "harry budiman sendtohar...@gmail.com 
[belajar-excel]"  menulis:
 

     Selamat Sore

Mohon pencerahannya mengenai Grafik ataupun Kuadran yang dapat berubah
ketika kita memasukan criteria tertentu

Untuk kasus terlampir

Terima kasih atas bantuannya

Salam    Sent from Mail for Windows 10    #yiv8887182556 #yiv8887182556 -- 
#yiv8887182556ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 
0;padding:0 10px;}#yiv8887182556 #yiv8887182556ygrp-mkp hr {border:1px solid 
#d8d8d8;}#yiv8887182556 #yiv8887182556ygrp-mkp #yiv8887182556hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv8887182556 #yiv8887182556ygrp-mkp #yiv8887182556ads 
{margin-bottom:10px;}#yiv8887182556 #yiv8887182556ygrp-mkp .yiv8887182556ad 
{padding:0 0;}#yiv8887182556 #yiv8887182556ygrp-mkp .yiv8887182556ad p 
{margin:0;}#yiv8887182556 #yiv8887182556ygrp-mkp .yiv8887182556ad a 
{color:#ff;text-decoration:none;}#yiv8887182556 #yiv8887182556ygrp-sponsor 
#yiv8887182556ygrp-lc {font-family:Arial;}#yiv8887182556 
#yiv8887182556ygrp-sponsor #yiv8887182556ygrp-lc #yiv8887182556hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8887182556 
#yiv8887182556ygrp-sponsor #yiv8887182556ygrp-lc .yiv8887182556ad 
{margin-bottom:10px;padding:0 0;}#yiv8887182556 #yiv8887182556actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8887182556 
#yiv8887182556activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8887182556
 #yiv8887182556activity span {font-weight:700;}#yiv8887182556 
#yiv8887182556activity span:first-child 
{text-transform:uppercase;}#yiv8887182556 #yiv8887182556activity span a 
{color:#5085b6;text-decoration:none;}#yiv8887182556 #yiv8887182556activity span 
span {color:#ff7900;}#yiv8887182556 #yiv8887182556activity span 
.yiv8887182556underline {text-decoration:underline;}#yiv8887182556 
.yiv8887182556attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv8887182556 .yiv8887182556attach div a 
{text-decoration:none;}#yiv8887182556 .yiv8887182556attach img 
{border:none;padding-right:5px;}#yiv8887182556 .yiv8887182556attach label 
{display:block;margin-bottom:5px;}#yiv8887182556 .yiv8887182556attach label a 
{text-decoration:none;}#yiv8887182556 blockquote {margin:0 0 0 
4px;}#yiv8887182556 .yiv8887182556bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv8887182556 
.yiv8887182556bold a {text-decoration:none;}#yiv8887182556 dd.yiv8887182556last 
p a {font-family:Verdana;font-weight:700;}#yiv8887182556 dd.yiv8887182556last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8887182556 
dd.yiv8887182556last p span.yiv8887182556yshortcuts 
{margin-right:0;}#yiv8887182556 div.yiv8887182556attach-table div div a 
{text-decoration:none;}#yiv8887182556 div.yiv8887182556attach-table 
{width:400px;}#yiv8887182556 div.yiv8887182556file-title a, #yiv8887182556 
div.yiv8887182556file-title a:active, #yiv8887182556 
div.yiv8887182556file-title a:hover, #yiv8887182556 div.yiv8887182556file-title 
a:visited {text-decoration:none;}#yiv8887182556 div.yiv8887182556photo-title a, 
#yiv8887182556 div.yiv8887182556photo-title a:active, #yiv8887182556 
div.yiv8887182556photo-title a:hover, #yiv8887182556 
div.yiv8887182556photo-title a:visited {text-decoration:none;}#yiv8887182556 
div#yiv8887182556ygrp-mlmsg #yiv8887182556ygrp-msg p a 
span.yiv8887182556yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8887182556 
.yiv8887182556green {color:#628c2a;}#yiv8887182556 .yiv8887182556MsoNormal 
{margin:0 0 0 0;}#yiv8887182556 o {font-size:0;}#yiv8887182556 
#yiv8887182556photos div {float:left;width:72px;}#yiv8887182556 
#yiv8887182556photos div div {border:1px solid 
#66;height:62px;overflow:hidden;width:62px;}#yiv8887182556 
#yiv8887182556photos div label 
{color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8887182556
 #yiv8887182556reco-category {font-size:77%;}#yiv8887182556 
#yiv8887182556reco-desc {font-size:77%;}#yiv8887182556 .yiv8887182556replbq 
{margin:4px;}#yiv8887182556 #yiv8887182556ygrp-actbar div a:first-child 
{margin-right:2px;padding-right:5px;}#yiv8887182556 #yiv8887182556ygrp-mlmsg 
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8887182556 
#yiv8887182556ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8887182556 
#yiv8887182556ygrp-mlmsg select, #yiv8887182556 input, #yiv8887182556 textarea 
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv8887182556 
#yiv8887182556ygrp-mlmsg pre, #yiv8887182556 code {font:115% 
monospace;}#yiv8887182556 #yiv8887182556ygrp-mlmsg * 
{line-height:1.22em;}#yiv8887182556 #yiv8887182556ygrp-mlmsg #yiv8887182556logo

[belajar-excel] Klasifikasi Kuadran Dealer berdasarkan Penjualan dan Share

2016-11-29 Terurut Topik harry budiman sendtohar...@gmail.com [belajar-excel] 
Selamat Sore


Mohon pencerahannya mengenai Grafik ataupun Kuadran yang dapat berubah
ketika kita memasukan criteria tertentu


Untuk kasus terlampir


Terima kasih atas bantuannya


Salam




Sent from Mail for Windows 10




Pertanyaan Grafik Klasfikasi Dealer.xlsx
Description: MS-Excel 2007 spreadsheet