Txoj hauv kev yooj yim los hloov Cov Qauv ntawm Daim Duab hauv Excel ntawm PC lossis Mac

Cov txheej txheem:

Txoj hauv kev yooj yim los hloov Cov Qauv ntawm Daim Duab hauv Excel ntawm PC lossis Mac
Txoj hauv kev yooj yim los hloov Cov Qauv ntawm Daim Duab hauv Excel ntawm PC lossis Mac

Video: Txoj hauv kev yooj yim los hloov Cov Qauv ntawm Daim Duab hauv Excel ntawm PC lossis Mac

Video: Txoj hauv kev yooj yim los hloov Cov Qauv ntawm Daim Duab hauv Excel ntawm PC lossis Mac
Video: Lig Pob tsuas xyooj nkauj tawm tshiab 2022-2023 2024, Tej zaum
Anonim

Qhov wikiHow no qhia koj li cas los xaiv tus qauv tsim, xim palette, thiab hom ntawv rau kab ntawv qhia hauv Microsoft Excel daim ntawv nthuav qhia, siv lub computer.

Cov kauj ruam

Txoj Kev 1 ntawm 2: Siv Mac

Hloov Cov Qauv Ntawm Daim Duab hauv Excel ntawm PC lossis Mac Kauj Ruam 1
Hloov Cov Qauv Ntawm Daim Duab hauv Excel ntawm PC lossis Mac Kauj Ruam 1

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

Ob npaug nias rau lub cim cov ntawv kom qhib nws hauv Microsoft Excel.

Hloov Cov Qauv Ntawm Daim Duab hauv Excel ntawm PC lossis Mac Kauj Ruam 2
Hloov Cov Qauv Ntawm Daim Duab hauv Excel ntawm PC lossis Mac Kauj Ruam 2

Kauj Ruam 2. Nyem rau kab ntawv uas koj xav kho

Daim Ntawv Tsim thiab Qauv tabs yuav tshwm nyob rau sab saum toj ntawm kab ntawv toolbar nyob rau saum toj.

Hloov Cov Qauv ntawm Daim Duab hauv Excel ntawm PC lossis Mac Kauj Ruam 3
Hloov Cov Qauv ntawm Daim Duab hauv Excel ntawm PC lossis Mac Kauj Ruam 3

Kauj Ruam 3. Nyem rau Chart Design tab nyob rau saum toj

Qhov no yuav qhib cov cuab yeej tsim qauv uas koj tuaj yeem siv los ua kom haum koj daim duab.

Hloov Cov Qauv Ntawm Daim Duab hauv Excel ntawm PC lossis Mac Kauj Ruam 4
Hloov Cov Qauv Ntawm Daim Duab hauv Excel ntawm PC lossis Mac Kauj Ruam 4

Kauj Ruam 4. Xaiv daim duab qhia chaw ntawm Daim Qauv Tsim Kab

Koj yuav pom cov npe ntawm cov qauv tsim uas koj tuaj yeem siv hauv koj hom kab ntawv xaiv. Nyem rau ib qho twg ntawm no txhawm rau siv nws rau koj daim ntawv.

Hloov Cov Qauv Ntawm Daim Duab hauv Excel ntawm PC lossis Mac Kauj Ruam 5
Hloov Cov Qauv Ntawm Daim Duab hauv Excel ntawm PC lossis Mac Kauj Ruam 5

Kauj Ruam 5. Nyem rau Hloov Cov Xim khawm

Nws yog nyob rau sab laug ntawm cov npe cov npe ntawm cov cuab yeej ribbon nyob ze ntawm lub ces kaum sab saud.

Hloov Cov Qauv Ntawm Daim Duab hauv Excel ntawm PC lossis Mac Kauj Ruam 6
Hloov Cov Qauv Ntawm Daim Duab hauv Excel ntawm PC lossis Mac Kauj Ruam 6

Kauj Ruam 6. Xaiv lub palette xim rau koj daim duab

Koj tuaj yeem xaiv cov xim muaj xim lossis xim sib txawv xim rau koj daim duab ntawm no.

Hloov Cov Qauv Ntawm Daim Duab hauv Excel ntawm PC lossis Mac Kauj Ruam 7
Hloov Cov Qauv Ntawm Daim Duab hauv Excel ntawm PC lossis Mac Kauj Ruam 7

Kauj Ruam 7. Nyem rau Change Change Chart Type khawm

Koj tuaj yeem pom nws nyob ze rau sab xis-sab xis ntawm Chart Design toolbar. Nws yuav qhib ib daim ntawv teev npe ntawm cov ntawv teev hom.

  • Qhov no yuav tso cai rau koj hloov koj daim ntawv rau hauv lwm hom ntawv.
  • Piv txwv li, yog tias koj tab tom kho kab ntawv teeb tsa ua pawg, koj tuaj yeem hloov nws mus rau hauv kab ntawv 3D stacked bar chart, kab ntawv ua pawg, lossis daim duab ncuav qab zib.
Hloov Cov Qauv Ntawm Daim Duab hauv Excel ntawm PC lossis Mac Kauj Ruam 8
Hloov Cov Qauv Ntawm Daim Duab hauv Excel ntawm PC lossis Mac Kauj Ruam 8

Kauj Ruam 8. Hover hla ib qho ntawm kab ntawv hom pawg

Qhov no yuav qhia cov hom phiaj uas koj tuaj yeem siv hauv pawg no.

Hloov Cov Qauv Ntawm Daim Duab hauv Excel ntawm PC lossis Mac Kauj Ruam 9
Hloov Cov Qauv Ntawm Daim Duab hauv Excel ntawm PC lossis Mac Kauj Ruam 9

Kauj Ruam 9. Xaiv hom kab ntawv uas koj xav siv

Qhov no yuav hloov koj daim ntawv rau hauv hom kab ntawv xaiv.

Koj tseem tuaj yeem hloov kho koj daim duab style thiab xim ntawm kab ntawv toolbar

Txoj Kev 2 ntawm 2: Siv Windows

Hloov Cov Qauv Ntawm Daim Duab hauv Excel ntawm PC lossis Mac Kauj Ruam 10
Hloov Cov Qauv Ntawm Daim Duab hauv Excel ntawm PC lossis Mac Kauj Ruam 10

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

Ob npaug nias rau lub cim cov ntawv kom qhib nws hauv Microsoft Excel.

Hloov Cov Qauv Ntawm Daim Duab hauv Excel ntawm PC lossis Mac Kauj Ruam 11
Hloov Cov Qauv Ntawm Daim Duab hauv Excel ntawm PC lossis Mac Kauj Ruam 11

Kauj Ruam 2. Nyem rau kab ntawv uas koj xav kho

Tsim thiab Hom tabs yuav tshwm nyob rau sab saum toj ntawm kab ntawv toolbar nyob rau saum toj.

Hloov Cov Qauv Ntawm Daim Duab hauv Excel ntawm PC lossis Mac Kauj Ruam 12
Hloov Cov Qauv Ntawm Daim Duab hauv Excel ntawm PC lossis Mac Kauj Ruam 12

Kauj Ruam 3. Nyem rau daim duab xim txhuam ntawm ib sab ntawm daim duab uas tau xaiv

Nws nyob ze rau sab xis-sab xis ntawm daim duab. Qhov no yuav qhib koj cov kev xaiv hauv lub qhov rai pop-up.

Hloov Cov Qauv Ntawm Daim Duab hauv Excel ntawm PC lossis Mac Kauj Ruam 13
Hloov Cov Qauv Ntawm Daim Duab hauv Excel ntawm PC lossis Mac Kauj Ruam 13

Kauj Ruam 4. Xaiv daim duab qhia chaw hauv Style Pop-up

Nyem ib yam ntawm cov qauv ntawm no txhawm rau siv nws rau koj daim ntawv.

Hloov Cov Qauv Ntawm Daim Duab hauv Excel ntawm PC lossis Mac Kauj Ruam 14
Hloov Cov Qauv Ntawm Daim Duab hauv Excel ntawm PC lossis Mac Kauj Ruam 14

Kauj Ruam 5. Nyem rau Xim tab

Koj tuaj yeem pom nws nyob ib sab Style saum lub qhov rooj txhuam xim Nws yuav qhib cov npe ntawm cov xim palettes uas koj tuaj yeem siv.

Hloov Cov Qauv Ntawm Daim Duab hauv Excel ntawm PC lossis Mac Kauj Ruam 15
Hloov Cov Qauv Ntawm Daim Duab hauv Excel ntawm PC lossis Mac Kauj Ruam 15

Kauj Ruam 6. Xaiv lub palette xim los siv hauv koj daim duab

Koj tuaj yeem siv cov xim muaj xim lossis xim monochromatic.

Hloov Cov Qauv Ntawm Daim Duab hauv Excel ntawm PC lossis Mac Kauj Ruam 16
Hloov Cov Qauv Ntawm Daim Duab hauv Excel ntawm PC lossis Mac Kauj Ruam 16

Kauj Ruam 7. Nyem Hloov Daim Qauv Hom ntawm kab ntawv toolbar

Koj tuaj yeem pom nws nyob ze rau sab xis-sab xis ntawm koj lub vijtsam. Nws yuav qhib qhov tshiab pop-up window.

  • Qhov no yuav tso cai rau koj hloov koj daim ntawv rau hauv lwm hom ntawv.
  • Piv txwv li, yog tias koj tab tom kho daim duab ncuav qab zib 3D, koj tuaj yeem hloov nws mus rau hauv cov khoom qab zib, cov phiaj xwm tawg, lossis daim phiaj kab.
Hloov Cov Qauv Ntawm Daim Duab hauv Excel ntawm PC lossis Mac Kauj Ruam 17
Hloov Cov Qauv Ntawm Daim Duab hauv Excel ntawm PC lossis Mac Kauj Ruam 17

Kauj Ruam 8. Xaiv kab ntawv hom qeb ntawm sab laug

Qhov no yuav qhia cov hom phiaj uas koj tuaj yeem siv hauv pawg no.

Hloov Cov Qauv Ntawm Daim Duab hauv Excel ntawm PC lossis Mac Kauj Ruam 18
Hloov Cov Qauv Ntawm Daim Duab hauv Excel ntawm PC lossis Mac Kauj Ruam 18

Kauj Ruam 9. Xaiv hom kab ntawv uas koj xav siv

Qhov no yuav hloov koj daim ntawv qub rau hauv hom kab ntawv xaiv.

Nyem OK los siv hom xaiv rau koj daim duab.

Pom zoo: