Tom qab sau, systematizing thiab ua cov ntaub ntawv, nws yog feem ntau tsim nyog los qhia lawv. Cov ntxhuav yog qhov zoo ntawm kev nthuav qhia cov ntaub ntawv kab los ntawm kab, tab sis daim ntawv tuaj yeem ua pa rau hauv nws. Ib daim duab tsim ib qho kev pom kev uas qhia tsis tau tsuas yog cov ntaub ntawv, tab sis kuj lawv txoj kev sib raug zoo thiab lub ntsiab lus.
Daim ntawv qhia ncuav qab zib yog cov qauv kev lag luam rau kev xa cov kev sib raug zoo ntawm cov khoom thiab tag nrho. Daim duab ncuav qab zib yog siv thaum nws tsim nyog los qhia tias cov ntaub ntawv tshwj xeeb (lossis cov khoom lag luam) pab txhawb rau daim duab loj. Daim duab ncuav qab zib tsis haum rau kev qhia cov ntaub ntawv hloov pauv lub sijhawm. Tsis tas li ntawd, tsis txhob siv daim ntawv qhia ncuav qab zib los sib piv cov ntaub ntawv uas tsis ntxiv mus rau qhov kawg ntawm qhov kawg.
Cov hauv qab no qhia yuav ua li cas ntxiv daim ntawv ncuav qab zib rau hauv Excel daim ntawv. Cov txheej txheem qhia ua haujlwm hauv Excel 2007-2013. Cov duab yog los ntawm Excel 2013 rau Windows 7. Nyob ntawm qhov version ntawm Excel koj siv, tus kheej cov kauj ruam yuav txawv me ntsis.
Inserting ib daim duab
Hauv qhov piv txwv no, peb xav qhia txog kev sib raug zoo ntawm ntau theem ntawm cov neeg pub dawb uas koom nrog kev siab hlub, piv rau tag nrho cov nyiaj pub dawb. Daim ntawv qhia ncuav qab zib zoo meej los piav qhia qhov no. Cia peb pib los ntawm kev sau cov txiaj ntsig rau txhua qib kev pub dawb.
- Xaiv qhov ntau lossis cov lus ntawm cov ntaub ntawv koj xav qhia hauv daim duab. Nco ntsoov tias yog lub rooj muaj kab Tag nrho cov txiaj ntsig (Grand tag nrho), ces kab no tsis tas yuav tsum tau xaiv, txwv tsis pub nws yuav raug pom raws li ib qho ntawm cov sectors ntawm daim ntawv ncuav qab zib.
- Hauv Advanced tab Insert (Ntxig) hauv ntu Kev kuaj mob (Charts) nyem rau ntawm daim ntawv qhia ncuav qab zib. Muaj ob peb daim ntawv qhia kev xaiv los ntawm. Thaum hovering hla ib qho ntawm cov kev xaiv kab lus qhia, kev saib ua ntej yuav raug qhib. Xaiv qhov kev xaiv tsim nyog tshaj plaws.
Ceev faj! Hauv Excel 2013 lossis tshiab dua, koj tuaj yeem siv ntu Kev kuaj mob (Khoom) tool Kev soj ntsuam ceev ceev (Quick Analysis), lub pob uas tshwm nyob ib sab ntawm cov ntaub ntawv xaiv. Ntxiv rau, koj tuaj yeem siv lub pob Daim duab pom zoo (Cov Ntawv Pom Zoo) tab Insert (Ntxig) qhib lub dialog Ntxig ib daim duab (Insert kab kos).
★ Nyeem ntxiv hauv tsab xov xwm: → Yuav ua li cas ua ib daim ntawv qhia ncuav qab zib hauv Excel, cov qauv, piv txwv, cov lus qhia ib kauj ruam
Editing Pie Chart
Thaum daim duab tso rau hauv qhov chaw zoo, yuav tsum tau ntxiv, hloov lossis kho nws cov ntsiab lus ntau yam. Nyem rau ntawm daim ntawv koj xav hloov kho kom coj mus rau pawg tab ntawm Ribbon Ua haujlwm nrog cov kab kos (Cov cuab yeej kos duab) thiab kho cov khawm. Hauv Excel 2013, ntau txoj kev xaiv tuaj yeem hloov kho siv cov hloov kho khawm ntawm ib sab ntawm daim ntawv.
Hauv qhov Design tab
- Ntxiv cov ntaub ntawv sau npe, kho cov kab kos npe thiab cov lus dab neeg. Nyem Ntau txoj kev xaiv (Ntau qhov kev xaiv) qhib lub vaj huam sib luag formatting thiab nkag mus rau ntau txoj kev xaiv.
- Sim hloov Daim duab Style (Chat Style) thiab Daim duab xim (Daim duab kos duab).
Ntawm Format tab
- Kho kom raug thiab kho qhov style ntawm cov ntawv nyeem hauv lub npe, lus dab neeg, thiab lwm yam.
- Luag cov kab kos ib tus zuj zus mus rau txoj haujlwm tshiab.
- Tshaj tawm cov sectors sib nrug:
- Txhawm rau kom zoom tawm ib ntu, tsuas yog xaiv nws thiab rub nws tawm ntawm daim duab.
- Txhawm rau tshem tawm tag nrho cov sectors ntawm qhov chaw, right-click ntawm daim duab thiab xaiv Cov ntaub ntawv series (Format Data Series). Ntawm lub vaj huam sib luag uas tshwm, nyem Sliced Pie Chart (Pie Explosion) hloov qhov kev ncua deb ntawm daim.
- Rau daim duab peb sab, koj tuaj yeem kho qhov tuab, tig lub kaum sab xis, ntxiv cov duab ntxoov ntxoo thiab lwm yam tsis muaj ntawm daim duab nws tus kheej thiab thaj chaw plotting.
Qhov tshwm sim tsis yog tsuas yog ib qho kev piav qhia ntawm kev koom tes ntawm txhua pab pawg ntawm cov neeg pub dawb rau qhov ua rau lub koom haum, tab sis kuj tseem tsim cov duab zoo nkauj uas tsim nyog rau cov ntawv qhia, cov ntawv tshaj tawm thiab tso rau hauv cov vev xaib, saib xyuas cov xim thiab cov qauv ntawm koj lub koom haum. .