Dab tsi tshwm sim rau Chart Wizard hauv Excel?

Chart Wizard raug tshem tawm ntawm Excel 2007 thiab tsis tau rov qab los rau tom qab versions. Qhov tseeb, tag nrho cov txheej txheem ntawm kev ua haujlwm nrog cov duab kos tau hloov pauv, thiab cov neeg tsim khoom tsis xav tias nws tsim nyog los hloov kho daim duab wizard thiab lwm yam cuab yeej.

Kuv yuav tsum hais tias cov txheej txheem tshiab rau kev ua haujlwm nrog cov kab kos tau sib sib zog nqus rau hauv qhov tshiab interface ntawm Menu Ribbon thiab nws yooj yim dua los ua haujlwm nrog ntau dua li tus wizard uas ua ntej nws. Kev teeb tsa yog intuitive thiab ntawm txhua kauj ruam koj tuaj yeem pom qhov saib ua ntej ntawm koj daim duab ua ntej hloov pauv.

Kev sib piv ntawm "Chart Wizard" thiab cov cuab yeej niaj hnub

Rau cov neeg siv rau daim duab wizard, peb xav hais tias thaum ua hauj lwm nrog Ribbon, tag nrho cov tib yam cuab yeej muaj, feem ntau nyob rau hauv tsis muaj ntau tshaj li ob peb nas clicks.

Hauv cov laus versions ntawm Excel, tom qab nyem rau ntawm cov ntawv qhia zaub mov Insert (Insert) > Daim duab (Chart) wizard qhia plaub lub thawv dialog hauv ib ntus:

  1. Hom kab kos. Ua ntej koj xaiv cov ntaub ntawv rau ib daim ntawv qhia, koj yuav tsum xaiv nws hom.
  2. Daim ntawv qhia qhov chaw. Xaiv cov hlwb uas muaj cov ntaub ntawv los npaj cov kab kos thiab qhia cov kab lossis kab uas yuav tsum tau pom raws li cov ntaub ntawv series ntawm daim duab.
  3. Daim ntawv xaiv. Customize formatting thiab lwm yam kev xaiv kab ntawv xws li cov ntaub ntawv sau npe thiab axes.
  4. Placement daim duab. Xaiv ib daim ntawv uas twb muaj lawm lossis tsim ib daim ntawv tshiab los tuav daim ntawv koj tab tom tsim.

Yog tias koj yuav tsum tau ua qee qhov kev hloov pauv rau daim duab uas twb tau tsim lawm (yuav ua li cas tsis muaj nws?!), tom qab ntawd koj tuaj yeem rov siv daim duab wizard lossis, qee zaum, cov ntawv qhia zaub mov lossis cov ntawv qhia zaub mov. moj khaum (Format). Pib nrog Excel 2007, cov txheej txheem ntawm kev tsim cov kab kos tau yooj yim heev uas Chart Wizard tsis xav tau ntxiv lawm.

  1. Taw qhia cov ntaub ntawv. Vim qhov tseeb tias thaum pib nws tau txiav txim siab seb cov ntaub ntawv twg yuav raug siv los tsim cov duab, nws muaj peev xwm saib ua ntej daim duab hauv cov txheej txheem ntawm kev tsim nws.
  2. Xaiv hom kab kos. Hauv Advanced tab Insert (Ntxig) xaiv hom kab kos. Ib daim ntawv teev cov subtypes yuav qhib. Los ntawm hovering tus nas hla txhua tus ntawm lawv, koj tuaj yeem saib ua ntej li cas daim duab yuav saib raws li cov ntaub ntawv xaiv. Nyem rau ntawm qhov xaiv subtype thiab Excel yuav tsim ib daim ntawv qhia ntawm daim ntawv ua haujlwm.
  3. Customize tus tsim thiab layout. Nyem rau ntawm daim duab tsim - qhov no (nyob ntawm qhov version ntawm Excel) ob lossis peb lub tab ntxiv yuav tshwm sim ntawm Ribbon. Tabs constructor (Design), moj khaum (Format) thiab nyob rau hauv ib co versions Layout (Layout) tso cai rau koj siv ntau yam qauv tsim los ntawm cov kws tshaj lij rau daim duab tsim, tsuas yog nyem rau ntawm lub cim sib thooj ntawm Ribbon.
  4. Customize cov ntsiab lusua agram. Txhawm rau nkag mus rau qhov tsis sib xws ntawm daim ntawv qhia (piv txwv li, axis tsis), tsuas yog nyem rau ntawm lub cim thiab xaiv cov lus txib uas xav tau los ntawm cov ntawv qhia zaub mov.

Piv txwv: Tsim ib lub histogram

Peb tsim ib lub rooj rau ntawm daim ntawv nrog cov ntaub ntawv, piv txwv li, ntawm kev muag khoom hauv ntau lub nroog:

Hauv Excel 1997-2003

Nyem rau ntawm daim ntawv qhia zaub mov Insert (Insert) > Daim duab (Daim duab). Hauv qhov rais wizard uas tshwm, ua cov hauv qab no:

  1. Hom kab kos (Tib hom). Nyem bar daim qauv qhia (Kem) thiab xaiv thawj qhov kev thov subtypes.
  2. Source yogcov ntaub ntawv kab kos (Daim ntawv qhia qhov chaw). Sau cov hauv qab no:
    • ntau (Cov ntaub ntawv ntau): nkag ib 4:c9 (highlighted hauv daj ntseg xiav hauv daim duab);
    • Kab hauv (Series): xaiv kab (kem);
    • Hauv Advanced tab Leej (Series) hauv daim teb X axis kos npe (Qeb cov ntawv sau) qhia txog qhov ntau A4: UA 9.
  3. Daim duab xaiv (Kev xaiv kab kos). Ntxiv ib nqe lus "Muag los ntawm Cheeb Tsam Cheeb Tsam» thiab lus dab neeg.
  4. Daim ntawv tso chaw (Chaw Chaw). Tshawb xyuas kev xaiv Muab daim duab tso rau ntawm daim ntawv > muaj (Raws li khoom hauv) thiab xaiv Ntawv 1 (Daim duab 1).

Hauv Excel 2007-2013

  1. Xaiv ib kab ntawm cov hlwb nrog tus nas ib 4:c9 (highlighted hauv lub teeb xiav hauv daim duab).
  2. Hauv Advanced tab Insert (Ntxig) nyem Ntxig histogram (Insert Kem Chart).
  3. xaiv Histogram nrog pab pawg (2-D Clustered Kem).
  4. Nyob rau hauv tab pab pawg uas tshwm nyob rau hauv ribbon Ua haujlwm nrog cov kab kos (Chart Tools) qhib tab constructor (Tsim) thiab nias Xaiv cov ntaub ntawv (Xaiv cov ntaub ntawv). Nyob rau hauv lub dialog box uas tshwm:
    • Nyob rau hauv lub Kab rov tav axis labels (categories) ( Kab rov tav (qeb) cov ntawv) nyem hloov ( Kho kom raug) rau A4: UA 9ces nias OK;
    • hloov Kab 1 (Series 1): hauv daim teb Row npe (Series npe) xaiv cell B3;
    • hloov Kab 2 (Series 2): hauv daim teb Row npe (Series npe) xaiv cell C3.
  5. Hauv daim duab tsim, nyob ntawm qhov version ntawm Excel, ob zaug-nias ntawm daim ntawv teev npe, lossis qhib lub tab Ua haujlwm nrog cov kab kos (Cov cuab yeej kos duab) > Layout (Layout) thiab nkag mus rau "Muag los ntawm Cheeb Tsam Cheeb Tsam".

Yuav ua li cas?

Siv qee lub sij hawm los tshawb nrhiav cov kev xaiv kab ntawv uas muaj. Saib cov cuab yeej twg nyob rau ntawm pawg tabs Ua haujlwm nrog cov kab kos (ChartTools). Feem ntau ntawm lawv yog tus kheej piav qhia lossis yuav qhia saib ua ntej ua ntej xaiv.

Tom qab tag nrho, puas muaj kev kawm zoo dua li kev xyaum?

Sau ntawv cia Ncua