Yog tias koj xav tau ib daim phiaj los yog maj nrawm koj tsuas xav saib xyuas tej yam tseem ceeb hauv koj cov ntaub ntawv , koj tuaj yeem tsim ib daim ntawv teev lus qhia hauv Excel nrog ib zaug.
Ib qho ntawm Excel's lesser-paub daim nta daim ntawv yog tias qhov kev zov me nyuam muaj ib qho qauv ntawv pov thawj uas tau muab qhib siv cov keyboard shortcut hauv lub lag luam.
Daim ntawv pov thawj no tso cai rau cov neeg siv ceev xwm txheej ntxiv uas siv rau daim ntawv ua haujlwm tam sim no los ntxiv rau ib daim ntawv rau ib daim ntawv ua haujlwm rau hauv phau ntawv no .
Ob kauj ruam ua qhov no yog:
- Xaiv cov ntaub ntawv koj xav siv hauv daim phiaj qhia
- Nias lub khawm F11 ntawm tus keyboard
Ib daim ntawv uas siv tag nrho cov chaw siv tam sim no yog tsim thiab ntxiv rau ib daim ntawv ua haujlwm nyob rau hauv phau ntawv ua haujlwm tam sim no.
Yog tias lub Hoobkas kev hloov tsis tau hloov, daim ntawv qhia ua los ntawm nias F11 yog ib daim ntawv qhia kab ntawv .
01 ntawm 04
Muab Daim Ntawv Qhia Taus Tawm Sab Nraud rau Daim Ntawv Xaus Taus nrog F + +
Raws li tau ntxiv ib daim qauv ntawm cov qauv ntawv pov thawj rau ib daim ntawv khom nqi cais, tib daim ntawv qhia tau muab ntxiv rau daim ntawv teev npe tam sim no - daim ntawv khomob nyob qhov twg cov ntaub ntawv qhia nyob hauv - los ntawm kev siv cov thaub qab keyboard txawv.
- Xaiv cov ntaub ntawv koj xav siv hauv daim ntawv qhia;
- Nias thiab tuav lub pob hauv qab ntawm cov keyboard;
- Nias thiab tso tus yuam sij F1 ntawm cov keyboard;
- Cov ntawv cim tseg yog ntxiv rau daim ntawv sau npe tam sim no.
02 ntawm 04
Hloov Piv Txwv Cov Qauv Ntsuam Phoo Ntawv
Yog hais tias nias F11 lossis Alt + F1 ua ib daim duab uas tsis yog rau koj lub siab nyiam, koj yuav tsum hloov pauv cov qauv ntawv pov thawj.
Ib qho qauv tshiab daim ntawv xaiv yuav tsum raug xaiv los ntawm cov kev cai ceev ntu hauv Excel uas tuas tsuas yog cov qauv uas koj tau tsim.
Qhov yoojyim tshaj los hloov cov qauv ntawv qhia hauv Excel yog:
- Txoj cai nias ntawm ib daim qauv uas twb muaj lawm los qhib cov ntsiab lus teb cov ntsiab lus teb;
- Xaiv Chart Hloov hom ntawm lub ntsiab lus teb los qhib lub Chart Hom dialog box ;
- Nias ntawm Templates nyob rau sab laug tes pane ntawm lub thawv ntawv;
- Txoj cai nias ntawm ib qho piv txwv nyob rau hauv sab tes xis Kuv Cov Ntawv Xov Xwm (Templates) ;
- Xaiv "Teeb raws li daim ntawv pov thawj" hauv cov ntawv qhia zaub mov.
03 ntawm 04
Tsim thiab Saving Chart Templates
Yog tias koj tseem tsis tau tsim ib qho qauv uas siv tau los ua cov qauv ntawv pov thawj, qhov yoojyim tshaj plaws los ua qhov no yog:
- Hloov cov qauv uas twb muaj lawm kom tag nrho cov kev xaiv formatting - xws li tom qab xim, X thiab Y nplai nqis, thiab hom font - rau tus tshiab template;
- Txoj cai nias ntawm daim chart;
- Xaiv "Txuag Li Template ..." los ntawm cov ntawv qhia zaub mov raws li qhia nyob rau hauv daim duab saum toj no, qhib Chart Template Template dialog box;
- Lub npe tus qauv;
- Nias lub khawm kom txuag tau lub template thiab kaw lub thawv ntawv.
Lus Cim: Cov ntaub ntawv khaws tseg ua ib daim ntawv .crtx rau qhov chaw hauv qab no:
C: \ Cov ntaub ntawv thiab chaw \ username \ AppData \ Roaming \ Microsoft \ Templates \ Kab kos
04 ntawm 04
Muab cov qauv ntawv pov thawj
Qhov yoojyim txoj kev rho tawm cov qauv kev cai nyob hauv Excel yog:
- Txoj cai-nias ntawm ib daim ntawv uas twb muaj lawm los qhib cov ntsiab lus teb-Right-click menu;
- Xaiv "Change Chart Type" los ntawm lub ntsiab lus teb los qhib lub Chart Hom dialog box;
- Nias ntawm Templates nyob rau sab laug tes pane ntawm lub thawv ntawv;
- Nias ntawm Tswj Tus Qauv Tswj rau hauv qab ntawm sab laug hauv qab ntawm lub thawv ntawv qhib qhib daim nplaub tshev daim nplaub tshev;
- Txoj cai-nias rau ntawm lub template yuav tsum tau deleted thiab xaiv rho tawm hauv lub ntsiab lus teb ntawv qhia zaub mov - qhov rho tawm cov ntaub ntawv dialog box yuav qhib nug koj kom paub meej tias cov ntaub ntawv deletion;
- Nias qhov muaj nyob rau hauv lub thawv dialog kom rho tawm cov template thiab kaw lub thawv ntawv.