Yuav Kho Li Cas Cov Lus Dab Neeg Hauv Excel: 9 Kauj Ruam (nrog Duab)

Cov txheej txheem:

Yuav Kho Li Cas Cov Lus Dab Neeg Hauv Excel: 9 Kauj Ruam (nrog Duab)
Yuav Kho Li Cas Cov Lus Dab Neeg Hauv Excel: 9 Kauj Ruam (nrog Duab)
Anonim

Qhov wikiHow qhia koj yuav hloov pauv lub npe lossis tus nqi ntawm daim duab kab lus dab neeg nkag rau hauv Microsoft Excel daim ntawv nthuav qhia, siv lub khoos phis tawj.

Cov kauj ruam

Kho cov lus dab neeg nkag hauv Excel Kauj Ruam 1
Kho cov lus dab neeg nkag hauv Excel Kauj Ruam 1

Kauj Ruam 1. Qhib daim ntawv Excel daim ntawv uas koj xav hloov

Nrhiav daim ntawv uas koj xav kho hauv koj lub khoos phis tawj, thiab ob npaug nias rau nws lub cim kom qhib daim ntawv ua haujlwm.

Kho cov lus dab neeg nkag hauv Excel Kauj Ruam 2
Kho cov lus dab neeg nkag hauv Excel Kauj Ruam 2

Kauj Ruam 2. Nyem rau kab ntawv koj xav hloov

Nrhiav daim duab uas koj xav hloov kho hauv koj daim ntawv nthuav qhia, thiab nyem rau nws kom xaiv kab ntawv.

Qhov no yuav tso tawm koj cov cuab yeej qhia kab ntawv nyob rau sab saum toj ntawm koj daim ntawv nthuav qhia, xws li Tsim, Txheej txheem, thiab Hom ntawv

Kho cov lus dab neeg nkag hauv Excel Kauj Ruam 3
Kho cov lus dab neeg nkag hauv Excel Kauj Ruam 3

Kauj Ruam 3. Nyem rau Tsim tab

Koj tuaj yeem pom nws nyob rau sab saud ntawm Excel's toolbar ribbon. Nws yuav tso saib koj daim phiaj tsim cov cuab yeej ntawm lub cuab yeej.

Nyob ntawm koj qhov Excel version, tab no tuaj yeem raug hu ua Daim Qauv Tsim.

Kho cov lus dab neeg nkag hauv Excel Kauj Ruam 4
Kho cov lus dab neeg nkag hauv Excel Kauj Ruam 4

Kauj Ruam 4. Nyem Xaiv Cov Ntaub Ntawv hauv Tus Tsim toolbar

Qhov no yuav qhib lub thawv sib tham tshiab uas koj tuaj yeem hloov kho koj cov dab neeg thiab cov ntaub ntawv muaj txiaj ntsig.

Kho cov lus dab neeg nkag hauv Excel Kauj Ruam 5
Kho cov lus dab neeg nkag hauv Excel Kauj Ruam 5

Kauj Ruam 5. Xaiv cov lus dab neeg nkag rau hauv "Cov lus dab neeg nkag (Series)" lub thawv

Lub npov no teev tag nrho cov lus dab neeg nkag hauv koj daim ntawv. Nrhiav qhov nkag uas koj xav kho ntawm no, thiab nyem rau nws kom xaiv nws.

Kho cov lus dab neeg nkag hauv Excel Kauj Ruam 6
Kho cov lus dab neeg nkag hauv Excel Kauj Ruam 6

Kauj Ruam 6. Nyem rau khawm Kho kom raug

Qhov no yuav tso cai rau koj los kho qhov xaiv nkag lub npe thiab cov ntaub ntawv muaj txiaj ntsig.

Ntawm qee qhov qauv ntawm Excel, koj yuav tsis pom qhov hloov kho khawm. Hauv qhov no, koj tuaj yeem hla cov kauj ruam no, thiab nrhiav rau Lub Npe los yog Lub Npe Lub Npe teb hauv tib lub npov sib tham.

Kho cov lus dab neeg nkag hauv Excel Kauj Ruam 7
Kho cov lus dab neeg nkag hauv Excel Kauj Ruam 7

Kauj Ruam 7. Ntaus lub npe nkag tshiab rau hauv Lub Npe Lub Npe lub thawv

Ob npaug nias rau kab ntawv, tshem tawm lub npe tam sim no, thiab sau lub npe uas koj xav muab rau cov npe no hauv koj daim duab zaj dab neeg.

  • Lub thawv no kuj tseem tuaj yeem sau npe ua Lub Npe hloov Series Series Name.
  • Xwb, koj tuaj yeem nyem lub cim Sib Tham Sib Tham, thiab xaiv lub cell los ntawm daim ntawv nthuav qhia. Qhov no yuav theej thiab muab lub cell xaiv cov ntsiab lus raws li lub npe nkag.
Kho cov lus dab neeg nkag hauv Excel Kauj Ruam 8
Kho cov lus dab neeg nkag hauv Excel Kauj Ruam 8

Kauj Ruam 8. Nkag mus rau tus nqi daim phiaj tshiab rau hauv Y lub npov qhov tseem ceeb

Koj tuaj yeem tshem tawm qhov kev xaiv nkag tus nqi tam sim no ntawm no, thiab ntaus tus nqi tshiab los hloov koj daim ntawv.

  • Yog tias koj muaj ntau pawg Y tso tawm hauv koj daim ntawv, xws li ntau kab, nco ntsoov siv tus lej los cais txhua tus nqi ntawm no.
  • Xwb, koj tuaj yeem nyem lub cim Sib Tham Sib Tham, thiab xaiv lub xov tooj ntawm tes lossis ntau lub cell los ntawm daim ntawv nthuav qhia kom xa cov txiaj ntsig ntawm tes rau hauv koj daim ntawv.
Kho cov lus dab neeg nkag hauv Excel Kauj Ruam 9
Kho cov lus dab neeg nkag hauv Excel Kauj Ruam 9

Kauj ruam 9. Nyem rau OK khawm

Qhov no yuav txuag koj lub npe thiab tus nqi hloov kho, thiab siv qhov kev hloov pauv rau koj daim duab pom.

Pom zoo: