txheem
Tus thawj tswj hwm tsis tshua muaj nyob hauv nws qhov kev coj ua tsis tau ntsib nrog kev xav pom cov txiaj ntsig tau ua tiav hauv kev sib piv nrog cov phiaj xwm qub. Hauv cov tuam txhab sib txawv, kuv tau pom ntau daim duab zoo sib xws hu ua "Plan-Fact", "Qhov Tseeb vs Nyiaj", thiab lwm yam. Qee zaum lawv tau tsim zoo li no:
Qhov tsis yooj yim ntawm daim duab zoo li no yog tias tus neeg saib yuav tsum sib piv cov phiaj xwm thiab cov kab lus tseeb hauv cov khub, sim khaws tag nrho cov duab hauv nws lub taub hau, thiab cov histogram ntawm no, hauv kuv lub tswv yim, tsis yog qhov kev xaiv zoo tshaj plaws. Yog tias peb yuav tsim qhov kev pom zoo li no, ces nws yog qhov pom tseeb ntau dua los siv cov duab kos rau txoj kev npaj thiab qhov tseeb. Tab sis tom qab ntawd peb tau ntsib nrog txoj haujlwm ntawm qhov pom kev sib piv ntawm cov ntsiab lus rau tib lub sijhawm thiab qhia qhov txawv ntawm lawv. Cia peb sim qee cov tswv yim zoo rau qhov no.
Txoj Kev 1. Up-down bands
Cov no yog cov duab plaub sib txuas ua ke hauv cov ntsiab lus ntawm txoj kev npaj thiab cov duab kos duab ntawm peb daim duab. Ntxiv mus, lawv cov xim nyob ntawm seb peb ua tiav txoj kev npaj los yog tsis, thiab qhov loj qhia tau hais tias ntau npaum li cas:
Xws li bands muaj nyob rau ntawm lub tab Constructor – Ntxiv Daim Ntawv Qhia – Up/down Bands (Tsim - Ntxiv Daim Ntawv Qhia - Up / Down Bars) hauv Excel 2013 lossis ntawm tab Layout – Advance-Decrement Bars (Layout - Up-down Bars) hauv Excel 2007-2010. Los ntawm lub neej ntawd lawv yuav dub thiab dawb, tab sis koj tuaj yeem hloov lawv cov xim yooj yim los ntawm txoj cai-nias ntawm lawv thiab xaiv cov lus txib Up/down Bands Format (Format Up / Down Bars). Kuv pom zoo kom siv translucent sau, vim. cov kab khoom kaw qhov qub graphs lawv tus kheej.
Hmoov tsis, tsis muaj ib txoj hauv kev yooj yim los kho qhov dav ntawm kab txaij - rau qhov no koj yuav tau siv me ntsis ua kom yuam kev.
- Teeb lub teeb duab ua
- Nias lub keyboard shortcut Alt + F11mus rau hauv Visual Basic Editor
- Xovxwm keyboard shortcut Ctrl + Gqhib cov lus txib ncaj qha nkag thiab debug vaj huam sib luag tam sim ntawd
- Luam thiab paste cov lus txib hauv qab no rau hauv: ActiveChart.ChartGroups(1).GapWidth = 30 thiab nias Sau:
Tau kawg, parameter (30) tuaj yeem ua si ib puag ncig kom tau qhov dav koj xav tau sim.
Txoj Kev 2. Daim ntawv qhia nrog cheeb tsam sau nruab nrab ntawm cov phiaj xwm thiab kab qhov tseeb
Txoj kev no suav nrog kev pom pom (nws tuaj yeem ua tau nrog hatching, piv txwv li) ntawm thaj chaw nruab nrab ntawm cov phiaj xwm thiab cov duab qhov tseeb:
Heev impressive, puas yog? Cia peb sim ua qhov no.
Ua ntej, ntxiv lwm kem rau peb lub rooj (cia peb hu nws, peb hais, qhov sib txawv), uas peb xam qhov sib txawv ntawm qhov tseeb thiab txoj kev npaj raws li ib tug qauv:
Tam sim no cia peb xaiv cov kab nrog hnub, npaj thiab sib txawv tib lub sijhawm (tuav Ctrl) thiab tsim ib daim duab nrog cov cheeb tsam nrog tsub zuj zujsiv tab Insert (Ntxig):
Cov zis yuav tsum saib tej yam zoo li no:
Cov kauj ruam tom ntej yog xaiv cov kab Plan и fact, copy lawv (Ctrl + C) thiab ntxiv rau peb daim duab los ntawm kev ntxig (Ctrl + V) - hauv peb "sandwich hauv seem" ob "txheej txheem" tshiab yuav tsum tshwm rau saum:
Tam sim no cia peb hloov cov kab kos rau ob txheej ntxiv no rau ib daim duab. Txhawm rau ua qhov no, xaiv txhua kab hauv lem, right-click rau nws thiab xaiv cov lus txib Hloov hom kab kos rau ib series (Hloov Series Chart Type). Hauv cov ntawv qub ntawm Excel 2007-2010, koj tuaj yeem xaiv hom kab ntawv xav tau (Daim duab nrog cov cim), thiab hauv Excel 2013 tshiab lub thawv yuav tshwm sim nrog txhua kab, qhov twg hom xav tau raug xaiv rau txhua kab los ntawm cov npe poob:
Tom qab txhaj rau OK peb yuav pom ib daim duab twb zoo ib yam li peb xav tau:
Nws yog ib qho yooj yim los txiav txim siab tias nws tseem tsuas yog xaiv thaj chaw xiav thiab hloov nws cov xim puv rau pob tshab Tsis muaj puv (Tsis muaj sau). Zoo, thiab coj ci ntsa iab: ntxiv cov ntawv sau npe, tshem tawm cov ntsiab lus tsis tsim nyog hauv cov lus dab neeg, thiab lwm yam.
Hauv kuv lub tswv yim, qhov no zoo dua li cov kab, tsis yog?
- Yuav ua li cas kom sai ntxiv cov ntaub ntawv tshiab rau hauv daim duab los ntawm kev theej
- Daim ntawv qhia zaub mov kom pom KPI
- Video nyeem txog kev tsim ib qhov project Gantt daim ntawv hauv Excel