Contents
Sabon Mayen Chart
Hanyar gina ginshiƙi don kewayon sel da aka zaɓa yanzu an sauƙaƙa sosai godiya ga sabon akwatin tattaunawa tare da samfoti na ginshiƙi da aka gama (duka zaɓukan gaba ɗaya - ta layuka da ginshiƙai):
Haɗaɗɗen ginshiƙi inda nau'ikan nau'ikan biyu ko uku suka haɗu (histogram-plot-tare da yankuna, da sauransu) yanzu ana sanya su a cikin wani wuri daban kuma an daidaita su sosai nan da nan a cikin taga Wizard:
Hakanan yanzu a cikin taga saka ginshiƙi akwai tab Shafukan da aka ba da shawarar (Shawarwarin Charts), inda Excel zai ba da shawarar nau'ikan ginshiƙi mafi dacewa dangane da nau'in bayanan ku na farko:
Shawarwari, dole ne in ce, da dacewa sosai. A cikin lokuta masu wuya, har ma ya ba da shawarar yin amfani da axis na biyu tare da sikelinsa (rubles-kashi), da dai sauransu. Ba mummunan ba.
Keɓance sigogi
Don daidaita duk mahimman sigogi na kowane ginshiƙi, yanzu zaku iya amfani da maɓallan maɓalli uku waɗanda suka bayyana a hannun dama na ginshiƙi da aka zaɓa:
- Abubuwan da aka tsara (Kayan Aiki) - yana ba ku damar ƙara da tsara kowane nau'in ginshiƙi (lakabi, gatari, grid, alamun bayanai, da sauransu).
- Salon ginshiƙi (Tsarin Salon) - ba da damar mai amfani don zaɓar ƙira da palette mai launi na zane da sauri daga tarin
- Tace Tace (Tace Tace) - yana ba ku damar tace bayanai don ginshiƙi akan tashi, barin kawai jerin da ake buƙata da nau'ikan a ciki
An gabatar da komai cikin dacewa a cikin nau'ikan menus masu matsayi daban-daban, yana goyan bayan samfoti akan tashi kuma yana aiki cikin sauri da dacewa:
Idan, duk da haka, wannan sabon ƙirar keɓancewa bai dace da ku ba, to, zaku iya bi hanyar gargajiya - duk mahimman ayyukan da ake yi don keɓance bayyanar ginshiƙi kuma ana iya yin su ta amfani da shafuka. Constructor (Zane) и tsarin (Format). Kuma ga shafuka Layout (Layout), inda aka saita mafi yawan zaɓuɓɓukan ginshiƙi a cikin Excel 2007/2010, babu sauran a can.
Kunshin ayyuka maimakon akwatunan maganganu
Daidaita ƙirar kowane nau'in ginshiƙi yanzu an yi shi sosai ta amfani da kwamiti na musamman a gefen dama na taga Excel 2013 - babban aikin da ya maye gurbin kwalayen maganganu na tsarawa. Don nuna wannan rukunin, danna-dama akan kowane ɓangaren ginshiƙi kuma zaɓi umarnin tsarin (Format) ko danna gajeriyar hanyar keyboard CTRL + 1 ko danna sau biyu tare da hagu:
Takaddun bayanan kira
Lokacin ƙara alamun bayanai zuwa abubuwan da aka zaɓa na jerin ginshiƙi, yanzu yana yiwuwa a tsara su a cikin kiran kira kai tsaye zuwa maki:
A baya can, dole ne a zana irin waɗannan kiran da hannu (wato, kawai a saka su azaman abubuwa daban-daban) kuma, ba shakka, babu wata tambaya game da kowane ɗaure bayanai.
Lakabi don maki daga sel
Ba zan iya yarda da idanu na ba! A ƙarshe, mafarkin masu amfani da yawa ya zama gaskiya, kuma masu haɓakawa sun aiwatar da abin da ake tsammani daga gare su kusan shekaru 10 - yanzu za ku iya ɗaukar alamun bayanai don abubuwan da ke cikin jerin ginshiƙai kai tsaye daga takardar ta zaɓar zaɓi a ciki. babban aikin Dabi'u daga sel (Dabi'u Daga Kwayoyin) da ƙayyadaddun kewayon sel masu alamar maki:
Lakabi don kumfa da ginshiƙi mai watsawa, duk wasu alamomin da ba daidai ba ba su da matsala! Abin da ya kasance zai yiwu kawai da hannu (kokarin ƙara lakabi zuwa maki hamsin da hannu!) Ko amfani da macros / add-ons na musamman (XYChartLabeler, da dai sauransu), yanzu aikin Excel 2013 daidai ne.
Animation Chart
Wannan sabon fasalin fasalin a cikin Excel 2013, kodayake ba babba ba ne, har yanzu zai ƙara wasu mojo a cikin rahotanninku. Yanzu, lokacin canza bayanan tushen (da hannu ko ta hanyar ƙididdige ƙididdiga), zanen zai “zuba” cikin wani sabon yanayi a hankali, yana nuna canje-canjen da suka faru:
Trifle, amma mai kyau.
- Menene sabo a cikin Excel 2013 PivotTables