Menene ya faru da Wizard Chart a cikin Excel?

Mayen Chart An cire shi daga Excel 2007 kuma ba a dawo da shi a cikin sigogin baya ba. A gaskiya ma, an canza dukan tsarin aiki tare da zane-zane, kuma masu haɓakawa ba su yi la'akari da cewa ya zama dole don sabunta mayen zane da kayan aikin da suka dace ba.

Dole ne in faɗi cewa sabon tsarin aiki tare da ginshiƙi an haɗa shi sosai cikin sabon ƙirar Menu Ribbon kuma yana da sauƙin aiki tare da mayen da ya gabace shi. Saitin yana da fahimta kuma a kowane mataki zaka iya ganin samfoti na zanen ku kafin yin kowane canje-canje.

Kwatanta "Mayen Chart" da kayan aikin zamani

Ga waɗanda aka yi amfani da su zuwa mayen ginshiƙi, muna so mu ce lokacin aiki tare da Ribbon, duk kayan aikin iri ɗaya suna samuwa, yawanci a cikin danna maballin linzamin kwamfuta guda biyu.

A cikin tsoffin sigogin Excel, bayan danna menu Saka (Saka) > zane (Chart) maye ya nuna akwatunan maganganu guda huɗu a jere:

  1. Nau'in zane. Kafin ka zaɓi bayanai don ginshiƙi, kuna buƙatar zaɓar nau'in sa.
  2. Tushen bayanan ginshiƙi. Zaɓi sel waɗanda ke ɗauke da bayanan don tsara ginshiƙi kuma saka layuka ko ginshiƙan da yakamata a nuna su azaman jerin bayanai akan ginshiƙi.
  3. Zaɓuɓɓukan jadawalin. Keɓance tsarawa da sauran zaɓuɓɓukan ginshiƙi kamar alamun bayanai da gatari.
  4. Sanya zane-zane. Zaɓi ko dai takardar da ke akwai ko ƙirƙiri sabon takardar don ɗaukar nauyin ginshiƙi da kuke ƙirƙira.

Idan kana buƙatar yin wasu canje-canje zuwa zane wanda aka riga aka ƙirƙira (yaya zai kasance ba tare da shi ba?!), to, zaku iya sake amfani da mayen zane ko, a wasu lokuta, menu na mahallin ko menu. tsarin (Format). An fara da Excel 2007, tsarin ƙirƙirar ginshiƙi an sauƙaƙa da shi ta yadda ba a buƙatar Wizard Chart.

  1. Haskaka bayanai. Saboda gaskiyar cewa a farkon farko an ƙayyade abin da za a yi amfani da bayanan da za a yi amfani da shi don gina jadawali, yana yiwuwa a samfoti zane a cikin tsarin ƙirƙirar shi.
  2. Zaɓi nau'in ginshiƙi. A kan Babba shafin Saka (Saka) zaɓi nau'in ginshiƙi. Jerin subtypes zai buɗe. Ta hanyar shawagi linzamin kwamfuta akan kowannensu, zaku iya samfoti yadda jadawali zai kasance bisa bayanan da aka zaɓa. Danna kan ƙaramin nau'in da aka zaɓa kuma Excel zai ƙirƙiri ginshiƙi akan takaddar aiki.
  3. Keɓance ƙira da shimfidawa. Danna kan ginshiƙi da aka ƙirƙira - a wannan yanayin (dangane da sigar Excel) ƙarin shafuka biyu ko uku zasu bayyana akan Ribbon. Tabs Constructor (Zane), tsarin (Format) da kuma a wasu iri Layout (Layout) yana ba ku damar amfani da salo daban-daban waɗanda ƙwararru suka ƙirƙira zuwa zanen da aka ƙirƙira, kawai ta danna alamar da ta dace akan Ribbon.
  4. Keɓance abubuwaagrams. Don samun damar ma'aunin ginshiƙi (misali, sigogi na axis), danna-dama akan kashi kuma zaɓi umarnin da ake so daga menu na mahallin.

Misali: Ƙirƙirar histogram

Muna ƙirƙirar tebur akan takardar tare da bayanai, alal misali, akan tallace-tallace a cikin birane daban-daban:

A cikin Excel 1997-2003

Danna kan menu Saka (Saka) > zane (Chat). A cikin taga wizard da ya bayyana, yi abubuwa masu zuwa:

  1. Nau'in zane (Nau'in Chart). Danna ginshiƙi na banki (Shafi) kuma zaɓi farkon nau'ikan da aka tsara.
  2. Source ehjadawalin bayanai (Bayanan Tushen Chart). Shigar da waɗannan:
    • range (Kewayon bayanai): shigar b4:c9 (wanda aka haskaka a cikin kodadde shuɗi a cikin adadi);
    • Layukan ciki (Series): zaži ginshikan (ginshiƙai);
    • A kan Babba shafin Jere (Series) a cikin filin Sa hannun axis X (Takaddun nau'ikan) suna ƙayyade kewayon A4: a9.
  3. Zaɓuɓɓukan Chart (Zaɓuɓɓukan Hotuna). Ƙara taken"Tallace-tallace ta Yankin Birni» da almara.
  4. Sanya jadawalin (Lokacin ginshiƙi). Duba zaɓi Sanya ginshiƙi akan takarda > akwai (A matsayin abu a ciki) kuma zaɓi Takardar1 (Shafi na 1).

A cikin Excel 2007-2013

  1. Zaɓi kewayon sel tare da linzamin kwamfuta b4:c9 (wanda aka haskaka da haske blue a cikin adadi).
  2. A kan Babba shafin Saka (Saka) danna Saka histogram (Saka Chart Shafi).
  3. zabi Histogram tare da rukuni (2-D Clustered Column).
  4. A cikin rukunin shafin da ke bayyana akan kintinkiri Aiki tare da ginshiƙi (Kayan aikin Chart) buɗe shafin Constructor (Design) kuma latsa Zaɓi bayanai (Zaɓi Bayanai). A cikin akwatin maganganu da ke bayyana:
    • a cikin Alamun axis na kwance (kasuwa) (Takamaiman a kwance (category)) danna Change (Edit) ku A4: a9sai ka latsa OK;
    • Change Layuka1 (Series1): a cikin filin Sunan layi (Series name) zaži tantanin halitta B3;
    • Change Layuka2 (Series2): a cikin filin Sunan layi (Series name) zaži tantanin halitta C3.
  5. A cikin ginshiƙi da aka ƙirƙira, dangane da nau'in Excel, ko dai danna sau biyu akan taken ginshiƙi, ko buɗe shafin Aiki tare da ginshiƙi (Kayan Aiki)> Layout (Layout) sannan ka shiga"Tallace-tallace ta Yankin Birni".

Abin da ya yi?

Ɗauki lokaci don bincika zaɓuɓɓukan ginshiƙi da ke akwai. Dubi kayan aikin da ke kan rukunin rukunin Aiki tare da ginshiƙi (ChartTools). Yawancin su suna bayyana kansu ko kuma za su nuna samfoti kafin a zaɓi zaɓi.

Bayan haka, akwai hanya mafi kyau don koyo fiye da aiki?

Leave a Reply