Panduan Membuat Grafik Microsoft Excel. Pada contoh cara pembuatan grafik ini kami menggunakan Microsoft excel versi 2003, untuk grafik versi 2007 silahkan klik di sini. Langkah yang paling awal tentunya adalah membuka program Microsoft excel, klik start, all program, Microsoft office, Microsoft excel. (gambar 1) 2.
search boxinExcel. lf you are in a rush, simply down load the Excel document.
This is definitely what the spreadsheet looks like. If you get into a search predicament into mobile M2, Excel queries through column E and the outcomes show up in column B.
To create this search package, execute the subsequent steps.
1. Choose cell G4 and insert the Lookup function shown below. Create an overall reference point to mobile B2.
2. Increase click on the right corner of mobile D4 to quickly copy the functionality to the other tissues.
Description: the SEARCH function finds the position of á substring in á string. The Lookup function is certainly case-insensitive. For Tunisia, chain 'uni' is certainly discovered at placement 2. For United Areas, chain 'uni' is usually found at position 1. The lower the amount, the increased it should become ranked.
3. Both United State governments and United Kingdom come back the value 1. To come back unique values, which will help us when we use the RANK functionality in a instant, slightly adapt the formula in mobile G4 as proven below.
4. Once again, double click the correct part of mobile G4 to quickly duplicate the method to the various other tissue.
Description: the ROW function comes back the line number of a mobile. If we separate the line number by a large amount and add it to the result of the Research function, we usually have unique values. Nevertheless, these small increments earned't influence the search ratings. United Says provides a worth of 1.00006 today and United Kingdom provides a worth of 1.00009. We furthermore added the IFERROR functionality. If a mobile consists of an error (when a thread cannot be found), an bare thread (') is shown.
5. Choose cell G4 and insert the Position function shown below.
6. Increase click on the correct corner of cell C4 to rapidly copy the formulation to the additional cells.
Explanation: the Standing function results the position of a quantity in a list of numbers. If the third argument is certainly 1, Excel ranks the smallest amount first, second smallest number 2nd, etc. Because we added the ROW functionality, all values in column D are usually special. As a outcome, the ranks in line C are unique as well (no ties).
7. We are usually almost right now there. We'll make use of the VLOOKUP functionality to come back the nations discovered (most affordable rank very first, second most affordable rank 2nd, etc.) Select cell C4 and put in the VLOOKUP function shown below.
8. Two times click on the right corner of cell T4 to rapidly copy the method to the various other tissues.
9. Change the text colour of the numbers in line A to whitened and hide columns C and M.