Kodi chinachitika ndi chiyani kwa Chart Wizard ku Excel?

Chati Wizard adachotsedwa ku Excel 2007 ndipo sanabwererenso m'matembenuzidwe ena. M'malo mwake, dongosolo lonse logwira ntchito ndi zithunzi linasinthidwa, ndipo omangawo sanawone kuti ndi koyenera kukonzanso mfiti yazithunzi ndi zida zogwirizana nazo.

Ndiyenera kunena kuti dongosolo latsopano logwirira ntchito ndi ma chart likuphatikizidwa mozama mu mawonekedwe atsopano a Menyu Ribbon ndipo ndilosavuta kugwira nawo ntchito kuposa mfiti yomwe idatsogolera. Kukonzekera ndikosavuta ndipo pa sitepe iliyonse mutha kuwona chithunzithunzi cha chithunzi chanu musanasinthe.

Kuyerekeza kwa "Chart Wizard" ndi zida zamakono

Kwa iwo omwe amagwiritsidwa ntchito ndi wizard ya tchati, tikufuna kunena kuti pogwira ntchito ndi Riboni, zida zonse zomwezo zilipo, nthawi zambiri osapitilira kudina kangapo kwa mbewa.

M'mitundu yakale ya Excel, mukadina menyu Ikani (Ikani) > Chithunzi (Chati) wizard adawonetsa mabokosi anayi akukambirana motsatizana:

  1. Mtundu wa tchati. Musanasankhe deta ya tchati, muyenera kusankha mtundu wake.
  2. Gwero lachidziwitso cha ma chart. Sankhani maselo omwe ali ndi data kuti akonze tchati ndi kutchula mizere kapena mizere yomwe ikuyenera kuwonetsedwa ngati mndandanda wazinthu patchati.
  3. Zosankha zamatchati. Sinthani mwamakonda anu masanjidwe ndi ma chart ena monga zilembo za data ndi nkhwangwa.
  4. Kusinthaku zithunzi. Sankhani pepala lomwe lilipo kale kapena pangani tsamba latsopano kuti likhale ndi tchati chomwe mukupanga.

Ngati mukufuna kusintha zina pazithunzi zomwe zidapangidwa kale (zingakhale bwanji popanda izo?!), ndiye mutha kugwiritsanso ntchito wizard yachithunzi kapena, nthawi zina, menyu yankhani kapena menyu. Makhalidwe (Fomati). Kuyambira ndi Excel 2007, njira yopangira ma chart yakhala yosavuta kwambiri kotero kuti Chart Wizard sikufunikanso.

  1. Onetsani deta. Chifukwa chakuti pachiyambi zimatsimikiziridwa kuti ndi deta iti yomwe idzagwiritsidwe ntchito popanga graph, ndizotheka kuwonetseratu chithunzichi pochipanga.
  2. Sankhani mtundu wa tchati. Pa Advanced tabu Ikani (Lowetsani) sankhani mtundu wa tchati. Mndandanda wa subtypes udzatsegulidwa. Mwa kusuntha mbewa pamwamba pa aliyense wa iwo, mutha kuwona momwe graph idzawonekera potengera zomwe mwasankha. Dinani pa subtype yosankhidwa ndipo Excel ipanga tchati patsamba lantchito.
  3. Sinthani mwamakonda mamangidwe ndi masanjidwe. Dinani pa tchati chopangidwa - pakadali pano (kutengera mtundu wa Excel) ma tabo awiri kapena atatu owonjezera adzawonekera pa Riboni. Ma tabu Constructor (Kupanga), Makhalidwe (Format) ndi m'mabaibulo ena Kuyika (Mapangidwe) amakulolani kugwiritsa ntchito masitayelo osiyanasiyana opangidwa ndi akatswiri pazithunzi zomwe zidapangidwa, kungodinanso chizindikiro chofananira pa Riboni.
  4. Sinthani Mwamakonda Anu ma elementma gramu. Kuti mupeze magawo a chinthu cha tchati (mwachitsanzo, magawo a axis), ingodinani kumanja pa chinthucho ndikusankha lamulo lomwe mukufuna kuchokera pazosankha.

Chitsanzo: Kupanga histogram

Timapanga tebulo papepala ndi deta, mwachitsanzo, pa malonda m'mizinda yosiyanasiyana:

Mu Excel 1997-2003

Dinani pa menyu Ikani (Ikani) > Chithunzi (Chati). Muwindo la wizard lomwe likuwoneka, chitani izi:

  1. Mtundu wa tchati (Mtundu wa Tchati). Dinani tchati cha bar (Column) ndikusankha yoyamba mwa mitundu yaying'ono yomwe mukufuna.
  2. Source indema chart a data (Chart Source Data). Lowetsani zotsatirazi:
    • zosiyanasiyana (Data range): kulowa b4:c9 (chowonetsedwa ndi buluu wotumbululuka pachithunzichi);
    • Mizere mkati (Series): sankhani mizati (mizere);
    • Pa Advanced tabu Mzere (Series) m'munda Ma signature a X axis (Zolemba zamagulu) tchulani mtundu A4:A9.
  3. Zosankha za Tchati (Zosankha za Tchati). Onjezani mutu "Zogulitsa ndi Metropolitan Area»ndi nthano.
  4. Kuyika ma chart (Malo a Tchati). Chongani njira Ikani tchati papepala > lilipo (Monga chinthu mkati) ndikusankha Sheet1 (Tsamba 1).

Mu Excel 2007-2013

  1. Sankhani ma cell angapo ndi mbewa b4:c9 (chowonetsedwa mu buluu wowala mu chithunzi).
  2. Pa Advanced tabu Ikani (Ikani) dinani Ikani histogram (Lowetsani Tchati Chazambiri).
  3. Sankhani Histogram ndi magulu (2-D Clustered Column).
  4. Mu tabu gulu limene limapezeka pa riboni Kugwira ntchito ndi ma chart (Zida Chati) tsegulani tabu Constructor (Design) ndikusindikiza Sankhani deta (Sankhani Data). Mu dialog box yomwe ikuwoneka:
    • Mu Zolemba zopingasa (magulu) (Zolemba zopingasa (gulu)) dinani Change (Sinthani) pa A4:A9ndiye akanikizire OK;
    • Change ndime 1 (Series1): m'munda Dzina la mzere (dzina la mndandanda) sankhani selo B3;
    • Change ndime 2 (Series2): m'munda Dzina la mzere (dzina la mndandanda) sankhani selo C3.
  5. Mu tchati chopangidwa, kutengera mtundu wa Excel, dinani kawiri pamutu wa tchati, kapena tsegulani tabu Kugwira ntchito ndi ma chart (Zida za Tchati) > Kuyika (Kapangidwe) ndi kulowa"Zogulitsa ndi Metropolitan Area".

Zoyenera kuchita?

Tengani nthawi kuti mufufuze zosankha zomwe zilipo. Onani zida zomwe zili pamagulu amagulu Kugwira ntchito ndi ma chart (ChartTools). Ambiri a iwo amadzifotokozera okha kapena adzawonetsa chithunzithunzi chisankho chisanapangidwe.

Kupatula apo, kodi pali njira yabwino yophunzirira kuposa kuchita?

Siyani Mumakonda