Cov txheej txheem:

Yuav Ua Li Cas Tsim Teeb Duab hauv MS Excel 2016: 6 Cov Kauj Ruam
Yuav Ua Li Cas Tsim Teeb Duab hauv MS Excel 2016: 6 Cov Kauj Ruam

Video: Yuav Ua Li Cas Tsim Teeb Duab hauv MS Excel 2016: 6 Cov Kauj Ruam

Video: Yuav Ua Li Cas Tsim Teeb Duab hauv MS Excel 2016: 6 Cov Kauj Ruam
Video: Tsis Muaj Peev Xwm Yuav Ua Li Cas 2024, Kaum ib hlis
Anonim
Yuav Ua Li Cas Tsim Teeb Duab hauv MS Excel 2016
Yuav Ua Li Cas Tsim Teeb Duab hauv MS Excel 2016

Cov lus qhia ib kauj ruam-ib-kauj ruam piav qhia yuav ua li cas los tsim daim duab siv Microsoft Excel. Txhua tus neeg siv nrog txheej txheej ntawm cov ntaub ntawv thiab nkag mus rau Excel txoj haujlwm yuav tuaj yeem tsim cov duab los ntawm kev ua raws cov lus qhia no. Txhua qhov kev qhia sau ntawv yog nrog daim duab los muab kev pab pom kev. Cov ntaub ntawv siv hauv qhov piv txwv no yog tus naj npawb ntawm M & Ms hauv ib lub hnab, tab sis cov ntaub ntawv ntau npaum li cas tuaj yeem siv los tsim daim duab los ntawm kev ua raws cov lus qhia no.

Kauj ruam 1: Pib Excel 2016

Thaum qhov kev qhia no yuav ua haujlwm rau cov khoos phis tawj niaj hnub no ntawm Excel, peb yuav siv qhov tshiab tshaj tawm xyoo 2016.

OS X:

  1. Qhib lub ncoo
  2. Qhib Excel
  3. Tsim phau ntawv ua haujlwm dawb

Rau Windows:

  1. Nias pib khawm
  2. Ntaus Excel
  3. Qhib Excel
  4. Tsim daim ntawv ua haujlwm dawb paug

Kauj Ruam 2: Sau thiab Muab Cov Ntaub Ntawv

Sau thiab Muab Cov Ntaub Ntawv
Sau thiab Muab Cov Ntaub Ntawv

Thaum koj tuaj yeem siv cov ntaub ntawv muaj nuj nqis yooj yim, rau qhov piv txwv no peb yuav suav qhov sib piv ntawm cov xim sib txawv ntawm M & Ms.

Rau ob lub OS X thiab Windows:

  1. Sau cov pawg ntawm cov ntaub ntawv rau hauv kab A, pib nrog daim ntawv lo hauv lub thawv A1. Hauv qhov piv txwv no, daim ntawv lo "xim" mus rau hauv lub thawv A1, thiab xim ntawm M & Ms nyob hauv cov thawv A2 - A6.
  2. Nkag mus rau cov ntaub ntawv sib thooj rau hauv kab B, pib nrog daim ntawv lo hauv lub thawv B1. Hauv qhov piv txwv no, daim ntawv lo "Tus naj npawb ntawm M & Ms" mus rau hauv lub thawv B1, thiab tus nqi ntawm txhua qhov xim sib xws ntawm M & Ms nyob hauv cov thawv B2 - B6.

Kauj Ruam 3: Tsim Cov Duab

Tsim Cov Duab
Tsim Cov Duab
Tsim Cov Duab
Tsim Cov Duab

OS X:

  1. Qhia cov ntaub ntawv, suav nrog cov ntawv cim rau txhua kab ntawv los ntawm kev nyem thiab rub thaum tuav lub pob nyem sab laug.
  2. Nyem rau ntawm "Charts" tab nyob rau sab saum toj ntawm txoj haujlwm.
  3. Xaiv hom kab uas koj xav tsim los ntawm txhaj rau ib qho ntawm cov kev xaiv hauv qab nqe lus "Ntxig Daim Duab". Txog qhov piv txwv no, peb tau xaiv daim ntawv qhia ncuav qab zib.
  4. Xaiv cov qauv pom ntawm koj daim duab ntawm cov ntawv qhia zaub mov uas tshwm.

Rau Windows:

  1. Qhia cov ntaub ntawv, suav nrog cov ntawv cim rau txhua kab ntawv los ntawm nyem thiab rub thaum tuav lub pob nyem sab laug.
  2. Nyem rau ntawm "Insert" tab nyob rau sab saum toj ntawm qhov program.
  3. Xaiv hom kab uas koj xav tsim los ntawm txhaj rau ib qho ntawm cov kev xaiv hauv qab "pom cov kab kos"
  4. Xaiv cov qauv zaub rau koj daim duab ntawm cov ntawv qhia zaub mov uas tshwm

Kauj Ruam 4: Ntxiv Lub Npe thiab Cov Ntawv Cim

Ntxiv Title thiab Labels
Ntxiv Title thiab Labels
Ntxiv Title thiab Labels
Ntxiv Title thiab Labels
Ntxiv Title thiab Labels
Ntxiv Title thiab Labels
Ntxiv Title thiab Labels
Ntxiv Title thiab Labels

OS X:

  1. Nyem qhov twg tsis pub dhau ciam teb ntawm koj daim duab los qhia nws.
  2. Nyem rau ntawm "Chart Layout" tab nyob rau sab saum toj, tom qab ntawd xaiv "Chart Title". Xaiv lub npe npe los ntawm cov ntawv qhia zaub mov nco.
  3. Kho kom raug koj lub npe los ntawm txhaj ib zaug ntawm cov npe kab ntawv tseeb los qhia lub thawv ntawv, tom qab ntawd tso cai rau tus cursor tshwm.
  4. Xaiv "Dab neeg" (hauv qab "Chart Layout"). Xaiv cov lus dab neeg los ntawm cov ntawv qhia zaub mov nco.
  5. Xaiv "Cov Ntawv Qhia Cov Ntaub Ntawv" (hauv qab "Chart Layout"). Xaiv ib daim ntawv lo los ntawm cov ntawv qhia zaub mov nco.

Rau Windows:

  1. Tsuas yog ob npaug nias rau ib qho ntawm cov npe ua ntej lossis cov ntawv cim los kho lawv.
  2. Txhawm rau ntxiv cov ntawv tshiab, nyem rau 'Add Chart Element' tab ntawm lub ces kaum sab saud

Kauj Ruam 5: Kho Cov Txheej Txheem Xim

Kho kom raug xim txheej txheem
Kho kom raug xim txheej txheem
Kho kom raug xim txheej txheem
Kho kom raug xim txheej txheem

Hauv qhov piv txwv no, peb yuav sib piv cov xim hauv kab ntawv rau xim ntawm M & Ms sawv cev.

OS X:

  1. Nyem rau ntawm "Format" tab, ib sab ntawm "Chart Layout" nyob rau saum toj.
  2. Nyem ib zaug ntawm daim duab ncuav qab zib kom pom tag nrho cov ncuav qab zib, tom qab ntawd nyem rau ntawm "ib qho" ntawm lub ncuav qab zib kom pom qhov ntawd.
  3. Txhawm rau hloov cov xim ntawm daim ntawv ntawd, nyem rau ntawm qhov nco cia nyob ib sab ntawm lo lus "Sau", tom qab ntawd xaiv xim.
  4. Rov ua cov kauj ruam 2 thiab 3 rau txhua daim ncuav qab zib.

Rau Windows:

  1. Nyem rau ntawm "Format" tab sab xis ntawm "Tsim" tab.
  2. Ob npaug nyem rau ntawm ib feem ntawm kab lus koj xav hloov.
  3. Xaiv "Hom Sau" nyob rau sab saum toj-nruab nrab-sab xis thiab xaiv cov xim uas xav tau
  4. Rov ua cov kauj ruam 2 thiab 3 rau txhua daim ncuav qab zib

Kauj Ruam 6: Txuag Daim Duab

Txuag Daim Duab
Txuag Daim Duab
Txuag Daim Duab
Txuag Daim Duab
Txuag Daim Duab
Txuag Daim Duab

OS X:

  1. Txoj cai nyem (lossis ob-ntiv tes nyem) nyob qhov twg nyob hauv ib thaj tsam ntawm kab kos.
  2. Xaiv "Txuag raws li Duab" los ntawm cov ntawv qhia zaub mov uas tshwm.
  3. Txuag daim duab ua duab rau koj lub khoos phis tawj rau luam ntawv, xa email, xa tawm, thiab lwm yam.

Rau Windows:

  1. Txoj cai nyem qhov twg nyob hauv thaj tsam ntawm kab ntawv.
  2. Xaiv "Txuag raws li tus qauv" los ntawm cov ntawv qhia zaub mov nco uas tshwm
  3. Xaiv qhov chaw koj xav txuag lub teeb.

Pom zoo: