Yadda ake ƙirƙirar fayil mai hoto daga ginshiƙi na Excel ko fitarwa zuwa Word ko PowerPoint

Bayan karanta wannan labarin, zaku koyi yadda ake ƙirƙirar fayil ɗin hoto daban (.png, .jpg, .bmp ko wani tsari) daga ginshiƙi a cikin Excel ko fitar dashi, misali, zuwa takaddar Word ko gabatarwar PowerPoint.

Microsoft Excel yana ɗaya daga cikin aikace-aikacen nazarin bayanai masu ƙarfi. A cikin arsenal ɗinta akwai kayan aiki da ayyuka da yawa don ganin wannan bayanan. Charts (ko jadawali) ɗaya ne irin waɗannan kayan aikin. Don ƙirƙirar ginshiƙi a cikin Excel, kawai kuna buƙatar zaɓar bayanai kuma danna gunkin ginshiƙi a cikin sashin menu mai dacewa.

Amma, magana game da cancanta, ya zama dole a ambaci raunin. Abin takaici, babu wata hanya mai sauƙi a cikin Excel don adana ginshiƙi azaman hoto ko fitar dashi zuwa wani takaddar. Zai yi kyau idan za mu iya danna dama a kan jadawali mu ga umarni kamar Ajiye azaman zane or Export. Amma, tun da Microsoft bai kula da ƙirƙirar irin waɗannan ayyuka a gare mu ba, to za mu fito da wani abu da kanmu.

A cikin wannan labarin, zan nuna muku hanyoyi 4 don adana ginshiƙi na Excel azaman hoto wanda zaku iya liƙa daga baya cikin wasu takaddun Office, gami da Word da PowerPoint, ko amfani da shi don ƙirƙirar wasu bayanai masu kayatarwa.

• Kwafi zanen zuwa editan zane kuma ajiye azaman hoto
• Fitar da ginshiƙi daga Excel zuwa Kalma ko PowerPoint
• Ajiye duk sigogin littafin aikin Excel azaman hotuna
• Ajiye Chart azaman Hoto Amfani da VBA Macro

Kwafi zanen zuwa editan zane kuma ajiye azaman hoto

Wani abokina ya taɓa gaya mini wani sirri: yawanci tana kwafin ginshiƙi daga Excel zuwa Paint. Ta ƙirƙiri ginshiƙi kuma kawai ta danna maɓalli Mafita, sa'an nan ya buɗe Paint da liƙa da screenshot. Bayan haka, yana shuka wuraren da ba'a so na hoton kuma yana adana ragowar hoton zuwa fayil. Idan kun yi irin wannan har zuwa yanzu, to ku manta da shi kuma kada ku sake amfani da wannan hanyar na yara! Za mu yi aiki da sauri da wayo! 🙂

Alal misali, a cikin Excel 2010 na, na ƙirƙiri kyakkyawan ginshiƙi na XNUMX-D wanda ke nuna bayanai game da ƙididdigar maziyartan rukunin yanar gizon mu, kuma yanzu ina so in fitar da wannan ginshiƙi daga Excel azaman hoto. Mu yi tare:

1. Dama danna kan yankin ginshiƙi kuma danna Copy (Kwafi). Babu buƙatar danna kan jadawali da kansa, tunda wannan zai zaɓi abubuwan mutum ɗaya, kuma ba duka zane ba, da umarnin. Copy (Kwafi) ba zai bayyana ba.
2. Buɗe Paint kuma liƙa ginshiƙi ta amfani da gunkin Saka (Manna) tab Gida (Gida) da dannawa Ctrl + V.
3. Yanzu ya rage kawai don adana zane azaman fayil mai hoto. Danna Ajiye azaman (Ajiye azaman) kuma zaɓi ɗayan tsarin da aka ba da shawarar (.png, .jpg, .bmp ko .gif). Idan kana son zaɓar wani tsari daban, danna Sauran tsare-tsare (Sauran tsarin) a ƙarshen jerin.

Ba ya samun sauƙi! Don adana ginshiƙi na Excel ta wannan hanyar, kowane editan zane zai yi.

Fitar da ginshiƙi daga Excel zuwa Kalma ko PowerPoint

Idan kana buƙatar fitar da ginshiƙi daga Excel zuwa wasu aikace-aikacen Office, kamar Word, PowerPoint, ko Outlook, hanya mafi kyau don yin wannan ita ce ta allo.

1. Kwafi ginshiƙi daga Excel kamar yadda yake a cikin misalin da ya gabata akan mataki 1.
2. A cikin takaddar Kalma ko gabatarwar PowerPoint, danna inda kake son saka ginshiƙi kuma danna Ctrl + V. Ko maimakon dannawa Ctrl + V, danna-dama a ko'ina a cikin takaddun, kuma duk saitin ƙarin zaɓuɓɓuka zai buɗe a gabanka a cikin sashin Manna Zabuka (Manna zaɓukan).

Babban fa'idar wannan hanyar ita ce ta wannan hanyar ana fitar da ginshiƙi na Excel mai cikakken aiki zuwa wani fayil, ba kawai hoto ba. Jadawalin zai kasance yana da alaƙa da ainihin takardar Excel kuma za ta sabunta ta atomatik lokacin da bayanan da ke cikin takardar Excel suka canza. Wannan yana nufin cewa ba dole ba ne ka sake kwafa da liƙa ginshiƙi tare da kowane canji a cikin bayanan da aka yi amfani da su don gina shi.

Ajiye ginshiƙi a cikin Kalma da PowerPoint azaman hoto

A cikin aikace-aikacen Office 2007, 2010, da 2013, ana iya kwafin ginshiƙi na Excel azaman hoto. A wannan yanayin, zai kasance kamar hoto na al'ada kuma ba za a sabunta shi ba. Misali, bari mu fitar da ginshiƙi na Excel zuwa takaddar Word 2010.

1. A cikin littafin aikin Excel, kwafi ginshiƙi, sannan buɗe takaddar Kalma, sanya siginan kwamfuta inda kake son liƙa ginshiƙi, sannan danna ƙaramin kibiya baƙar fata a ƙasan maɓallin. Saka (Manna), wanda ke kan shafin Gida (Gida).
2. A cikin menu wanda ya buɗe, muna sha'awar abu Manna na musamman (Manna Musamman) - Ana nuna shi da kibiya a hoton da ke sama. Danna kan shi - akwatin maganganu mai suna iri ɗaya zai buɗe tare da jerin abubuwan da aka samo asali, gami da Bitmap (bitmap), GIF, PNG da JPEG.
3. Zaɓi tsarin da ake so kuma danna OK.

Mafi kusantar kayan aiki Manna na musamman Hakanan ana samun (Paste Special) a cikin sigar farko na Office, amma a lokacin ban yi amfani da shi ba, don haka ba zan ce 🙂

Ajiye duk sigogin littafin aikin Excel azaman hotuna

Hanyoyin da muka tattauna yanzu suna da amfani idan ya zo ga ƙaramin adadi. Amma menene idan kuna buƙatar kwafin duk sigogi daga littafin aikin Excel? Idan kun kwafa da liƙa kowanne ɗayansu ɗaya ɗaya, zai iya ɗaukar lokaci mai tsawo. Ina gaggawar faranta muku rai - ba lallai ne ku yi wannan ba! Akwai hanya don adana duk sigogi daga littafin aikin Excel lokaci guda.

1. Lokacin da kuka gama ƙirƙirar sigogi a cikin littafin aikinku, danna maɓallin fayil (Fayil) kuma danna maɓallin Ajiye azaman (Ajiye azaman).
2. Akwatin maganganu zai bayyana Ajiye takarda (Ajiye azaman). A cikin jerin saukewa Nau'in fayil (Ajiye azaman nau'in) zaɓi Shashen yanar gizo (Shafin yanar gizo, *.htm, *.html). Hakanan duba wannan a cikin sashin Ajiye (Ajiye) zaɓi zaɓi Littafi Mai Tsarki (Duk littafin Aiki) kamar yadda aka nuna a hoton da ke ƙasa:
3. Zaɓi babban fayil don adana fayiloli kuma danna maɓallin Ajiye (Ajiye).

Zuwa babban fayil ɗin da aka zaɓa tare da fayilolin .html duk sigogin da ke ƙunshe a cikin littafin aikin Excel kamar yadda fayiloli za a kwafi . Png. Hoton da ke ƙasa yana nuna abubuwan da ke cikin babban fayil inda na ajiye littafina na aiki. Littafin aikina na Excel ya ƙunshi zanen gado uku tare da ginshiƙi akan kowanne - kuma a cikin babban fayil ɗin da na zaɓa, muna ganin sigogi uku da aka adana azaman fayilolin hoto. . Png.

Kamar yadda kuka sani, PNG yana ɗaya daga cikin mafi kyawun tsarin matsi na hoto wanda babu asarar inganci. Idan kun fi son amfani da wasu tsarin hoto, to, ku canza su zuwa .jpg, . Gif, .bmp ko wani ba zai yi wahala ba.

Ajiye Chart azaman Hoto Amfani da VBA Macro

Idan sau da yawa kuna buƙatar fitar da sigogin Excel azaman hotuna, zaku iya sarrafa wannan aikin ta amfani da macro VBA. Abin farin ciki, akwai da yawa irin waɗannan macros da aka riga aka rubuta, don haka ba dole ba ne mu sake ƙirƙira dabaran 🙂

Misali, zaku iya amfani da ingantaccen bayani na gaskiya da John Peltier ya buga akan shafin sa. Macro nasa mai sauqi ne:

ActiveChart.Export "D:My ChartsSpecialChart.png"

Wannan layin lambar yana ƙirƙirar fayil mai hoto a cikin babban fayil ɗin da aka bayar . Png kuma yana fitar da zanen zuwa gare shi. Kuna iya ƙirƙirar macro na farko a yanzu a cikin matakai 4 masu sauƙi, koda kuwa ba ku taɓa yin hakan ba a rayuwar ku.

Kafin ka fara rubuta macro, shirya babban fayil don fitarwa ginshiƙi. A cikin yanayinmu, wannan zai zama babban fayil Charts Na na faifai D. Don haka, an gama duk shirye-shiryen, bari mu yi macro.

1. A cikin littafin aikin ku na Excel, buɗe shafin developer (Developer) kuma a cikin sashe code (Code) danna icon Macros (Macros).

lura: Idan ka ƙirƙiri macro a karon farko, to, mafi mahimmanci, shafin developer (Developer) za a boye. A wannan yanayin, je zuwa shafin fayil (Fayil), danna Siga (Zaɓuɓɓuka) kuma buɗe sashin Sanya ribbon (Kaddamar da Ribbons). A cikin ɓangaren dama na taga, a cikin lissafin Babban shafuka (Babban Shafukan) duba akwatin kusa da developer (Developer) kuma danna OK.

2. Ba da suna ga sabon macro, misali, AjiyeSelectedChartAsImage, kuma sanya shi don wannan littafin aikin kawai.
3. latsa Create (Ƙirƙiri), wannan zai buɗe taga na Visual Basic edita, wanda a ciki za a riga an nuna farkon da ƙarshen sabon macro. A cikin layi na biyu, kwafi rubutun macro mai zuwa:

   ActiveChart.Export "D:My ChartsSpecialChart.png"

   

4. Rufe Editan Kayayyakin Kayayyakin Kayayyaki kuma akan shafin fayil (Filet) durƙusa Ajiye azaman (Ajiye azaman). Ajiye littafin aikinku azaman Littafin aikin Excel na Macro (Littafin Ayyukan da aka kunna Excel Macro, * .xlsm). Shi ke nan, kun yi!

Yanzu bari mu gudanar da macro da muka ƙirƙira don ganin yadda yake aiki. Jira minti daya… Akwai ƙarin abu ɗaya da muke buƙatar yi. Muna buƙatar zaɓar ginshiƙi na Excel da muke son fitarwa saboda macro ɗin mu kawai yana aiki tare da ginshiƙi da aka zaɓa. Danna ko'ina a gefen ginshiƙi. Firam ɗin launin toka mai haske wanda ke bayyana a kusa da zane zai nuna cewa an zaɓi shi cikakke.

Bude shafin kuma developer (Developer) kuma danna gunkin Macros (macro). Jerin macro da ke cikin littafin aikinku zai buɗe. Haskakawa AjiyeSelectedChartAsImage Kuma danna Run (Gudu).

Yanzu buɗe babban fayil ɗin da kuka ƙayyade don adana fayil ɗin - yakamata a sami hoto . Png tare da zanen da aka fitar. Kuna iya ajiye ginshiƙi a wani tsari daban ta hanya ɗaya. Don yin wannan, ya isa ya canza a cikin macro . Png on .jpg or . Gif - kamar wannan:

ActiveChart.Export "D:My ChartsSpecialChart.jpg"

Yau ke nan, kuma ina fata kun ji daɗin karanta wannan labarin. Na gode da kulawa!