Chii chakaitika kuChati Wizard muExcel?

Chart Wizard yakabviswa muExcel 2007 uye haina kuzombodzoka mune dzakazotevera shanduro. Muchokwadi, iyo yese sisitimu yekushanda nemadhayagiramu yakashandurwa, uye vagadziri havana kuzviona zvakakodzera kugadzirisa iyo dhizaini wizard uye zvishandiso zvinoenderana.

Ndinofanira kutaura kuti hurongwa hutsva hwekushanda nemachati hwakanyatsobatanidzwa muhutano hutsva hweMenu Ribbon uye iri nyore kushanda nayo pane wizard yakatangira. Iyo yekuseta ine intuitive uye padanho rega rega unogona kuona tarisiro yedhiyagiramu yako usati waita chero shanduko.

Kuenzanisa kwe "Chati Wizard" uye zvishandiso zvemazuva ano

Kune avo vakajaira kune wizard yechati, tinoda kutaura kuti kana tichishanda neRibhoni, ese maturusi akafanana anowanikwa, kazhinji mune isingapfuuri kaviri yekudzvanya kwembeva.

Mune shanduro dzekare dzeExcel, mushure mekudzvanya pane menyu Insert (Isa) > Diagram (Chati) wizard yakaratidza mabhokisi mana ekutevedzana:

  1. Chati mhando. Usati wasarudza data yechati, unofanirwa kusarudza rudzi rwayo.
  2. Chati data source. Sarudza maseru ane data kuronga chati uye tsanangura mitsara kana makoramu anofanirwa kuratidzwa se data rakateerana pachati.
  3. Chati sarudzo. Gadzirisa mafomati uye dzimwe sarudzo dzechati senge data rabels nematemo.
  4. kupinda muzvikoro madhayagiramu. Sarudza pepa riripo kana kuti gadzira shiti idzva kuti utore chati yauri kugadzira.

Kana iwe uchida kuita shanduko kune yakatogadzirwa dhizaini (zvingave sei pasina iyo?!), ipapo iwe unogona zvakare kushandisa iyo dhizaini wizard kana, mune dzimwe nguva, iyo mamiriro menyu kana menyu. Framework (Format). Kutanga neExcel 2007, maitiro ekugadzira machati akarerutswa zvekuti Chart Wizard haichadiwi.

  1. Simbisa iyo data. Nekuda kwekuti pakutanga chaiko kunotariswa kuti ndeipi data ichashandiswa kugadzira girafu, zvinokwanisika kutarisa dhayagiramu mukuigadzira.
  2. Sarudza rudzi rwechati. Pa Advanced tabo Insert (Isa) sarudza rudzi rwechati. Rondedzero ye subtypes ichavhurwa. Nekutenderedza mbeva pamusoro peumwe neumwe wavo, unogona kuona kuti girafu richataridzika sei zvichienderana nedata rakasarudzwa. Dzvanya pane yakasarudzwa subtype uye Excel ichagadzira chati pane pepa rebasa.
  3. Gadzirisa magadzirirwo uye marongerwo. Dzvanya pachati yakagadzirwa - mune iyi kesi (zvichienderana neshanduro yeExcel) maviri kana matatu mamwe ma tabo achaonekwa paRibhoni. Tabs Constructor (Design), Framework (Format) uye mune dzimwe shanduro Maitiro (Layout) inokutendera iwe kuti uise akasiyana masitaera akagadzirwa nenyanzvi kudhiyagiramu yakagadzirwa, nekungodzvanya pane inoenderana icon paRibhoni.
  4. Gadzirisa di elementmagiramu. Kuti uwane iyo paramita yechati chinhu (semuenzaniso, axis paramita), tinya-kurudyi pane chinhu uye sarudza rairo yaunoda kubva pane yemukati menyu.

Muenzaniso: Kugadzira histogram

Isu tinogadzira tafura pane pepa ine data, semuenzaniso, pakutengesa mumaguta akasiyana:

MuExcel 1997-2003

Dzvanya pane menyu Insert (Isa) > Diagram (Chati). Muwindo rewizard rinoonekwa, ita zvinotevera:

  1. Chati mhando (Rudzi rweChati). Dzvanya bha chati (Column) uye sarudza yekutanga yeakatsanangurwa subtypes.
  2. Source hongudata charts (Chati Source Data). Isa zvinotevera:
    • dungwerungwe (Data renji): pinda B4:C9 (yakasimbiswa mubhuruu rakachenuruka mumufananidzo);
    • Mitsara mukati (Series): sarudza mbiru (makoramu);
    • Pa Advanced tabo Row (Series) mumunda X axis siginicha (Category labels) tsanangura huwandu A4:A9.
  3. Chati Sarudzo (Sarudzo dzeChati). Wedzera musoro "Kutengeswa neMetropolitan Area»uye ngano.
  4. Kuiswa kwechati (Chati Nzvimbo). Tarisa sarudzo Isa chati papepa > zviripo (Sechinhu mukati) uye sarudza Sheet1 (Sheet1).

MuExcel 2007-2013

  1. Sarudza huwandu hwemasero negonzo B4:C9 (yakasimbiswa muchiedza chebhuruu mumufananidzo).
  2. Pa Advanced tabo Insert (Isa) tinya Isa histogram (Isa Column Chati).
  3. sarudza Histogram pamwe nemapoka (2-D Clustered Column).
  4. Muboka retibhu rinoonekwa paribhoni Kushanda nemachati (Chati Zvishandiso) vhura tab Constructor (Design) uye tinya Sarudza data (Sarudza Data). Mubhokisi rebhokisi rinoonekwa:
    • Mu Horizontal axis labels (mapoka) (Horizontal (category) mavara) tinya chinja (Edza) on A4:A9zvobva wadzvanya OK;
    • chinja mutsara1 (Series1): mumunda Zita remusara (Series zita) sarudza sero B3;
    • chinja mutsara2 (Series2): mumunda Zita remusara (Series zita) sarudza sero C3.
  5. Muchati yakagadzirwa, zvichienderana neshanduro yeExcel, kudzvanya kaviri pazita rechati, kana kuvhura tebhu Kushanda nemachati (Zvishandiso zveChati) > Maitiro (Magadzirirwo) uye pinda"Kutengeswa neMetropolitan Area".

Zvokuita?

Tora nguva yekuongorora sarudzo dziripo dzechati. Ona kuti maturusi api ari pamatebhu eboka Kushanda nemachati (ChartTools). Mazhinji acho anozvitsanangura ega kana kuti acharatidza kufanoona sarudzo isati yaitwa.

Mushure mezvose, pane imwe nzira iri nani yekudzidza pane kudzidzira?

Leave a Reply