Siv cov dashboards, koj tuaj yeem saib nrawm ntawm koj qhov project stats. Koj tuaj yeem pom yam koj xav tau txhawm rau txhim kho lossis kho kom pom kev zoo thiab tam sim, tsis tas yuav tsum zuag los ntawm cov ntaub ntawv thiab ua haujlwm nrog cov lej. Cov wikiHow no yuav qhia koj li cas los tsim lub dashboard hauv Excel los ntawm kos.
Cov kauj ruam
Kauj Ruam 1. Qhib Excel
Txoj kev no ua haujlwm rau ob qho Mac thiab Windows nrog ob lub desktop applications lossis web applications. Koj yuav pom qhov haujlwm no hauv koj li Start Menu lossis Applications folder. Koj tuaj yeem pom qhov online version ntawm
Kauj Ruam 2. Tsim kom muaj tsawg kawg ob daim ntawv ua haujlwm
Ib daim ntawv yog rau koj cov ntaub ntawv nyoos thiab ib qho yog rau lub dashboard. Ntxiv cov ntawv los ntawm txhaj rau lub cim ntxiv (+) ib sab ntawm daim ntawv ua haujlwm tam sim no nyob hauv qab ntawm koj lub vijtsam. Koj yuav tsum tau nqes me ntsis kom pom lub cim.
Koj tuaj yeem hloov npe cov ntawv ua haujlwm rau "Cov Ntaub Ntawv Nyuaj" thiab "Dashboard" kom yooj yim siv los ntawm txoj cai-txhaj rau Daim Ntawv Teev Npe tab thiab nyem "Hloov Npe."
Kauj Ruam 3. Ntshuam koj cov ntaub ntawv rau hauv koj cov ntaub ntawv raw
Koj tuaj yeem nkag mus rau cov ntaub ntawv hauv Excel daim ntawv tus kheej, lossis koj tuaj yeem siv qhov program los txuas cov ntaub ntawv. Piv txwv li, yog tias koj siv CommCare, cov kev pabcuam tswj hwm cov ntaub ntawv thib peb, koj tuaj yeem siv qhov ntawd los tsim kev sib txuas ntawm koj cov ntaub ntawv thiab ntawv Excel.
- Nco ntsoov muab koj cov ntaub ntawv tso rau hauv cov ntaub ntawv raw.
- Xyuas kom cov ntaub ntawv teeb tsa zoo li lub rooj, yog li tsuas yog ib txheej ntawm cov ntaub ntawv nyob hauv txhua lub xovtooj.
Kauj Ruam 4. Xaiv cov ntaub ntawv uas koj xav kom tshwm hauv kab ntawv
Qhov no tsis tas yuav tsum yog tag nrho cov dashboard uas koj tab tom tsim, tab sis ib daim ntawv qhia hauv dashboard. Txhawm rau xaiv cov ntaub ntawv ntau, koj yuav tsum rub-thiab-tso koj tus cursor los ntawm qhov pib ntawm cov ntaub ntawv ntau mus rau qhov kawg.
Piv txwv li, yog tias lub dashboard tau npaj los qhia tag nrho kev xaiv noj hmo, tab sis muaj ntau yam khoom noj uas yuav muaj, koj yuav xav xaiv cov ntaub ntawv ntawd los ntawm cov lauj kaub lauj kaub tais diav los qhia tias ze li cas kom tiav hauv daim duab, tsis yog zauv, daim ntawv
Kauj Ruam 5. Ntxiv kab ntawv sib tshooj-kab rau daim ntawv ua haujlwm dawb
Koj yuav xav nyem rau ntawm "Dashboard" daim ntawv ua haujlwm ua ntej nyem txhawm rau ntxig daim duab. Qhov no feem ntau yog qhov kev xaiv thib ob hauv kab ntawv kab cim hauv cov ntawv qhia zaub mov (hauv 2-D ntawv qhia zaub mov). Koj yuav pom ntu "Charts" hauv "Insert" tab hauv kab ntawv nyob rau sab saum toj ntawm koj qhov haujlwm Excel.
Koj yuav ua Gantt Chart los ntawm kab ntawv sib tshooj-kab los ntawm kev ua qauv
Kauj Ruam 6. Hloov daim duab kom pom
Thawj daim duab qhia yuav tsis zoo li koj xav tau, yog li muaj txoj hauv kev los hloov cov zaub ntawm cov ntaub ntawv ntau npaum li koj xav tau. Thov nco ntsoov tias txhua cov ntawv qhia zaub mov xaiv thiab cov nyees khawm yuav tshwm sim sib txawv rau cov haujlwm sib txawv thiab cov software tsim tawm.
- Txoj cai-nias thawj cov ntaub ntawv hauv kab ntawv thiab nyem "Xaiv Cov Ntaub Ntawv Series."
- Nyem rau "Format" tab thiab xaiv "Fill" thiab "No fill." Txhawm rau thim rov qab cov ntaub ntawv qhia, koj tuaj yeem nyem txoj cai thib ob ntawm cov ntaub ntawv hloov chaw.
- Koj tseem tuaj yeem hloov cov xim sau, kab xim, thiab sau cov ntawv ntawm cov ntaub ntawv hauv kab ntawv los ntawm lub qhov rai no. Nyem rau "X" nyob rau sab xis saum toj ntawm lub qhov rai pop-up kom kaw nws.
- Right-click hauv X-axis thiab nyem "Format Axis."
- Hauv qab "Axis txoj haujlwm" lub taub hau, nyem rau xaiv lub npov nyob ib sab ntawm "Pawg hauv kev thim rov qab."
- Koj tseem tuaj yeem hloov cov xim sau, kab xim, thiab sau cov ntawv ntawm cov ntaub ntawv hauv kab ntawv los ntawm lub qhov rai no. Nyem rau "X" nyob rau sab xis saum toj ntawm lub qhov rai pop-up kom kaw nws.
- Ntxiv daim ntawv teev npe los ntawm txhaj rau kab ntawv kab ntawv lub npe kab ntawv nyob rau sab saum toj ntawm kab ntawv. Yog tias daim ntawv teev npe tsis tuaj yeem tshwm tuaj, koj tuaj yeem ntxiv ib qho los ntawm "Ntxiv Chart Element" cov ntawv qhia hauv "Chart Design" tab hauv kab ntawv saum toj no koj qhov haujlwm Excel.
- Txuas ntxiv kev teeb tsa koj daim ntawv thiab ntxiv cov ntawv qhia raws li koj nyiam.
Kauj Ruam 7. Txuas ntxiv cov kab ntawv sib tshooj ntau dua nrog koj cov ntaub ntawv xaiv
Tsis txhob siv tib cov ntaub ntawv thaum tsim daim duab tshiab vim tias nws yuav zoo ib yam nkaus.
