Ib qho ntawm qhov zoo tshaj plaws ntawm cov kab kos hauv Excel yog lub peev xwm los sib piv cov ntaub ntawv nrog lawv cov kev pab. Tab sis ua ntej tsim ib daim ntawv qhia, nws tsim nyog siv sij hawm me ntsis xav txog dab tsi cov ntaub ntawv thiab yuav ua li cas qhia nws thiaj li ua kom daim duab meej li sai tau.
Cia peb saib txoj hauv kev Excel tuaj yeem tso saib ntau cov ntaub ntawv los tsim cov ntawv qhia meej thiab yooj yim-rau-nyeem ntawv yam tsis siv rau PivotCharts. Cov txheej txheem piav qhia ua haujlwm hauv Excel 2007-2013. Cov duab yog los ntawm Excel 2013 rau Windows 7.
Kem thiab bar kab kos nrog ntau cov ntaub ntawv series
Txhawm rau tsim ib daim ntawv qhia zoo, ua ntej txheeb xyuas tias cov kab ntawv cov ntaub ntawv muaj cov kab lus thiab cov ntaub ntawv tau teeb tsa hauv txoj hauv kev zoo tshaj plaws kom nkag siab nws. Xyuas kom tseeb tias tag nrho cov ntaub ntawv yog scaled thiab loj tib yam, txwv tsis pub nws yuav ua rau tsis meej pem, piv txwv li, yog ib kem muaj muag cov ntaub ntawv nyob rau hauv las thiab lwm kem muaj ntau lab daus las.
Xaiv cov ntaub ntawv koj xav qhia hauv daim duab. Hauv qhov piv txwv no, peb xav muab piv rau saum 5 lub xeev los ntawm kev muag khoom. Hauv tab Insert (Ntxig) xaiv hom kab ntawv twg los ntxig. Nws yuav zoo li no:
Raws li koj tau pom, nws yuav siv sij hawm me ntsis tidying li daim duab ua ntej nthuav tawm rau cov neeg tuaj saib:
- Ntxiv cov npe thiab cov ntaub ntawv series daim ntawv lo. Nyem rau ntawm daim ntawv qhia kom qhib pawg tab Ua haujlwm nrog cov kab kos (Cov cuab yeej kos duab), tom qab ntawd kho cov kab kos npe los ntawm txhaj rau ntawm cov ntawv sau Daim ntawv npe (Tswj lub npe). Txhawm rau hloov cov ntaub ntawv series, ua raws li cov kauj ruam no:
- xovxwm Xaiv cov ntaub ntawv (Xaiv cov ntaub ntawv) tab constructor (Tsim) qhib lub dialog Xaiv cov ntaub ntawv qhov chaw (Xaiv Data Source).
- Xaiv cov ntaub ntawv series koj xav hloov thiab nias lub pob hloov (Hloov) qhib lub dialog Kab hloov (Hloov Series).
- Ntaus ib daim ntawv teev cov ntaub ntawv tshiab hauv cov ntawv sau Row npe (Series npe) thiab nias OK.
- Hloov kab thiab kab. Qee lub sij hawm tus qauv sib txawv yuav tsum muaj kev sib txawv ntawm cov ntaub ntawv. Peb daim ntawv qhia bar tus qauv ua rau nws nyuaj rau pom tias txhua lub xeev cov txiaj ntsig tau hloov pauv li cas rau lub sijhawm. Nyem lub khawm Kab kab (Hloov kab / kab) ntawm tab constructor (Tsim) thiab ntxiv cov ntawv sau raug rau cov ntaub ntawv series.
Tsim ib daim ntawv qhia combo
Qee lub sij hawm koj yuav tsum sib piv ob cov ntaub ntawv sib txawv, thiab qhov no yog qhov ua tau zoo tshaj plaws siv ntau hom kab kos. Daim ntawv Excel combo tso cai rau koj los tso saib cov ntaub ntawv sib txawv thiab cov qauv hauv ib daim ntawv qhia. Piv txwv li, cia peb hais tias peb xav muab piv rau Txhua Xyoo Tag Nrho tawm tsam kev muag khoom ntawm 5 lub xeev saum toj kawg nkaus kom pom cov xeev twg tau ua raws li tag nrho cov qauv.
Txhawm rau tsim ib daim ntawv qhia combo, xaiv cov ntaub ntawv koj xav qhia rau ntawm nws, tom qab ntawd nyem lub dialog box launcher Inserting ib daim duab (Chat Insert) nyob rau hauv lub ces kaum ntawm pawg lus txib Kev kuaj mob (Chav) tab Insert (Ntxig). Hauv tshooj Txhua daim duab (Txhua Daim Ntawv Qhia) nyem Ua ke (Combo).
Xaiv hom kab ntawv tsim nyog rau txhua cov ntaub ntawv series los ntawm cov npe poob. Nyob rau hauv peb piv txwv, rau ib tug series ntawm cov ntaub ntawv Tag Nrho Txhua Xyoo peb xaiv ib daim ntawv qhia nrog thaj chaw (Tej cheeb tsam) thiab muab tso ua ke nrog lub histogram los qhia tias ntau npaum li cas txhua lub xeev pab txhawb rau tag nrho thiab lawv cov kev sib txawv li cas.
Ntxiv rau, ntu Ua ke (Combo) tuaj yeem qhib los ntawm nias lub pob Hloov hom kab kos (Hloov kab ntawv hom) tab constructor (tsim).
Tswv yim: Yog tias ib qho ntawm cov ntaub ntawv series muaj qhov sib txawv ntawm qhov seem thiab cov ntaub ntawv ua nyuaj rau qhov txawv, ces kos lub thawv Secondary qag (Secondary Axis) nyob rau hauv pem hauv ntej ntawm ib kab uas tsis haum rau tag nrho cov nplai.
