txheem
New Chart Wizard
Cov txheej txheem tsim cov kab kos rau ib qho kev xaiv ntawm cov hlwb tam sim no tau yooj yim ua tsaug rau lub thawv tshiab nrog kev saib ua ntej ntawm daim ntawv tiav (ob qho kev xaiv ib zaug - los ntawm kab thiab kab):
Cov kab kos ua ke uas muaj ob lossis peb hom sib xyaw (histogram-plot-nrog thaj chaw, thiab lwm yam) tam sim no muab tso rau hauv ib qho chaw sib cais thiab yooj yim heev teeb tsa tam sim ntawd hauv Wizard qhov rai:
Tsis tas li tam sim no nyob rau hauv daim ntawv qhia qhov rais muaj ib tab Daim duab pom zoo (Cov kab ntawv pom zoo), qhov twg Excel yuav qhia cov kab ntawv uas tsim nyog tshaj plaws raws li hom koj cov ntaub ntawv thawj zaug:
Cov tswv yim, kuv yuav tsum hais, muaj peev xwm heev. Nyob rau hauv cov teeb meem nyuaj, nws txawm hais tias siv lub thib ob axis nrog nws tus kheej scale (rubles-feem pua), thiab lwm yam. Tsis phem.
Customizing kab kos
Txhawm rau txhim kho tag nrho cov txheej txheem yooj yim ntawm ib daim ntawv qhia, koj tuaj yeem siv peb lub pob tseem ceeb uas tshwm rau sab xis ntawm daim ntawv xaiv:
- Daim ntawv qhia (Khoom Elements) - tso cai rau koj kom sai ntxiv thiab kho cov kab kos (cov npe, axes, kab sib chaws, cov ntawv sau, thiab lwm yam)
- Daim duab style (Khoom Styles) - tso cai rau tus neeg siv xaiv qhov tsim thiab xim palette ntawm daim duab los ntawm kev sau
- Daim ntawv lim (Tshooj Lim) - tso cai rau koj lim cov ntaub ntawv rau daim ntawv qhia ya, tawm tsuas yog cov koob tsim nyog thiab pawg hauv nws
Txhua yam yog yooj yim nthuav tawm nyob rau hauv daim ntawv ntawm ntau theem hierarchical menus, txhawb on-the-fly saib ua ntej thiab ua haujlwm sai thiab yooj yim:
Yog tias, txawm li cas los xij, qhov kev hloov kho tshiab no tsis yog rau koj nyiam, ces koj tuaj yeem mus rau txoj hauv kev classic - tag nrho cov haujlwm yooj yim rau kev hloov kho cov duab ntawm daim ntawv kuj tuaj yeem ua tau siv cov tabs. constructor (Tsim) и moj khaum (Hom ntawv). Thiab ntawm no yog cov tabs Layout (Layout), qhov twg feem ntau cov kev xaiv tau teeb tsa hauv Excel 2007/2010, tsis muaj lawm.
Task pane es tsis txhob dialog boxes
Kev kho kom zoo ntawm tus qauv tsim ntawm txhua daim ntawv qhia tam sim no yooj yim heev ua tiav siv lub vaj huam sib luag tshwj xeeb ntawm sab xis ntawm Excel 2013 qhov rais - ib txoj haujlwm pane uas hloov cov ntawv sib tham classic. Txhawm rau tso saib lub vaj huam sib luag no, nyem rau ntawm txhua daim ntawv qhia thiab xaiv cov lus txib moj khaum (Hom ntawv) lossis nias lub keyboard shortcut CTRL + 1 lossis ob-nias nrog sab laug:
Daim ntawv teev cov ntaub ntawv
Thaum ntxiv cov ntawv sau rau cov ntsiab lus ntawm cov kab kos, nws yog tam sim no tuaj yeem npaj lawv hauv callouts cia li snapped rau cov ntsiab lus:
Yav dhau los, xws li callouts yuav tsum tau kos manually (uas yog, tsuas yog ntxig raws li cov khoom siv duab sib cais) thiab, tau kawg, tsis muaj lus nug txog kev khi rau cov ntaub ntawv.
Daim ntawv lo rau cov ntsiab lus ntawm cov hlwb
Kuv tsis ntseeg kuv qhov muag! Thaum kawg, kev npau suav ntawm ntau tus neeg siv tau ua tiav, thiab cov neeg tsim khoom tau ua raws li qhov xav tau ntawm lawv yuav luag 10 xyoo - tam sim no koj tuaj yeem nqa cov ntaub ntawv rau cov ntsiab lus ntawm cov kab kos ncaj qha los ntawm daim ntawv los ntawm kev xaiv cov kev xaiv hauv lub luag haujlwm pane Cov nqi ntawm cov hlwb (Tus nqi ntawm Cells) thiab qhia ntau yam ntawm cov hlwb nrog cov cim cim:
Cov ntawv sau rau npuas thiab cov kab kos tawg, cov ntawv tsis yog cov qauv tsis muaj teeb meem ntxiv lawm! Dab tsi siv los ua tau manually nkaus xwb (sim ntxiv cov ntawv rau tsib caug ntsiab lus ntawm tes!) lossis siv cov macros tshwj xeeb / add-ons (XYChartLabeler, thiab lwm yam), tam sim no yog tus qauv Excel 2013 muaj nuj nqi.
Daim duab Animation
Qhov kev qhia tshiab no hauv Excel 2013, txawm tias tsis yog ib qho tseem ceeb, tseem yuav ntxiv qee qhov mojo rau koj cov lus ceeb toom. Tam sim no, thaum hloov cov ntaub ntawv hauv qhov chaw (manually lossis los ntawm kev suav cov qauv), daim duab yuav zoo "ntws" mus rau hauv lub xeev tshiab, pom qhov kev hloov pauv uas tau tshwm sim:
Trifle, tab sis zoo.
- Dab tsi tshiab hauv Excel 2013 PivotTables