Legends zaune a Excel; gano inda!
A cikin taswira ko hoto a shirye-shiryen shafukan yanar gizo kamar Microsoft Excel, labari ya fi yawanci a gefen dama na ginshiƙi ko zane kuma a wani lokacin ana iya kewaye da iyaka.
An danganta labari ne da bayanan da ake nunawa a cikin sashin filin . Kowace shigarwa a cikin labari ya ƙunshi mabuɗin mabuɗin don yin la'akari da bayanan.
Lura: Labarin kuma ana san shi da maɓallin Chart.
Mene ne Girman Lissafi?
Don ƙara wa rikice tsakanin labari da maɓalli, Microsoft yana nufin kowane ɓangaren mutum a cikin wani labari kamar yadda maɓallin labari.
Maballin mahimmanci shi ne alama guda ɗaya ko alamar alama a cikin labari. A hannun dama na kowane maɓallin labari shine sunan da ke gano bayanan da aka wakilta ta hanyar maɓallin.
Dangane da nau'in siffin, maƙallan maɓalli suna wakiltar ƙungiyoyi daban-daban na ɗawainiyar aikin aiki :
- Domin layin jeri , shafukan bar, ko ginshiƙi , kowace maɓallin kewayawa tana wakiltar jerin bayanai ɗaya.
- Alal misali, a cikin sigogi na shafi, zaku iya samun maɓallin alamar zane wanda ya karanta Age kusa da shi, da kuma orange don sunan. Launi mai launin launi a cikin zane yana nufin shekaru don kowane shigarwa a cikin jerin sunayen.
- Domin zane-zane ko zagaye-zane, kowane mabuɗin maɓalli yana wakiltar wani ɓangare na jerin jere guda ɗaya kawai.
- Don amfani da misalin wannan daga sama, amma ga ma'auni, kowane yanke na keɓaɓɓen launi ne wanda yake wakiltar kowane shigarwa "Sunan". Kowace ɓangare na keɓaɓɓiyar nau'i ne daban-daban na dukan launi don wakiltar ƙididdigar shekaru da aka ɗauka daga jerin "Age".
Gyara Lissafi da Legend Keys
A cikin Excel, maƙallan labaran suna haɗe da bayanai a cikin yanki, don haka canja launin launi mai mahimmanci zai canza launi na bayanan a cikin yanki.
Zaka iya danna dama ko taɓa-da-riƙe a kan mabuɗin maɓalli, kuma zaɓi Tsarin Mulki Tsarin , don canza launin, alamu, ko hoton da aka yi amfani dashi don wakiltar wannan bayanin.
Don canja zaɓuɓɓukan da suka danganci dukan labarin kuma ba kawai wani shigarwa ba, dan dama-dama ko taɓa-da-riƙe don neman samfurin Legend . Wannan shi ne yadda zaka sauya rubutun cika, rubutu na rubutu, sakamako na rubutu, da akwatin rubutu.
Yadda za a nuna Shafin a Excel
Bayan yin ginshiƙi a Excel, yana yiwuwa labarin bai nuna ba. Zaka iya taimakawa labarin ta hanyar yin amfani da shi kawai.
Ga yadda:
- Zaɓi ginshiƙi.
- Samun Shafin Dama a saman Excel.
- Bude Taswirar Shafin Element menu.
- Zaɓi Legend daga menu.
- Zabi inda za'a sanya labarin - dama, saman, hagu, ko ƙasa.
Idan zaɓin zaɓin don ƙara wani labari ya fita, to yana nufin cewa kana buƙatar zaɓar bayanan farko. Danna madaidaicin sabo, kyauta marar lahani kuma zaɓi Zabi Bayanan , sannan kuma bi umarnin kan allon don zaɓar bayanan da ginshiƙi ya wakilta.