Yuav Tsim Kab Ua Dab Tsi Hauv Excel

Cov txheej txheem:

Yuav Tsim Kab Ua Dab Tsi Hauv Excel
Yuav Tsim Kab Ua Dab Tsi Hauv Excel
Anonim

Txhua cov ntawv nyeem, txawm tias ib tus paub tab thiab cov ntsiab lus tseem ceeb, yuav tsum muaj daim duab piav qhia. Yog tias nws muaj ntau cov ntaub ntawv sib piv, cov ntxhuav, tom qab ntawd lub siab xav pom lawv tsis yog hauv daim ntawv ntawm tus lej qhuav, tab sis kuj tseem nyob rau hauv daim ntawv ntawm cov duab cov duab thiab cov duab kos. Lawv muaj ntau yam meej dua qhia tias muaj dab tsi tshwm sim hauv cov ntawv tabular. Ntxiv mus, qhov no tuaj yeem ua tiav yam tsis muaj kev pab cuam ntawm txhua yam duab nraaj tsim nyog hauv txoj haujlwm uas koj npaj lub rooj - hauv Excel.

Yuav tsim kab ua dab tsi hauv Excel
Yuav tsim kab ua dab tsi hauv Excel

Cov Lus Qhia

Kauj ruam 1

Ua ntej tshaj, tsim lub rooj koj xav tau. Cia siab tias lub teeb muaj ob txoj kab nruab nrab - kab rov tav (X-axis) thiab ntsug (Y-axis). Raws li, hauv lub rooj, cov no yuav yog cov kab thiab kab. Cov npe ntawm cov kem thiab cov kab yuav tom qab no yog cov npe ntawm cov kab sib. Piv txwv ntawm lub rooj.

Tom qab lub rooj tsim tau, xaiv nws thiab nyem lub pob "Chart Wizard". Los ntawm lub neej ntawd, nws nyob ntawm tus txheej txheem toolbar ntawm ntawm lub cim pab. Cov Ntawv Qhia ntawm Cov Ntawv Qhia (kauj ruam 1 ntawm 4): Daim ntawv hom qhov rai qhib. Hauv qhov rai no, xaiv cov kab xaiv uas haum rau koj zoo tshaj plaws. Txhawm rau tshawb nrhiav yuav ua li cas koj cov ntaub ntawv yuav saib nyob rau hauv ib txoj kev lossis lwm qhov, muaj lub pob "View results". Nyem rau nws thiab tuav nws rau ib ntus - hauv "Saib" qhov chaw, kab xwm yuav tshwm rau hauv kev sib piv nrog koj cov lus. Yog tias koj tsis pom qhov koj xav tau ntawm cov qauv kos duab, saib ntawm kab "Tsis-standard" tab.

Kauj ruam 2

Muaj kev txiav txim siab rau hom duab kos, nyem "Next" khawm - mus rau kauj ruam 2. Nyob rau sab saum toj ntawm lub qhov rai yog qhov piv txwv ntawm koj daim duab yav tom ntej, tom qab ntawd "ntau yam" yog thaj chaw xaiv. Yog tias koj tsis nco qab xaiv lub rooj thaum pib, lossis xav hloov lub xaiv, hloov nws ntawm no. Tsis tas li, los ntawm kev hloov ntawm "Rows in Rows / Columns" pointer, koj tuaj yeem hloov cov ntaub ntawv raws kab X thiab Y. Cov txiaj ntsig tau pom tam sim ntawd, yog tias koj tsis nyiam nws, rov muab nws li nws tau.

Kauj ruam 3

Ntawm theem 3, koj tuaj yeem tsim txhua qhov tsim nyog: tsim qauv ntawm cov khoom, cov xim thiab tuab ntawm kab, sau, cim, ntawv, thiab lwm yam Nrog rau ntawm no, hauv kab "Legend" tab, tsim nws (los ntawm kev kuaj xyuas qhov sib thooj kem), txhais lub chaw los ntawm in relation to lub sijhawm. Cov lus dab neeg xav tau nyob rau hauv thiaj li yuav pom tam sim cov ntaub ntawv hauv daim duab txhais tau li cas. Ntawm no koj tuaj yeem muab cov ntaub ntawv tabular sau rau hauv daim ntawv.

Kauj ruam 4

Ntawm cov kauj ruam kawg, xaiv seb koj xav pom daim duab ua qauv zoo li cas, daim duab kos - nyob rau tib daim ntawv raws li lub rooj, lossis ntawm lwm (koj tuaj yeem xaiv txhua daim ntawv uas muaj nyob hauv phau ntawv lossis tsim ib qho tshiab). Txhawm xaiv, nyem rau ntawm "Finish" khawm. Koj lub teeb yuav zoo li no.

Kauj ruam 5

Yog tias dheev, vim qee qhov, koj tsis txaus siab rau qhov tshwm sim, nws yooj yim los kho nws. Koj tuaj yeem kho daim ntawv ncaj qha hauv nws (los ntawm txoj cai-nyem los ntawm cov ntawv qhia zaub mov) lossis hauv cov ntawv qhia zaub mov "Daim Ntawv Qhia". Cov sub-sub ntawm cov kab no muaj tag nrho plaub kauj ruam uas tau hais los saum no.

Tam sim no koj paub tias los ntawm kev hloov cov ntaub ntawv hauv lub rooj tseem ceeb, koj yuav tau txais daim duab hloov kho tam sim ntawd. Cov txiaj ntsig tau pom tseeb - koj tsis tas yuav teem sijhawm tshiab txhua zaus, hloov nws tsawg kawg ib teev. Nws yog ntawm txoj ntsiab cai no hais tias ntau yam ntaub ntawv txhua txhua hnub, txhua hli thiab lwm cov ntawv qhia tau tsim - xim yam thiab meej.

Pom zoo: