Momwe mungapangire fayilo yojambula kuchokera pa tchati cha Excel kapena kuitumiza ku Mawu kapena PowerPoint

Pambuyo powerenga nkhaniyi, muphunzira momwe mungapangire fayilo yosiyana (.png, .jpg, .bmp kapena mtundu wina) kuchokera ku tchati mu Excel kapena kutumiza kunja, mwachitsanzo, ku chikalata cha Mawu kapena kuwonetsera kwa PowerPoint.

Microsoft Excel ndi imodzi mwamapulogalamu amphamvu kwambiri osanthula deta. Mu nkhokwe yake pali zida ndi ntchito zambiri zowonera deta iyi. Ma chart (kapena ma graph) ndi chimodzi mwa zida zotere. Kuti mupange tchati mu Excel, mumangofunika kusankha deta ndikudina chizindikiro cha tchati mugawo lolingana la menyu.

Koma, polankhula za zoyenera, m'pofunika kutchula zofooka. Tsoka ilo, palibe njira yosavuta mu Excel yosungira tchati ngati chithunzi kapena kutumiza ku chikalata china. Zingakhale zabwino ngati titha kungodinanso pa graph ndikuwona lamulo ngati Sungani monga kujambula or Tumizani. Koma, popeza Microsoft sanasamalire kutipangira ntchito zoterezi, ndiye kuti tibwera ndi china chake.

M'nkhaniyi, ndikuwonetsani njira za 4 zosungira tchati cha Excel ngati chithunzi chomwe mutha kuchiyika muzolemba zina za Office, kuphatikiza Mawu ndi PowerPoint, kapena mugwiritse ntchito kupanga zithunzi zowoneka bwino.

• Koperani chithunzicho kwa mkonzi wazithunzi ndikusunga ngati chithunzi
• Tumizani tchati kuchokera ku Excel kupita ku Mawu kapena PowerPoint
• Sungani ma chart onse a Excel workbook ngati zithunzi
• Kusunga Tchati ngati Chithunzi Pogwiritsa Ntchito VBA Macro

Koperani chithunzicho kwa mkonzi wazithunzi ndikusunga ngati chithunzi

Mnzanga wina adagawana nane chinsinsi: nthawi zambiri amakopera ma chart ake kuchokera ku Excel kupita ku Paint. Amapanga tchati ndikungodina kiyi SindikizaniScreen, kenako ndikutsegula Paint ndikuyika chithunzicho. Pambuyo pake, imabzala madera osafunikira a chithunzicho ndikusunga chithunzi chotsalira ku fayilo. Ngati mwachitanso chimodzimodzi mpaka pano, ndiye kuti iwalani ndipo musagwiritsenso ntchito njira yachibwana! Tidzachita mwachangu komanso mwanzeru! 🙂

Mwachitsanzo, mu Excel 2010 yanga, ndidapanga tchati chokongola cha XNUMX-D chomwe chikuwonetsa kuchuluka kwa anthu omwe abwera patsamba lathu, ndipo tsopano ndikufuna kutumiza tchatichi kuchokera ku Excel ngati chithunzi. Tiyeni tichite limodzi:

1. Dinani kumanja pamalo a tchati ndikudina Koperani (Koperani). Palibe chifukwa chodina pa graph yokha, chifukwa izi zidzasankha zinthu payekha, osati chithunzi chonse, ndi lamulo. Koperani (Koperani) sikuwoneka.
2. Tsegulani Paint ndikumata tchati pogwiritsa ntchito chizindikirocho Ikani (Paste) tabu Kunyumba (Kunyumba) ndi kukanikiza Ctrl + V.
3. Tsopano zatsala kokha kusunga chithunzicho ngati fayilo yojambula. Dinani Sungani monga (Sungani ngati) ndikusankha imodzi mwamitundu yomwe mukufuna (.png, .jpg, .bmp kapena .gif). Ngati mukufuna kusankha mtundu wina, dinani Mawonekedwe ena (Mawonekedwe ena) kumapeto kwa mndandanda.

Zimakhala zosavuta! Kuti musunge tchati cha Excel motere, mkonzi aliyense wazithunzi adzachita.

Tumizani tchati kuchokera ku Excel kupita ku Mawu kapena PowerPoint

Ngati mukufuna kutumiza tchati kuchokera ku Excel kupita ku ntchito ina ya Office, monga Mawu, PowerPoint, kapena Outlook, njira yabwino yochitira izi ndi kudzera pa bolodi.

1. Koperani tchati kuchokera ku Excel monga mu chitsanzo chapitachi Gawo 1.
2. Mu chikalata cha Mawu kapena chiwonetsero cha PowerPoint, dinani pomwe mukufuna kuyika tchati ndikudina Ctrl + V. Kapena m'malo mokakamiza Ctrl + V, dinani kumanja kulikonse mu chikalatacho, ndipo seti yonse ya zosankha zowonjezera zidzatsegulidwa patsogolo panu mu gawolo Ikani Zosankha (Matani zosankha).

Ubwino waukulu wa njirayi ndikuti mwanjira imeneyi tchati cha Excel chogwira ntchito bwino chimatumizidwa ku fayilo ina, osati chithunzi chokha. Grafuyo ikhalabe yolumikizidwa ndi pepala loyambirira la Excel ndipo imangosintha zokha zomwe zili patsamba la Excel zisintha. Izi zikutanthauza kuti simukuyenera kukopera ndikuyikanso tchatichi ndikusintha kulikonse mu data yomwe idagwiritsidwa ntchito pomanga.

Sungani tchati mu Mawu ndi PowerPoint ngati chithunzi

Mumapulogalamu a Office 2007, 2010, ndi 2013, tchati cha Excel zitha kukopera ngati chithunzi. Pankhaniyi, idzakhala ngati chithunzi chabwinobwino ndipo sichidzasinthidwa. Mwachitsanzo, tiyeni titumize tchati cha Excel ku chikalata cha Word 2010.

1. M'buku la Excel, koperani tchati, kenako tsegulani chikalata cha Mawu, ikani cholozera pomwe mukufuna kuyika tchaticho, ndikudina kachidutswa kakang'ono kakuda pansi pa batani. Ikani (Paste), yomwe ili pa tabu Kunyumba (Kunyumba).
2. Mu menyu yomwe imatsegulidwa, tili ndi chidwi ndi chinthucho Matani apadera (Paste Special) - Imawonetsedwa ndi muvi pazithunzi pamwambapa. Dinani pa izo - bokosi lazokambirana la dzina lomwelo lidzatsegulidwa ndi mndandanda wazithunzi zomwe zilipo, kuphatikizapo Bitmap (bitmap), GIF, PNG ndi JPEG.
3. Sankhani ankafuna mtundu ndi kumadula OK.

Ambiri mwina chida Matani apadera (Paste Special) imapezekanso m'mitundu yakale ya Office, koma nthawi imeneyo sindinaigwiritse ntchito, chifukwa chake sindinena 🙂

Sungani ma chart onse a Excel workbook ngati zithunzi

Njira zomwe takambiranazi ndizothandiza pankhani yazithunzi zochepa. Koma bwanji ngati mukufuna kukopera ma chart onse kuchokera ku Excel workbook? Ngati mungakopere ndikumata chilichonse payekhapayekha, zitha kutenga nthawi yayitali. Ndifulumira kukusangalatsani - simukuyenera kuchita izi! Pali njira yosungira ma chart onse ku Excel workbook nthawi imodzi.

1. Mukamaliza kupanga ma chart mu buku lanu lantchito, dinani batani file (Fayilo) ndikudina batani Sungani monga (Sungani ngati).
2. A dialog box adzaoneka Kusunga chikalata (Sungani ngati). M'ndandanda wotsitsa Mtundu wa Fayilo (Sungani monga mtundu) sankhani Веб-страница (Tsamba, *.htm, *.html). Onaninso kuti mu gawo Save (Sungani) njira yosankhidwa Buku Lonse (Buku Lonse la Ntchito) monga zikuwonetsedwa pazithunzi pansipa:
3. Sankhani chikwatu kusunga owona ndi kumadula batani Save (Sungani).

Ku chikwatu chosankhidwa pamodzi ndi mafayilo .html ma chart onse omwe ali mu Excel workbook monga mafayilo adzakopera . Png. Chithunzi chomwe chili pansipa chikuwonetsa zomwe zili mufoda yomwe ndidasunga buku langa lantchito. Buku langa la Excel lili ndi mapepala atatu okhala ndi tchati chilichonse - ndipo mufoda yomwe ndasankha, tikuwona ma chart atatu osungidwa ngati mafayilo ojambulidwa. . Png.

Monga mukudziwira, PNG ndi imodzi mwamafayilo abwino kwambiri ophatikizira omwe palibe kutayika kwamtundu. Ngati mukufuna kugwiritsa ntchito mawonekedwe ena azithunzi, ndiye kuti mutembenuzire .jpg, . Gif, .bmp kapena china chilichonse sichidzakhala chovuta.

Kusunga Tchati ngati Chithunzi Pogwiritsa Ntchito VBA Macro

Ngati nthawi zambiri mumafunika kutumiza ma chart a Excel ngati zithunzi, mutha kusintha ntchitoyi pogwiritsa ntchito VBA macro. Mwamwayi, pali ma macro ambiri olembedwa kale, kotero sitiyenera kuyambiranso gudumu 🙂

Mwachitsanzo, mungagwiritse ntchito yankho loyesedwa ndi loona lolembedwa ndi John Peltier pa blog yake. Macro yake ndiyosavuta:

ActiveChart.Export "D:My ChartsSpecialChart.png"

Mzere wa code uwu umapanga fayilo yojambula mufoda yomwe wapatsidwa . Png ndikutumiza kunja chithunzicho. Mutha kupanga macro anu oyamba pompano munjira 4 zosavuta, ngakhale simunachitepo m'moyo wanu.

Musanayambe kulemba macro, konzekerani chikwatu chotumizira ma chart. Kwa ife, ichi chidzakhala chikwatu Ma chart Anga pa disk D. Chifukwa chake, zokonzekera zonse zatha, tiyeni tichite zazikulu.

1. Mu buku lanu la Excel, tsegulani tabu Woyambitsa (Wopanga Mapulogalamu) ndi mgawo Code (Code) dinani chizindikiro Macros (Macro).

Zindikirani: Ngati mupanga macro kwa nthawi yoyamba, ndiye, mwina, tabu Woyambitsa (Wopanga Mapulogalamu) adzabisika. Pankhaniyi, pitani ku tabu file (Fayilo), dinani magawo (Zosankha) ndikutsegula gawolo Konzani riboni (Sinthani Maliboni). Kumanja kwa zenera, mu mndandanda Ma tabu akulu (Ma Tabs Aakulu) chongani bokosi pafupi ndi Woyambitsa (Wopanga Mapulogalamu) ndikudina OK.

2. Perekani dzina kwa macro atsopano, mwachitsanzo, SaveSelectedChartAsImage, ndikupangitsa kuti izipezeka m'buku lothandizirali.
3. atolankhani Pangani (Pangani), izi zidzatsegula zenera la Visual Basic editor, momwe chiyambi ndi mapeto a macro atsopano zidzasonyezedwa kale. Mumzere wachiwiri, koperani mawu akulu awa:

   ActiveChart.Export "D:My ChartsSpecialChart.png"

   

4. Tsekani Visual Basic Editor ndi pa tabu file (Filet) knead Sungani monga (Sungani ngati). Sungani buku lanu lantchito ngati Macro-enabled Excel workbook (Buku lantchito la Excel Macro-Enabled, *.xlsm). Ndi zimenezo, mwachita!

Tsopano tiyeni tiyendetse ma macro omwe tangopanga kuti tiwone momwe zimagwirira ntchito. Dikirani kaye… Pali chinthu chinanso chomwe tikuyenera kuchita. Tiyenera kusankha tchati cha Excel chomwe tikufuna kutumiza kunja chifukwa macro athu amangogwira ntchito ndi tchati chosankhidwa. Dinani paliponse m'mphepete mwa tchati. Chomera chotuwa chopepuka chomwe chikuwoneka mozungulira chithunzicho chidzawonetsa kuti chasankhidwa bwino.

Tsegulaninso tabu Woyambitsa (Wopanga Mapulogalamu) ndikudina chizindikirocho Macros (macros). Mndandanda wa macros omwe amapezeka mu bukhu lanu la ntchito adzatsegulidwa. Unikani SaveSelectedChartAsImage Ndipo dinani Thamangani (Thamanga).

Tsopano tsegulani chikwatu chomwe mudatchula kuti musunge fayilo - payenera kukhala chithunzi . Png ndi chithunzi chotumizidwa kunja. Mutha kusunga ma chart mumtundu wina mwanjira yomweyo. Kuti muchite izi, ndikwanira kusintha mu macro . Png on .jpg or . Gif - ngati chonchi:

ActiveChart.Export "D:My ChartsSpecialChart.jpg"

Ndizo zonse lero, ndipo ndikukhulupirira kuti mwakhala ndi nthawi yabwino powerenga nkhaniyi. Zikomo chifukwa cha chidwi!