Hauv Microsoft Excel, siv cov kab kos kab sib piv los sib piv cov ntaub ntawv hauv hom kev pom. Kem kab kos kuj yog ib txoj hauv kev zoo los qhia cov ntaub ntawv hloov pauv nyob rau lub sijhawm lossis qhia txog cov khoom sib piv. Ntxiv cov ntawv formatting thiab hloov daim duab xim kom koj cov ntaub ntawv sawv ntsug.
Ntawm no yog saib ntawm kev tsim kab kos duab nrog rau kev siv cov qauv tshiab.
Cov ntaub ntawv hauv kab lus no siv rau Excel rau Microsoft 365, Excel 2019, Excel 2016, Excel 2013, Excel 2010, thiab Excel 2007.
Yuav ua li cas sau ib kab ntawv hauv Excel
Ua raws cov kauj ruam no los tsim cov kab ke yooj yim hauv Excel.
- Tau cov ntaub ntawv rau hauv Excel spreadsheet.
- Xaiv cov ntaub ntawv kom suav nrog hauv daim duab. suav nrog kab thiab kab kab tab sis tsis yog lub npe rau cov ntaub ntawv.
-
In Excel 2016, xaiv lub Insert > Insert Kem lossis Bar Chart icon, thiab tom qab ntawd xaiv kab ntawv xaiv.
In Excel 2013, xaiv lub Insert > Insert kab ntawv icon, thiab tom qab ntawd xaiv kab ntawv xaiv.
In Excel 2010 thiab Excel 2007, xaiv Insert > Kem, thiab tom qab ntawd xaiv kab ntawv xaiv.
Image
Format koj daim ntawv Excel
Tom qab koj tau tsim daim ntawv qhia hauv Excel, muaj ntau txoj hauv kev los tsim daim ntawv kom nws nyeem tau ntau dua lossis sawv tawm ntau dua.
-
Xaiv kab ntawv koj xav format.
Txoj kev yooj yim tshaj plaws los xaiv tag nrho daim ntawv yog xaiv sab saum toj sab laug lossis sab xis saum toj kawg nkaus ntawm daim ntawv teev npe.
- Yog xav siv daim duab sib txawv, xaiv Design > kab kos, thiab xaiv qhov layout.
- Yog xav siv daim duab txawv txawv, xaiv Design > Daim Ntawv Qhia, thiab xaiv lwm tus qauv.
-
Yog xav siv cov qauv sib txawv, xaiv Format > Shape Styles, thiab xaiv lwm hom qauv.
Ib yam style hom ntawv tsuas yog daim duab ciam teb.
- Txhawm rau ntxiv cov teebmeem sib txawv, xaiv Format > Shape Effects, thiab xaiv los ntawm cov kev xaiv muaj.
- Yog xav siv lub ntsiab lus, xaiv Page Layout > Themes, thiab xaiv lub ntsiab lus tshiab.
Yog tias koj xav tsim ib qho tshwj xeeb ntawm daim duab, xws li Daim Ntawv Qhia Thaj Chaw lossis Axis, xaiv Format thiab tom qab ntawd xaiv cov khoom ntawm Chart Elements dropdown box. Xaiv xaiv hom, thiab hloov txhua yam koj xav hloov.
Ntxiv thiab kho cov kab kos npe
Txhawm rau ntxiv lub npe rau koj daim duab:
- Nyob hauv daim duab, xaiv lub Daim Ntawv Teev Npe thiab ntaus lub npe.
- Xaiv ntsuab ntxiv (+) kos npe rau sab xis ntawm daim duab.
- Xaiv tus xub nyob ib sab Daim Ntawv Teev Npe.
-
Xaiv qhov xav tau ntawm koj lub npe. Los yog rau kev xaiv formatting ntxiv, xaiv Ntau Options.
Image Hauv Excel 2010 thiab 2007, cov kab kos yooj yim tsis suav nrog cov ntawv teev npe. Cov no yuav tsum tau muab ntxiv cais. Xaiv Layout > kab ntawv npe txhawm rau ntxiv ib daim ntawv teev npe.
Hloov kab xim
- Xaiv kab hauv kab ntawv los xaiv tag nrho nws cov kab sib xws.
- Xaiv Format.
-
Xaiv Shape Fill los qhib lub Fill Colours dropdown panel.
-
Xaiv xim.
Image
Txhob daim ntawv mus rau ib daim ntawv cais
Tsiv daim ntawv mus rau ib daim ntawv cais ua kom yooj yim rau luam daim ntawv. Nws kuj tseem tuaj yeem txo qhov kev sib tsoo hauv daim ntawv ua haujlwm loj uas muaj cov ntaub ntawv.
- Xaiv kab ntawv keeb kwm yav dhau los xaiv tag nrho daim ntawv.
- Xaiv lub Design tab.
- Xaiv Move Chart los qhib lub Txawj kab ntawv dialog box.
- Xaiv tus daim ntawv tshiab kev xaiv thiab muab daim ntawv npe.
-
Xaiv OK txhawm rau kaw lub dialog box. Daim ntawv qhia tam sim no nyob rau ntawm daim ntawv ua haujlwm sib cais, thiab lub npe tshiab pom ntawm daim ntawv tab.
Image
