Yuav Ua Li Cas Tsim Daim Duab Ncuav Qab Zib hauv Excel: 11 Kauj Ruam (nrog Duab)

Yuav Ua Li Cas Tsim Daim Duab Ncuav Qab Zib hauv Excel: 11 Kauj Ruam (nrog Duab)
Yuav Ua Li Cas Tsim Daim Duab Ncuav Qab Zib hauv Excel: 11 Kauj Ruam (nrog Duab)
Anonim

Daim ntawv qhia ncuav qab zib yog daim ntawv qhia raws cov lej lej uas qhia txog feem pua ​​feem pua. Tom qab ua qhov yooj yim>

Kauj Ruam 1. Qhib Microsoft Excel daim ntawv nthuav tawm

Sau koj cov ntaub ntawv uas koj xav siv los tsim daim ntawv qhia ncuav qab zib.

Kauj Ruam 2. Tsim cov ntaub ntawv yooj yim

Daim ntawv qhia ncuav qab zib tsuas yog siv nrog cov ntawv yooj yim ntawm cov ntaub ntawv ntawm cov ncauj lus tshwj xeeb.

Piv txwv li, koj tuaj yeem siv daim ntawv qhia ncuav qab zib txhawm rau taug qab lub sijhawm koj siv hauv koj cov dej num niaj hnub. Cov kab ntawv ntawm cov ntaub ntawv yuav tshwm nyob rau hauv kab ntawv nrog cov npe ntawm cov dej num, thiab lwm kab ntawv yuav qhia tus naj npawb feeb/teev uas koj tau siv rau nws ib hnub. Koj tuaj yeem siv qhov no hauv kev lag luam teeb tsa txhawm rau nrhiav kev faib ua feem ntawm koj lub zog muag lossis cov nyiaj hauv internet uas koj tau txais los ntawm ib qho chaw tshwj xeeb

Kauj Ruam 3. Khaws ib qho kev hloov pauv uas koj tau ua rau daim ntawv ua ntej mus txuas ntxiv

Ntu 2 ntawm 3: Xaiv cov ntaub ntawv

Kauj Ruam 1. Xaiv cov ntaub ntawv koj xav siv hauv daim ntawv qhia ncuav qab zib

Siv koj tus nas cursor los xaiv txhua kab los siv. Ua kom ntseeg tau tias txhua cov ntaub ntawv sib txuas ua ke.

Nco ntsoov suav nrog cov npe ntawm pawg hauv kev xaiv. Piv txwv li, yog tias muaj lub npe nyob rau sab saum toj ntawm kab ntawv xws li "Cov Neeg Muag Khoom" thiab kab ntawv tom ntej muaj npe "Tus lej Muag Khoom", koj yuav tsum suav nrog cov ntaub ntawv no ib yam kom cov kws tsim kab ntawv siv tag nrho cov ntaub ntawv raug. paub

Kauj Ruam 2. Nyem "Insert" ntawm cov ntawv qhia zaub mov tseem ceeb

Xaiv "Graphs" los ntawm cov npe xaiv.

Kauj Ruam 3. Xaiv hom kab ntawv ncuav qab zib uas koj xav tsim

Cov kev xaiv suav nrog daim ntawv ncuav qab zib tsis tu ncua, ncuav qab zib 3D, lossis daim ntawv qhia ncuav qab zib nrog ntu tshwj xeeb, daim ntawv ncuav qab zib ntawm daim ncuav qab zib, lossis daim ntawv qhia zaub mov bar-ntawm-ncuav qab zib, qhov twg ib feem ntawm daim duab ncuav qab zib tau nthuav tawm ntau dua.

Nyem rau qhov saib ua ntej kom pom tias txhua daim duab ncuav qab zib yuav zoo li cas

Kauj Ruam 4. Nias lub pob "Tom ntej" thaum koj tau xaiv hom kab ntawv uas koj xav tau

Tom qab ntawd, koj tuaj yeem hloov kho daim ntawv qhia ncuav qab zib los ntawm "Chart Wizard."

Ntu 3 ntawm 3: Tus Pab Cuam Daim Duab

Kauj Ruam 1. Saib ua ntej koj daim ntawv qhia ncuav qab zib hauv qhov "Chart Source Data" window

Txheeb ob zaug seb qhov kev xaiv tau raug. Qhia seb seb cov ntaub ntawv nyob hauv kab lossis kab. Yog tias koj muaj cov ntaub ntawv hauv kab, nyem rau ntawm "Kab".

Kauj Ruam 2. Nyem "Tom ntej" mus rau qhov "Chart Options" screen

  • Xaiv lub "Title" tab los tsim lub npe rau koj daim ntawv qhia ncuav qab zib.
  • Xaiv lub "Data Labels" tab los xaiv txoj hauv kev uas koj cov ntaub ntawv nthuav tawm. Piv txwv li, koj tuaj yeem xaiv los ntawm "Pawg Npe" thiab "Feem pua" los qhia koj cov ntaub ntawv hauv daim ntawv qhia ncuav qab zib.

Kauj Ruam 3. Nyem "Ua tiav" thaum koj ua tiav

Tam sim no koj daim ntawv yuav tshwm nyob rau hauv daim ntawv Excel.

Kauj Ruam 4. Luam cov ntawv los ntawm txhaj "Kho" thiab "Luam" thaum tag nrho daim duab tau xaiv

Tam sim no muab qhov no tso rau hauv daim ntawv tshaj tawm, Cov ntawv Word lossis nthuav qhia PowerPoint, txhawm rau txhawb koj cov ntaub ntawv.

Nrov los ntawm cov ncauj lus