Yuav ua li cas tig cov kab kos hauv Excel

Kab lus no tham txog yuav ua li cas tig daim ntawv qhia hauv Excel 2010-2013. Koj yuav kawm ntau txoj hauv kev los tig bar, bar, ncuav qab zib thiab kab kab kos, suav nrog lawv cov 3D versions. Koj tseem yuav pom yuav ua li cas hloov qhov kev txiav txim tsim ntawm qhov tseem ceeb, pawg, series, thiab lus dab neeg. Rau cov neeg uas nquag luam graphs thiab kab kos, kawm yuav ua li cas los teeb tsa cov ntawv taw qhia rau kev luam ntawv.

Excel ua rau nws yooj yim heev los nthuav qhia lub rooj ua ib daim duab lossis duab. Txhawm rau ua qhov no, tsuas yog xaiv cov ntaub ntawv thiab nyem rau ntawm lub cim ntawm hom kab ntawv tsim nyog. Txawm li cas los xij, qhov kev teeb tsa ua ntej yuav tsis haum. Yog tias koj xav tig daim ntawv qhia hauv Excel los npaj cov ncuav qab zib, kab, lossis kab sib txawv, ces kab lus no yog rau koj.

• Tig ib daim ntawv qhia ncuav qab zib hauv Excel rau lub kaum sab xis uas xav tau
• Rotate 3D Graphs hauv Excel: Rotate Pie, Bar thiab Bar Kab kos
• Tig ib Daim Ntawv Qhia 180 °: Rov ua cov pawg, cov nqi, thiab cov ntaub ntawv Series
  
  • Hloov Cov Kev Txiav Txim ntawm Cov Tsev Hauv Ib Daim Ntawv Qhia Excel
  • Hloov qhov kev txiav txim ntawm lub tsev muaj nqis
  • Reversing qhov kev txiav txim ntawm plotting cov ntaub ntawv series ntawm ib daim ntawv 3D
  • Hloov txoj haujlwm ntawm cov lus dab neeg ntawm daim duab
• Hloov daim ntawv taw qhia kom zoo dua daim duab
• Siv Lub Koob Yees Duab los tig daim ntawv Excel rau lub kaum sab xis

Tig ib daim ntawv qhia ncuav qab zib hauv Excel rau lub kaum sab xis uas xav tau

Yog tias koj feem ntau xav tau qhia qhov sib txawv ntawm qhov sib npaug, ces nws yog qhov zoo dua los siv cov kab kos duab. Hauv daim duab hauv qab no, cov ntawv sau cov ntaub ntawv sib tshooj cov npe, yog li daim duab zoo li shabby. Kuv xav luam daim ntawv qhia no rau hauv PowerPoint kev nthuav qhia txog kev ua noj ua haus ntawm cov neeg, thiab kuv xav tau daim ntawv qhia kom zoo. Txhawm rau kom ua tiav txoj haujlwm thiab hais txog qhov tseem ceeb tshaj plaws, koj yuav tsum paub yuav ua li cas tig lub ncuav qab zib hauv Excel clockwise.

1. Txoj cai-nias ntawm txhua ntu ntawm koj daim ntawv qhia ncuav qab zib thiab los ntawm cov ntawv qhia zaub mov uas tshwm, xaiv Cov ntaub ntawv series (Format Data Series).
2. Lub vaj huam sib luag ntawm tib lub npe yuav tshwm sim. Hauv teb Kev sib hloov lub kaum sab xis ntawm thawj sector (Lub kaum sab xis ntawm thawj daim), tsis yog xoom, nkag mus rau tus nqi ntawm lub kaum sab xis ntawm kev sib hloov hauv degrees thiab nias Sau. Kuv xav tias 190 degree rotation yuav ua rau kuv daim ntawv ncuav qab zib.

Tom qab kev sib hloov, daim ntawv ncuav qab zib hauv Excel zoo li zoo nkauj heev:

Yog li, nws tsis yooj yim rau tig daim ntawv Excel rau txhua lub kaum sab xis kom muab nws qhov xav tau. Txoj hauv kev no muaj txiaj ntsig ob qho tib si rau kev kho kom zoo ntawm qhov chaw ntawm cov ntaub ntawv sau npe thiab rau qhov tseem ceeb ntawm cov haujlwm tseem ceeb tshaj plaws.

Rotate 3D Graphs hauv Excel: Rotate Pie, Bar thiab Bar Kab kos

Kuv xav tias 3D kab kos saib zoo heev. Thaum qee tus neeg pom daim duab XNUMXD, lawv paub tseeb tias nws tus tsim paub txhua yam txog kev pom hauv Excel. Yog tias daim duab tsim nrog lub neej ntawd teeb tsa tsis zoo li qhov koj xav tau, koj tuaj yeem kho nws los ntawm kev tig thiab hloov qhov kev xav pom.

1. Right-click rau ntawm daim ntawv thiab xaiv los ntawm cov ntawv qhia zaub mov uas tshwm. XNUMXD Kev sib hloov (3-D tig).
2. Ib lub vaj huam sib luag yuav tshwm sim Daim duab Area Format (Format Chart Area). Mus rau hauv teb Kev sib hloov nyob ib ncig ntawm X axis (X Rotation) thiab Kev sib hloov nyob ib ncig ntawm Y axis (Y Kev Sib Hloov) Nkag mus rau tus lej xav tau ntawm qib kom tig.Kuv teeb qhov tseem ceeb rau 40 ° thiab 35 ° raws li muab kuv cov phiaj xwm qhov tob.

Koj tuaj yeem tsim cov kev xaiv hauv lub vaj huam sib luag no. qhov tob (Qhov tob), Qhov siab (Qhov siab) thiab Pem taub (Kev xav). Sim nrhiav qhov chaw zoo tshaj plaws rau koj daim ntawv qhia. Ib yam li ntawd, koj tuaj yeem teeb lub ncuav qab zib.

Tig ib daim duab 180°: Rov ua cov pawg, cov nqi, lossis cov ntaub ntawv Series

Yog tias daim ntawv koj xav tig hauv Excel qhia ob kab rov tav thiab ntsug axes, koj tuaj yeem hloov qhov kev txiav txim ntawm pawg lossis cov txiaj ntsig tau yooj yim raws li cov axes. Tsis tas li ntawd, hauv 3D cov phiaj xwm uas muaj qhov tob axis, koj tuaj yeem hloov qhov kev txiav txim uas cov ntaub ntawv series tau npaj kom loj 3D tuav tsis sib tshooj me me. Hauv Excel, koj tuaj yeem hloov txoj haujlwm ntawm cov lus dab neeg ntawm daim ntawv ncuav qab zib lossis daim ntawv qhia bar.

Hloov qhov kev txiav txim ntawm lub tsev pawg hauv daim duab

Daim ntawv tuaj yeem tig tau ntawm kab rov tav axis (qeb axis).

1. Txoj cai-nias ntawm kab rov tav axis thiab los ntawm cov ntawv qhia zaub mov uas zoo li xaiv Axis Format (Format Axis).
2. Lub vaj huam sib luag ntawm tib lub npe yuav tshwm sim. Txhawm rau tig daim duab 180 °, tsuas yog khij lub npov Rov qab kev txiav txim ntawm pawg (Categories nyob rau hauv reverse order).

Hloov qhov kev txiav txim ntawm plotting qhov tseem ceeb hauv ib daim duab

Los ntawm kev ua raws li cov kauj ruam yooj yim no, koj tuaj yeem tig daim duab nyob ib ncig ntawm txoj kab ntsug.

1. Txoj nyem rau ntawm txoj kab ntsug (tus nqi axis) thiab xaiv Axis Format (Format Axis).
2. Xaiv lub thawv Rov qab txiav txim ntawm qhov muaj nuj nqis (Tus nqi hauv qhov kev txiav txim rov qab).

Nco ntsoov: Nco ntsoov tias nws tsis tuaj yeem hloov qhov kev txiav txim uas muaj nuj nqis tau npaj rau hauv daim duab radar.

Reversing qhov kev txiav txim ntawm plotting cov ntaub ntawv series nyob rau hauv ib daim ntawv 3D

Yog tias koj daim ntawv bar lossis daim ntawv qhia bar muaj qhov thib peb axis, nrog qee qhov ntawm cov tuav hauv pem hauv ntej thiab tom qab, koj tuaj yeem hloov qhov kev txiav txim uas cov ntaub ntawv series tau npaj kom cov ntsiab lus 3D loj dua tsis sib tshooj me dua. Siv cov kauj ruam hauv qab no, ob lossis ntau lub phiaj xwm tuaj yeem npaj los qhia tag nrho cov koob los ntawm cov lus dab neeg.

1. Txoj cai-nias ntawm tus nqi series axis (Z-axis) hauv daim ntawv thiab hauv cov ntawv qhia zaub mov uas tshwm, nyem Axis Format (Format Axis).
2. Xaiv lub thawv Rov qab txiav txim ntawm qhov muaj nuj nqis (Series nyob rau hauv qhov kev txiav txim rov qab) los qhia cov kab hauv kev rov qab.

Hloov txoj haujlwm ntawm cov lus dab neeg ntawm daim duab

Hauv Excel daim ntawv ncuav qab zib hauv qab no, cov lus dab neeg nyob hauv qab. Kuv xav txav cov lus dab neeg mus rau sab xis ntawm daim duab kom nws ua kom pom zoo dua.

1. Right-click rau cov lus dab neeg thiab hauv cov ntawv qhia zaub mov uas tshwm, nyem Lus dab neeg Format (Format Legend).
2. Hauv seem Cov lus dab neeg xaiv (Cov lus dab neeg xaiv) xaiv ib qho ntawm cov checkboxes: Los ntawm saum toj no (Sab saum toj), hauv qab (hauv qab), Sab laug (Sab laug), Ntawm sab xis (Txoj cai) los yog Sab saum toj txoj cai (Saum sab xis).

Tam sim no kuv nyiam kuv daim duab ntau dua.

Hloov daim ntawv taw qhia kom zoo dua daim duab

Yog tias koj tsuas yog xav tau luam ib daim ntawv, ces tsuas yog hloov daim ntawv qhia hauv Excel yam tsis tau hloov daim ntawv nws tus kheej. Daim duab hauv qab no qhia tau tias daim duab tsis haum rau ntawm nplooj ntawv. Los ntawm lub neej ntawd, cov ntawv ua haujlwm luam tawm hauv portrait orientation (siab dua qhov dav). Txhawm rau kom kuv daim duab saib zoo thaum luam tawm, kuv mam li hloov nplooj ntawv orientation ntawm portrait mus rau toj roob hauv pes.

1. Xaiv ib daim ntawv ua haujlwm nrog daim duab los luam.
2. nias lub Nplooj ntawv layout (Page Layout), nyem rau ntawm xub hauv qab lub pob orientation (Kev taw qhia) thiab xaiv qhov kev xaiv Toj roob hauv pes (Lus toj roob hauv pes).

Tam sim no nyob rau hauv lub qhov rais saib ua ntej, kuv tuaj yeem pom tias daim ntawv haum zoo kawg nkaus rau hauv qhov chaw luam tawm.

Siv Lub Koob Yees Duab los tig daim ntawv Excel rau lub kaum sab xis

Hauv Excel, koj tuaj yeem tig daim duab mus rau txhua lub kaum sab xis siv lub cuab yeej lub koob yees duab. Qhov tshwm sim ntawm kev ua haujlwm Cov koob yees duab tuaj yeem muab tso rau ntawm daim duab qub lossis ntawm daim ntawv tshiab.

Tswv yim: Yog tias koj xav tau tig daim ntawv qhia los ntawm 90 °, qee zaum nws txaus los hloov daim ntawv qhia hom. Piv txwv li, los ntawm daim ntawv qhia bar mus rau daim ntawv qhia bar.

Ntxiv ib lub cuab yeej lub koob yees duab ntawm Quick Access Toolbar, siv qhov me me cia xub nyob rau sab xis ntawm lub vaj huam sib luag. Hauv cov ntawv qhia zaub mov uas tshwm, nyem Lwm pab pawg (Ntau Commands).

xaiv lub koob yees duab (Lub koob yees duab) hauv daim ntawv teev npe Txhua pab pawg (Txhua cov lus txib) thiab nias Ntxiv (Ntxiv).

Tam sim no siv lub cuab yeej lub koob yees duab, ua raws cov theem hauv qab no.

Nco ntsoov: Thov nco ntsoov tias nws tsis tuaj yeem siv lub cuab yeej lub koob yees duab ncaj qha mus rau daim ntawv, raws li qhov tshwm sim tuaj yeem ua tsis tau.

1. Tsim ib daim duab lossis lwm daim duab.
2. Tej zaum nws yuav tsim nyog los tig txoj hauj lwm ntawm daim ntawv lo rau daim ntawv axes los ntawm 270 ° siv cov ntawv qhia zaub mov Axis Format (Format Axis), uas tau piav saum toj no. Qhov no yog qhov tsim nyog kom cov ntawv nyeem tuaj yeem nyeem tom qab daim ntawv hloov pauv.
3. Xaiv qhov ntau ntawm cov cell uas daim duab saum toj no.
4. Nyem rau lub cim lub koob yees duab (Lub koob yees duab) ntawm qhov Quick Access Toolbar.
5. Nyem rau ntawm ib lub xov tooj ntawm daim ntawv los tsim ib lub koob yees duab khoom.
6. Tam sim no nyem thiab tuav tus tuav kev sib hloov nyob rau sab saum toj ntawm daim duab uas tau tshwm sim.
7. Tig daim ntawv mus rau lub kaum sab xis uas xav tau thiab tso tawm qhov kev sib hloov.

Nco ntsoov: Hauv qhov ntsuas lub koob yees duab muaj ib tug drawback. Cov khoom tshwm sim tuaj yeem muaj qhov kev daws teeb meem qis dua li daim ntawv qub, thiab tej zaum yuav tshwm sim grainy los yog jagged.

Charting yog ib txoj hauv kev zoo los nthuav qhia cov ntaub ntawv. Graphs hauv Excel yog qhov yooj yim siv, nthuav tawm, pom, thiab tus qauv tsim tuaj yeem ua raws li qhov xav tau. Tam sim no koj paub yuav ua li cas tig histograms, kab thiab kab kos duab.

Tom qab sau tag nrho cov no, kuv xav tias zoo li ib tug guru tiag tiag nyob rau hauv daim ntawv qhia kev sib hloov. Kuv vam tias kuv tsab xov xwm yuav pab koj daws koj txoj haujlwm. Zoo siab thiab txhim kho koj txoj kev paub Excel!