Nkag siab cov lus dab neeg thiab cov lus dab neeg hauv Excel Spreadsheets

Cov txheej txheem:

Nkag siab cov lus dab neeg thiab cov lus dab neeg hauv Excel Spreadsheets
Nkag siab cov lus dab neeg thiab cov lus dab neeg hauv Excel Spreadsheets
Anonim

Nyob hauv daim duab lossis daim duab hauv daim ntawv teev lus xws li Microsoft Excel, cov lus dab neeg feem ntau nyob ntawm sab xis ntawm daim duab lossis daim duab thiab qee zaum nyob ib puag ncig ntawm ciam teb. Cov lus dab neeg txuas nrog cov ntaub ntawv uas tau muab tso rau hauv cov duab kos duab. Txhua qhov kev nkag tshwj xeeb hauv cov lus dab neeg suav nrog cov lus dab neeg tseem ceeb rau kev xa cov ntaub ntawv.

Cov ntaub ntawv hauv kab lus no siv rau Excel 2019, 2016, 2013, Excel rau Mac, thiab Excel Online.

Dab tsi yog Cov Ntsiab Lus Dab Tsi?

Ntxiv rau qhov tsis meej pem ntawm cov lus dab neeg thiab cov yuam sij, Microsoft hais txog txhua tus neeg hauv cov lus dab neeg raws li cov lus dab neeg tseem ceeb. A lus dab neegyog ib qho xim lossis cov cim cim hauv cov lus dab neeg. Nyob rau sab xis ntawm txhua tus yuam sij lus dab neeg yog lub npe txheeb xyuas cov ntaub ntawv sawv cev los ntawm tus yuam sij tshwj xeeb.

Image
Image

Nyob ntawm hom kab ntawv, cov lus dab neeg cov yuam sij sawv cev rau pawg sib txawv ntawm cov ntaub ntawv hauv daim ntawv ua haujlwm nrog:

  • kab kab, kab kos duab, lossis kab ntawv kab: Txhua tus yuam sij lus dab neeg sawv cev rau cov ntaub ntawv ib zaug. Piv txwv li, nyob rau hauv kab ntawv kab lus, tej zaum yuav muaj ib lub ntsiab lus xiav xiav uas nyeem Cov Khoom Noj Khoom Noj Zoo Tshaj Plaws ntawm nws. Cov xim xiav hauv daim duab qhia txog cov pov npav rau txhua qhov nkag hauv Cov Khoom Noj Khoom Noj.
  • Pie Daim Ntawv lossis Lub voj voos: Txhua tus lus dab neeg tseem ceeb tsuas yog ib feem ntawm ib cov ntaub ntawv. Txhawm rau siv tib qho piv txwv los ntawm saum toj no, tab sis rau daim ntawv qhia ncuav qab zib, txhua qhov kev txiav ntawm lub ncuav qab zib yog xim sib txawv uas sawv cev rau txhua qhov "Snacks" nkag. Txhua feem ntawm lub ncuav qab zib yog qhov sib txawv me me ntawm tag nrho lub voj voog los sawv cev rau qhov kev pov npav qhov sib txawv los ntawm "Votes" series.

Editing Legends thiab Legend Keys

Hauv Excel, cov lus dab neeg tau txuas nrog cov ntaub ntawv hauv thaj chaw thaj chaw, yog li hloov cov xim ntawm cov lus dab neeg tseem ceeb kuj tseem yuav hloov xim ntawm cov ntaub ntawv hauv thaj chaw. Koj muaj peev xwm right-click los yog kais-thiab-tuav ntawm tus yuam sij lus dab neeg, thiab xaiv Format Legend, hloov xim, qauv, lossis duab siv los sawv cev cov ntaub ntawv.

Image
Image

Txhawm rau hloov cov kev xaiv cuam tshuam nrog rau tag nrho cov lus dab neeg thiab tsis yog ib qho kev nkag tshwj xeeb, nyem nyem lossis kais-thiab-tuav kom pom qhov Format Legend kev xaiv. Nov yog qhov koj hloov pauv cov ntawv sau, cov ntawv sau, cov ntawv sau, thiab lub thawv ntawv.

Yuav ua li cas Qhia cov lus dab neeg hauv Excel

Tom qab ua daim ntawv qhia hauv Excel, nws muaj peev xwm hais tias cov lus dab neeg tsis cia li qhia. Koj tuaj yeem qhib cov lus dab neeg los ntawm kev yooj yim toggling rau nws. Nov yog li cas:

  1. Xaiv koj tus uas twb muaj lawm chart.
  2. Xaiv Design.
  3. Xaiv Ntxiv Daim Ntawv Qhia.
  4. Select lus dab neeg.
  5. Xaiv qhov twg cov lus dab neeg yuav tsum muab tso rau - sab xis, sab saum toj, sab laug, lossis hauv qab. Tseem muaj Ntau yam lus dab neeg> Top Right yog koj nyiam.

Yog qhov kev xaiv ntxiv cov lus dab neeg greyed tawm, nws tsuas yog txhais tau tias koj yuav tsum xaiv cov ntaub ntawv ua ntej. Txoj nyem rau ntawm daim ntawv tshiab, khoob thiab xaiv Xaiv cov ntaub ntawv, thiab tom qab ntawd ua raws cov lus qhia ntawm lub vijtsam xaiv cov ntaub ntawv uas daim duab yuav tsum sawv cev.

Pom zoo: