Haɗa Chart Siffofin a Excel 2010

01 na 09

Ƙara Axis na Secondary zuwa Tashar Excel

Lura : Matakan da aka kayyade a cikin wannan koyaswar kawai suna da amfani ga sassan Excel har zuwa ciki har da Excel 2010 .

Excel yana baka damar haɗa nau'i biyu ko fiye daban-daban ko nau'in halayen don ya fi sauƙi don nuna bayanan dangantaka tare.

Ɗaya hanya mai sauƙi don kammala wannan aiki shine ta ƙara tafin na biyu ko Y a gefen dama na ginshiƙi. Bayanai guda biyu na bayanai har yanzu suna raba wani zane na X ko kwance a kasa na ginshiƙi.

Ta hanyar zabar nau'in nau'in nau'in nau'i-nau'i - kamar layin shafi da layin layi - za a iya bunkasa gabatar da bayanan bayanai guda biyu.

Amfani na yau da kullum don wannan nau'in haɗin haɗe sun haɗa da nuna yawan yawan zafin jiki na kowane wata da kuma haɗin haɗuwa tare, bayanan masana'antu kamar raƙuman da aka samar da kuma farashin samarwa, ko yawan tallace-tallace a kowane wata da kuma farashin tallace-tallace a kowane wata.

Hadin Shafin Jigogi

• Ɗaya daga cikin abin da ake buƙata don bayanan da aka nuna shine cewa dole ne ya raba matsayin X (a kwance) - kamar su lokaci ko wuri.
• Har ila yau, ba duk nau'i-nau'in nau'in nau'i ba zasu iya hade. 3-D sigogi, alal misali, ba za a iya haɗa su cikin haɗin haɗe ba.

Tasirin Hoton Hotuna na Excel

Wannan koyaswar ya rufe matakan da ake bukata domin haɗin shafi da layi tare tare don ƙirƙirar hoto ko tsayi-tsayi , wanda ya nuna yawan zafin rana da hazo da wuri don wuri.

Kamar yadda aka nuna a hoton da ke sama, sashe na shafi, ko shafukan shafuka, yana nuna haɓakaccen haɗuwa a kowane wata yayin da jigon layin ke nuna nauyin haɗin yawan zafin jiki.

Tutorial Steps

Matakan da suka biyo baya a cikin koyaswa don ƙirƙirar layin yanayi shine:

1. Ya ƙirƙira wani sashi na ginshiƙai guda biyu, wanda ke nuna alamomi da yawan zazzabi a cikin ginshiƙan launuka masu launin
2. Canja nau'in nau'in ma'auni don bayanai masu zafi daga ginshiƙai zuwa layi
3. Matsar da bayanan zafin jiki daga gefe na tsaye (a gefen hagu na ginshiƙi) zuwa gefe na tsaye (gefen dama na ginshiƙi)
4. Aiwatar da zaɓuɓɓukan tsarawa zuwa ma'auni na yanayin yanayi don yadda ya dace da hoto da aka gani a hoton da ke sama

02 na 09

Shigar da Zaɓin Bayanin Shafukan Girman Hotuna

Mataki na farko a samar da wani yanayi mai sauƙi shine shigar da bayanai a cikin takardun aiki .

Da zarar an shigar da bayanai, mataki na gaba shine don zaɓar bayanan da za a hada a cikin ginshiƙi.

Zaɓin ko ƙaddamar da bayanan yana nuna Excel abin da ke cikin takardun aiki don haɗawa da abin da ya ƙi.

Bugu da ƙari, ga lambobin lamba, tabbatar da cewa sun ƙunshi kowane lakabi da lakabi waɗanda ke bayyana bayanan.

Lura: Koyarwar ba ta haɗa da matakai don tsara tsarin aiki ba kamar yadda aka nuna a hoton da ke sama. Bayani game da zaɓuɓɓukan tsara ayyukan aiki suna samuwa a cikin wannan tsari mai mahimmanci .

Tutorial Steps

1. Shigar da bayanai kamar yadda aka gani a cikin hoton da ke cikin sel A1 zuwa C14.
2. Karkatar da sassan A2 zuwa C14 - wannan ita ce kewayon bayanin da za a haɗa a cikin ginshiƙi

03 na 09

Ƙirƙirar Shafin Shafi na asali

Ana samun dukkan sigogi ƙarƙashin Saka shafin rubutun a cikin Excel, kuma duk suna raba waɗannan halaye:

• Lokacin ƙirƙirar kowane ginshiƙi a Excel, shirin ya fara haifar da abin da ake kira ma'auni mai amfani ta amfani da bayanan da aka zaɓa
• Koma linzamin linzaminka a kan sashen layi zai kawo bayanin siffin
• Danna a kan wani fannin yana buɗe wani digo mai nuna duk nau'in nau'i nau'i a wannan rukunin

Mataki na farko a ƙirƙirar kowane haɗin haɗin - irin su yanayin hoto - shi ne yayi la'akari da dukan bayanan a cikin nau'in nau'i guda ɗaya sannan sannan ya canza bayanan da aka saita zuwa nau'i na biyu.

Kamar yadda aka ambata a baya, saboda wannan yanayin yanayi, zamu fara yin la'akari da jerin bayanai guda biyu a kan wani shafi kamar yadda aka gani a cikin hoton da ke sama, sannan kuma canza yanayin ma'auni don yawan zazzabi zuwa layin jeri.

Tutorial Steps

1. Tare da bayanan da aka zaɓa, danna kan Saka> Shafin> 2-d Clustered Column a cikin rubutun
2. Dole ne a ƙirƙira maɓallin ginshiƙan kama da wanda aka gani a hoton da ke sama, kuma a sanya shi a cikin takardun aiki

04 of 09

Bayanin Saukaka Yanayin Samun Lissafi zuwa Layin Zane

Ana canza nau'in sigogi a Excel anyi ta amfani da akwatin kwance na Canji Chaff .

Tun da yake muna so mu canza kawai daga cikin jerin bayanai guda biyu da aka nuna su zuwa daban-daban nau'in chart, muna buƙatar gaya Excel wanda yake.

Ana iya yin haka ta zaɓin, ko danna sau ɗaya, a ɗaya daga cikin ginshiƙai a cikin ginshiƙi, wanda ke nuna dukkan ginshiƙan wannan launi.

Zaɓuɓɓuka don buɗe Sanya Chart Rubutun maganganu sun hada da:

• danna maɓallin Gidan Chafi na Canji a kan Shafin zane na kintinkiri
• danna dama a ɗayan ginshiƙan da aka zaɓa kuma zaɓin Zaɓin Zaɓin Zaɓin Zaɓuɓɓukan Changes na Zaɓuɓɓuka daga menu na saukewa

Dukkanin jerin nau'ukan da aka samo su a cikin akwatin maganganu don haka yana da sauki sauyawa daga wannan ginshiƙi zuwa wani.

Tutorial Steps

1. Danna sau ɗaya akan ɗaya daga cikin ginshiƙan bayanai na yanayin zafi - aka nuna a cikin blue a cikin hoton da ke sama - don zaɓar duk ginshiƙan wannan launi a cikin ginshiƙi
2. Sauke maɓallin linzamin kwamfuta a kan ɗaya daga cikin wadannan ginshiƙan kuma danna dama tare da linzamin kwamfuta don buɗe mahimman menu na mahallin
3. Zaɓi Zaɓin Zaɓin Zaɓin Zaɓuɓɓukan Zaɓin Zaɓi daga menu na saukewa don bude Halin Chart Type akwatin maganganu
4. Danna kan zaɓi na jeri na farko a hannun dama na haɗin maganganu
5. Danna Ya yi don rufe akwatin maganganu kuma komawa zuwa aikin aiki
6. A cikin shafuka, dole ne a nuna halin zafin jiki a matsayin layin launi a baya ga ginshiƙan bayanai na hazo

05 na 09

Bayanin Juyawa zuwa Matsayin Secondary Y

Canza bayanan zafin jiki zuwa layin jeri na iya sanya shi sauki don rarrabe tsakanin ɗigon bayanai guda biyu, amma, saboda an haɗa su duka a daidai wannan wuri , ana nuna yawan zafin jiki a matsayin wata hanya madaidaici wanda ya gaya mana kaɗan game da kowane wata yawan canjin yanayi.

Wannan ya faru ne saboda girman ma'auni ɗaya na tsaye yana ƙoƙarin saukar da jigilar bayanai guda biyu da suka bambanta da girma.

Bayanin yawan zafin jiki na Acapulco yana da ƙananan ƙananan daga 26.8 zuwa 28.7 digiri Celsius, yayin da bayanin haɓaka ya bambanta daga kasa da millimita a watan Maris zuwa fiye da 300 mm a watan Satumba.

Lokacin da aka saita ma'auni na gefen tsaye don nuna babban adadin bayanan hazo, Excel ya cire duk wani bayyanar bambancin a cikin yanayin zazzabi na shekara.

Matsar da bayanai na zafin jiki zuwa wani wuri na tsaye - wanda aka nuna a gefen dama na ginshiƙi ya ba da izinin daidaitaccen ma'auni don jeri guda biyu.

A sakamakon haka, zane zai iya nuna bambancin ra'ayoyin bayanan guda biyu a lokaci ɗaya.

Ana ƙaddamar da bayanan zafin jiki zuwa wani wuri na tsaye a tsaye a cikin akwatin maganganu na Data Data .

Tutorial Steps

1. Danna sau ɗaya akan layin zafin jiki - aka nuna a ja a cikin hoton da ke sama - domin zaɓar shi
2. Sauke maɓallin linzamin kwamfuta a kan layin kuma danna danna tare da linzamin kwamfuta don buɗe maɓallin saukar da menu
3. Zaɓi zaɓin Bayanin Rarraba Hoto daga menu na saukewa don bude akwatin maganganun Data Data Series

06 na 09

Bayanin Ƙaura zuwa Ƙaramar Secondary Y (Con't)

Tutorial Steps

1. Danna Zaɓuɓɓukan Zabin a haɗin hagu na akwatin maganganu idan ya cancanta
2. Danna maɓallin Aikin Zaɓuɓɓuka a hannun dama na haɗin maganganu kamar yadda aka nuna a hoton da ke sama
3. Danna maɓallin Gungura don rufe akwatin maganganu kuma komawa cikin takardun aiki
4. A cikin zane, dole ne a nuna layin ma'aunin zafin jiki a gefen dama na ginshiƙi

Sakamakon safarar bayanai na yanayin zafi zuwa wuri na biyu na tsaye, layin da ke nuna bayanan haɓaka ya kamata ya nuna bambancin da yawa daga wata zuwa wata yana mai sauƙi don ganin zazzabi.

Wannan yana faruwa ne saboda ƙananan zazzabi a kan gefen tsaye a gefen dama na ginshiƙi a yanzu yana da kawai ya rufe ɗakunan fiye da digiri huɗu na Celsius maimakon sikelin wanda ya kasance daga zero zuwa 300 lokacin da bayanan na biyu suka raba daya sikelin.

Tsarin Hotuna

A wannan yanayin, zane-zanen yanayi ya kamata kama da hoton da aka nuna a mataki na gaba na koyawa.

Matakan da suka rage a cikin koyarwar koyo wanda ke yin amfani da zaɓin tsarawa zuwa zane-zanen yanayi don sanya shi kama da hoto wanda aka nuna a mataki daya.

07 na 09

Tsarin Hotuna

Idan ya zo game da tsara hotunan a Excel ba dole ba ka yarda da tsarawar tsoho don wani ɓangare na wani ginshiƙi. Ana iya canja dukkan sassa ko abubuwa na ginshiƙi.

Zaɓuɓɓukan tsarawa don sigogi sun fi yawanci a kan shafuka uku na rubutun da ake kira Ƙungiyar Shafin

Yawanci, waɗannan shafuka uku ba a bayyane ba. Don samun dama gare su, kawai danna kan tsarin da aka kirkiro da ku da shafuka uku - Zane, Layout, da Tsarin - an kara da su zuwa rubutun.

Sama da waɗannan shafuka uku, za ku ga rubutun Saitunan Kayan aiki .

A cikin sauran matakan jagoranci za a yi canje-canje masu tsarawa:

• Ƙara shafuka da sunayen sunayen axes
• motsa labarin a saman sashin
• Canja launuka da launuka masu launi
• Buga da bayan gefen ginshiƙi
• Sake mayar da ginshiƙi

Ƙara Matsayin Aiki na Gida

Gidan da aka kwance yana nuna kwanakin tare da kasan ginshiƙi.

1. Danna kan ma'auni na asali a cikin takardun aiki don kawo ɗayan shafuka na kayan aiki
2. Danna kan Layout tab
3. Danna maɓallin Axis don buɗe jerin saukewa
4. Danna maɓallin Aiki na Farko na Farko> Rubutun Aiki na ƙasa don ƙara sunan tsoho Axis Title zuwa chart
5. Jawo zaɓi tsohuwar lakabi don haskaka shi
6. Rubuta a cikin taken " Watan "

Ƙara lambobin Aiki na Farko na Farko

Hanya na tsakiya na tsaye yana nuna ƙarar hannun jari da aka sayar a gefen hagu na ginshiƙi.

1. Danna kan ginshiƙi idan ya cancanta
2. Danna kan Layout tab
3. Danna maɓallin Axis don buɗe jerin saukewa
4. Danna maɓallin Lissafi na Farko na Farko> Zaɓin zaɓin Title don ƙara sunan tsoho Axis Title zuwa ginshiƙi
5. Ƙarƙirar taken tsoho
6. Rubuta a cikin taken " Yanayi (mm) "

Ƙara maƙallin Lissafi na Farko

Hanya na biyu na tsaye yana nuna yawan farashin farashin da aka sayar tare da gefen dama na ginshiƙi.

1. Danna kan ginshiƙi idan ya cancanta
2. Danna kan Layout tab
3. Danna maɓallin Axis don buɗe jerin saukewa
4. Danna mahimman rubutun sakandare na biyu> Zaɓin zaɓin zaɓi don ƙara sunan tsoho Axis Title zuwa chart
5. Ƙarƙirar taken tsoho
6. Rubuta a cikin taken " Matsayin Cikakken Yanayin (° C) "

Ƙara Rubutun Shafi

1. Danna kan ginshiƙi idan ya cancanta
2. Danna maɓallin Layout na rubutun
3. Danna Rubutun Chart> Aiki na Shafin don ƙara lambobin da aka ba da su na ainihi zuwa ginshiƙi
4. Ƙarƙirar taken tsoho
5. Rubuta a cikin taken Climatograph don Acapulco (1951-2010)

Canza layin rubutun lakabin launi

1. Danna sau ɗaya akan Rubutun Chart don zaɓar shi
2. Danna kan shafin shafin a kan menu na rubutun
3. Danna kan maɓallin ƙasa na Yankin Font Color don buɗe menu na saukewa
4. Zaɓi Dark Red daga ƙarƙashin Yanayin Launuka Tsare na menu

08 na 09

Ƙaddamar da Labarin kuma Canza Launin Yanki na Yanki

Ta hanyar tsoho, labarin labarun yana samuwa a gefen dama na ginshiƙi. Da zarar mun ƙara mahimman lamuni na gefe na biyu, abubuwa suna da yawa a cikin wannan yanki. Don rage ƙwaƙwalwa za mu motsa labarin a saman sashin da ke ƙarƙashin maɓallin ginshiƙi.

1. Danna kan ginshiƙi idan ya cancanta
2. Danna maɓallin Layout na rubutun
3. Danna kan Faɗakar don buɗe jerin saukewa
4. Danna kan nuna Maɓalli a Zaɓin Zaɓin don motsa labarin a ƙasa da taken shafukan

Yin amfani da Zaɓuɓɓukan Tsarin Menu Menu

Bugu da ƙari ga shafukan kayan aiki na rubutun akan rubutun, za a iya tsara canje-canjen canje-canje zuwa sigogi ta amfani da saukewa ko menu mahallin da ya buɗe lokacin da ka danna dama akan wani abu.

Canza launuka masu launi don dukan ginshiƙi da kuma filin yanki - akwatin tsakiya na sashin da ke nuna bayanan - za a yi ta amfani da menu mahallin.

Canza Shafin Yanayin Shafin Farko

1. Dama dama a kan farar fararen gefe don buɗe mahallin mahallin mahallin
2. Danna maɓallin ƙananan hagu zuwa hannun dama na Shafi Fill icon - zane na iya - a cikin kayan aiki na kayan aiki don buɗe mahaɗin Launuka
3. Danna White, Bayanin 1, Darker 35% don canza launin launi na launin launin toka

Canza Plot Area Background Color

Lura: Yi la'akari da kada ka zaba jerin layin grid da aka shimfiɗa a cikin filin yanki maimakon bayan gari.

1. Danna danna a kan filin farar fata don buɗe filin yanki na yanki
2. Danna maɓallin ƙananan hagu zuwa hannun dama na Shafi Fill icon - zane na iya - a cikin kayan aiki na kayan aiki don buɗe mahaɗin Launuka
3. Danna kan Fari, Fari na 1, Darker 15% don canza saɓin launi na yanki zuwa launin toka mai haske

09 na 09

Ƙara Dalilan 3-D da ƙwaƙwalwar saiti

Ƙara mahimmanci 3-D yana ƙara wani zurfin zurfi zuwa chart. Ya bar sigin ta tare da kyan gani a waje.

1. Danna madaidaici a kan ginshiƙi don buɗe mahallin mahallin mahallin
2. Danna Zaɓin Yanki na Zaɓuɓɓuka a cikin mahaɗan kayan aiki don bude akwatin maganganu
3. Danna maɓallin 3-D a cikin hagu na hannun hagu na akwatin zane na Tashoshin Chart
4. Danna maɓallin ƙasa zuwa hannun dama na Dutsen Dutsen a cikin hannun dama na rukuni don bude panel na zaɓuɓɓukan batu
5. Danna kan Zaɓin Circle a cikin kwamitin - zaɓi na farko a cikin ɓangaren Bevel na kwamitin
6. Danna maɓallin Gungura don rufe akwatin maganganu kuma komawa cikin takardun aiki

Sake zanen hoton

Maimaita zane shine wani mataki na zaɓi. Amfanin yin launi ya fi girma shi ne cewa yana rage siffar da aka tsara ta hanyar tafin gefe na biyu a gefen dama na ginshiƙi.

Har ila yau, zai kara yawan yanki na yanki wanda ya sa sauƙin rubutu ya fi sauƙi don karantawa.

Hanyar da ta fi dacewa don sake mayar da sutura ita ce ta yi amfani da ƙananan hanyoyi da suka zama masu aiki a kusa da gefen ginshiƙi bayan da ka danna kan shi.

1. Danna sau ɗaya a kan shafukan baya don zaɓar dukan ginshiƙi
2. Zaɓin ginshiƙi yana ƙara layin launi mai laushi zuwa gefen waje na ginshiƙi
3. A kusurwa na wannan zane-zane mai zane yana da manyan kayan aiki
4. Sauke maɓallin linzamin ka a kan kusurwar sasai har sai maɓin ya canza cikin arrow mai maƙalli guda biyu
5. Lokacin da maciji wannan arrow ne mai sau biyu, danna ta maballin hagu na hagu kuma cire dan kadan don kara girman ginshiƙi. Zane zai sake girma a duka tsawonsa da nisa. Yankin yanki ya kamata ya karu da girman.

Idan ka bi duk matakai a cikin wannan koyaswar a wannan batu mahayin hoto ya kamata yayi kama da misalin da aka nuna a cikin hoton a ɓangaren farko na wannan koyawa.