Terkadang untuk data tertentu kita perlu mengeplotkan data tersebut ke dalam skala logaritmik. Berikut adalah cara membuat grafik dengan skala log:
1. Plot data dalam XY seperti biasa, misalnya didapatkan grafik seperti gambar di bawah:
2. Klik kanan pada sumbu yang diinginkan untuk dibuat skala log, misalnya pada sumbu X, klik kanan, kemudian pilih “format axis” Continue reading
okey, we know that excel has a lot of helpful function which will beautifully make our tasks much easier (or better to say more efficient). One of those is the “vlookup” function.
#well, actually, i’m being asked about “vlookup” function, and i think it’s better to put it here.
Then, how we use it?
When you have series of data (array) or table and for certain purpose you want to “re-call” a data to another table, for example (see figure above), you want to know the data from number “5” (red arrow) and it’s paired (blue box), you only need to type “5″, and the related data will showed up. ^_^
The formula for vlookup is: ” =VLOOKUP($A18,$A$3:$F$15,D3,FALSE)” Continue reading
