By Deddy Kusaryono
Combine TWO chart become ONE chart in EXCEL 2007
Banyak teman yg nanyain How To Combine 2 chart in 1 chart, ok…kita bahas step by step.
Misal bila ada data spt berikut :
Sales | Provit | Target | ||
12000 | 15% | 20% | ||
7500 | 10% | 20% | ||
5000 | 25% | 20% | ||
12500 | 25% | 20% | ||
19000 | 30% | 20% | ||
15900 | 34% | 20% | ||
24000 | 40% | 20% | ||
29000 | 28% | 20% | ||
18000 | 30% | 20% | ||
20100 | 45% | 20% | ||
14000 | 25% | 20% | ||
13000 | 20% | 20% |
Pengen kita jadikan seperti chart dibawah kaaaan?Hayooo…gmana caranya
Step 1
Bismillahirrahmanirrahim
Step 2
Buat semua data menjadi line chart dulu, akan jadi spt ini :
Step 3
Click line yang akan dijadikan column chart misal chart Sales, click kanan dan pilih Change Series Chart Type pilih column chart, maka akan jadi spt :
Step 4
Pilih Provit series n click kanan pilih Format Data Point, pilih Series Option, pilih Secondary Axis
Akan jadi spt :
Step 5
Lakukan juga untuk Line Chart Target, maka Chart akan menjadi :
Step 6
Alhamdulillah
The End
Salam,
Deddy Kusaryono
http://www.derins.web.id
http://www.centrobiz.web.id
http://theliqo.blogspot.com
http://deddykusaryono.blogspot.com
The information contained in this email is confidential and may be legally privileged. Views or opinions expressed in this email are those of the author only.
- This email has been scanned by McAfee Email Gateway -
Tidak ada komentar:
Posting Komentar