Nws yooj yim heev rau siv cov duab kos los qhia txog ntau yam ntawm cov ntaub ntawv sau nruab nrog thiab suav daws. Cov ntaub ntawv tshaj tawm Microsoft Excel muaj ntau cov qauv kab kos thiab tso cai rau koj los tsim cov kev sib txuas ua ke los ntawm cov qauv npaj txhij.
Cov Lus Qhia
Kauj ruam 1
Ua ntej ua tiav daim duab kab ke, tsim lub rooj uas muaj cov ntaub ntawv tshaj tawm thiab xaiv cov xov tooj ntawm tes hauv. Tom qab ntawd koj tuaj yeem ua hauv kev sib txawv:
- hauv kab ntawv "Insert", xaiv cov ntawv "Diagram";
- ntawm tus txheej txheem toolbar, nyem qhov "Chart Wizard" khawm;
- ກົດ F11 yuam.
Excel yuav tsim tau daim duab ntawm cov ntawv sib txawv siv cov chaw pib. Vim tias daim duab qhia raug teeb tsa los ntawm lub neej ntawd, mus rau ntawm Chart cov khoom ntawm cov ntawv qhia zaub mov tseem ceeb thiab qhib Daim Ntawv Teev Cov Ntawv Cim kom xaiv daim chart.
Kauj ruam 2
Txheeb xyuas "kos duab" rau hauv "Daim Ntawv" hom. Muaj 2 tab nyob hauv Chart Wizard qhov rai: "Tus Qauv" thiab "Tsis-Txhab". Ntawm cov kab tsis raws qauv, Excel muaj cov sib txuas ua ke, piv txwv li, cov duab kab nrog histogram lossis kab xwm uas muaj ob kab sib txig ntawm qhov muaj nuj nqis. Nyem Next.
Kauj ruam 3
Hauv kab "Ntau Yam", hais kom meej qhov ntau ntawm qhov muaj nuj nqis uas los ntawm kev teeb ntsuas. Los ntawm lub neej ntawd, qhov kev zov me nyuam txiav txim siab rau tag nrho cov lus. Hauv seem "Rows hauv", khij qhov twg yuav muaj nuj nqis rau ntawm abscissa: kem lossis kab. Nyem "Tom ntej" mus txuas ntxiv.
Kauj ruam 4
Teeb ntsuas kab kos:
- hauv "Daim Ntawv Qhia" tab - lub npe ntawm cov duab kos thiab cov npe ntawm nws cov axes;
- "Lus dab neeg" - kev tso cov lus dab neeg rau ntawm daim ntawv txheeb ze rau cov ntawv;
- "Cov ntaub ntawv lub rooj" - seb nws yog qhov yuav tsum tau qhia lub rooj ib txhij nrog daim duab;
Nyem "Next" mus rau kauj ruam tom ntej.
Kauj ruam 5
Qhia qhov chaw uas teem sij hawm rau muab tso rau: ntawm lwm daim ntawv lossis rau daim ntawv pov thawj haujlwm tam sim no.
Kauj Ruam 6
Yog tias koj xav hloov qhov tuab thiab xim ntawm ib kab ntawm kab ntsuas, xaiv cov ntaub ntawv yuav tsum tau muaj kab thiab qhib "Hom Ntawv" hauv cov ntawv qhia zaub mov tseem ceeb. Xaiv cov lus qhia "Xaiv Kab". Hauv "Daim Ntawv Qhia Cov Qauv Tawm Tsam" ntawm lub qhov rais, los ntawm kev mus rau cov tab uas tsim nyog, hloov cov tsos ntawm cov kab teeb thiab cov cim. Koj tuaj yeem xaiv cov xim thiab tuab ntawm txoj kab thiab cov duab geometric ntawm lub cim; ntxiv cov lus dab neeg thiab cov ntawv sau; tsim cov phiaj xwm txoj kab ntawm txoj kab sib tshuam axes, thiab lwm yam.
