Maitiro ekugadzira graphic faira kubva kuExcel chart kana kuitumira kune Shoko kana PowerPoint

Mushure mekuverenga chinyorwa ichi, iwe uchadzidza nzira yekugadzira yakasiyana graphic file (.png, .jpg, .bmp kana mamwe maitiro) kubva pane chati muExcel kana kuitumira kunze, semuenzaniso, kuShoko reShoko kana PowerPoint mharidzo.

Microsoft Excel ndeimwe yeakanyanya simba ekuongorora data application. Mune arsenal yayo kune akawanda maturusi uye mabasa ekuona iyi data. Machati (kana magirafu) chimwe chishandiso chakadaro. Kuti ugadzire chati muExcel, iwe unongoda kusarudza iyo data uye tinya chiratidzo chechati mune inoenderana menyu chikamu.

Asi, tichitaura nezvezvakakodzera, zvinodikanwa kutaura utera. Nehurombo, hapana nzira iri nyore muExcel yekuchengetedza chati semufananidzo kana kuitumira kune rimwe gwaro. Zvingave zvakanaka kana tikangobaya ipapo pagirafu toona murairo wakadai Sevha sekudhirowa or ekisipoti. Asi, sezvo Microsoft isina kuita hanya kutigadzirira mabasa akadaro, saka isu tichauya nechimwe chinhu isu pachedu.

Muchinyorwa chino, ini ndinokuratidza nzira ina dzekuchengetedza Excel chati semufananidzo waunogona kuzoisa mune mamwe magwaro eHofisi, anosanganisira Shoko nePowerPoint, kana kuishandisa kugadzira imwe inoyevedza infographics.

• Kopa dhiyagiramu kune giraidhi edhita uye chengeta semufananidzo
• Tumira kunze chati kubva kuExcel kuenda kuIzwi kana PowerPoint
• Sevha ese machati ebhuku rebasa reExcel semifananidzo
• Kuchengetedza Chati seMufananidzo Uchishandisa VBA Macro

Kopa dhiyagiramu kune giraidhi edhita uye chengeta semufananidzo

Shamwari yangu yakambogovana neni chakavanzika: anowanzo kukopa machati ake kubva kuExcel kuenda kuPaint. Anogadzira chati uye anongobaya kiyi PrintaScreen, wobva wavhura Paint uye woisa iyo skrini. Mushure meizvozvo, inodyara nzvimbo dzisingadiwe dzechifananidzo uye inochengetedza mufananidzo wasara kune faira. Kana iwe wakaita zvakafanana kusvika zvino, saka zviri nani kuzvikanganwa uye usazomboshandisa iyi nzira yemwana zvakare! Tichaita nekukurumidza uye nekuchenjera! 🙂

Semuenzaniso, muExcel 2010 yangu, ndakagadzira yakanaka XNUMX-D pie chati inoratidza dhata pamusoro pehuwandu hwevashanyi vesaiti yedu, uye ikozvino ndinoda kutumira kunze chati iyi kubva kuExcel semufananidzo. Ngatizviite pamwe chete:

1. Tinya kurudyi panzvimbo yechati wodzvanya mufananidzo (Kopi). Iko hakuna chikonzero chekudzvanya pane girafu pachayo, sezvo izvi zvichasarudza ega zvinhu, uye kwete iyo dhayagiramu yese, uye murairo. mufananidzo (Kopi) haisi kuzoonekwa.
2. Vhura Paint uye unamate chati uchishandisa icon Insert (Namira) tab Home (Kumba) nekudzvanya Ctrl + V.
3. Iye zvino zvinongosara chete kuchengetedza dhayagiramu se graphic faira. Dzvanya Save as (Chengetedza se) uye sarudza imwe yemhando dzataurwa (.png, .jpg, .bmp kana .gif). Kana iwe uchida kusarudza imwe fomati, tinya Mamwe mafomati (Mamwe mafomati) pamagumo erondedzero.

Hazvisi nyore! Kuti uchengetedze Excel chati nenzira iyi, chero mifananidzo yemifananidzo ichaita.

Tumira kunze chati kubva kuExcel kuenda kuIzwi kana PowerPoint

Kana iwe uchida kutumira kunze chati kubva kuExcel kuenda kune imwe Hofisi application, senge Shoko, PowerPoint, kana Outlook, nzira yakanakisa yekuita izvi ndeye clipboard.

1. Kopa chati kubva kuExcel semumuenzaniso wapfuura pa Step 1.
2. Mugwaro reShoko kana PowerPoint mharidzo, tinya paunoda kuisa chati uye tinya Ctrl + V. Kana kuti pane kudzvanya Ctrl + V, tinya-kurudyi chero kupi zvako mugwaro, uye seti yese yezvekuwedzera sarudzo ichavhura pamberi pako muchikamu Paste Options (Namira sarudzo).

Mukana mukuru weiyi nzira ndeyekuti nenzira iyi yakazara Excel chati inotumirwa kune imwe faira, uye kwete mufananidzo chete. Iyo girafu icharamba yakabatana neyekutanga Excel sheet uye inongozvigadzirisa kana data riri muExcel sheet rachinja. Izvi zvinoreva kuti haufanirwe kukopa uye kunama chati zvakare neshanduko yega yega mune data rakashandiswa kuivaka.

Sevha chati muIzwi uye PowerPoint semufananidzo

MuHofisi 2007, 2010, uye 2013 zvikumbiro, chati yeExcel inogona kukopwa semufananidzo. Muchiitiko ichi, ichaita semufananidzo wakajairika uye haizogadziriswi. Semuenzaniso, ngatitumire kunze cheExcel chart kune Shoko 2010 gwaro.

1. Mubhuku rekushanda reExcel, kopira chati, wobva wavhura gwaro reIzwi, isa chitubu paunoda kunamira chati, uye tinya museve mutema pazasi pebhatani. Insert (Namira), iyo iri pane tab Home (Kumba).
2. Mune menyu inovhura, isu tinofarira chinhu Namatidza special (Namira Yakakosha) -Inoratidzwa nemuseve uri pascreenshot iri pamusoro. Dzvanya pairi - bhokisi rebhokisi rezita rimwechete richazarura nerunyoro rwemafomati emifananidzo aripo, kusanganisira Bitmap (bitmap), GIF, PNG uye JPEG.
3. Sarudza chimiro chaunoda wobva wadzvanya OK.

Zvingangodaro chishandiso Namatidza special (Namira Yakakosha) inowanikwawo mushanduro dzekutanga dzeHofisi, asi panguva iyoyo ini handina kuishandisa, saka handisi kuzotaura 🙂

Sevha ese machati ebhuku rebasa reExcel semifananidzo

Nzira dzatichangobva kukurukura dzinobatsira kana zvasvika kune nhamba shoma yemadhayagiramu. Asi ko kana iwe uchida kukopa ese machati kubva kuExcel bhuku rebasa? Kana iwe ukakopa uye unama imwe neimwe yadzo yega, zvinogona kutora nguva yakati rebei. Ndinokurumidza kukufadza - haufanirwe kuita izvi! Pane nzira yekuchengetedza ese machati kubva kuExcel bhuku rebasa kamwechete.

1. Kana wapedza kugadzira machati mubhuku rako rebasa, tinya pakanzi faira (Faira) uye tinya bhatani Save as (Sevha se).
2. A dialog box ichaonekwa Kuchengeta gwaro (Sevha se). In drop down list File Type (Sevha semhando) sarudza Веб-страница (Webhu peji, *.htm, *.html). Tarisa zvakare muchikamu Save (Chengetedza) sarudzo yakasarudzwa Whole Book (Bhuku Rebasa rose) sezvakaratidzwa mumufananidzo uri pazasi:
3. Sarudza folda kuchengetedza mafaera uye tinya bhatani Save (Chengeta).

Kufaira rakasarudzwa pamwe chete nemafaira .tml machati ese ari muExcel workbook sezvo mafaera achakopwa . Png. Iyo skrini iri pazasi inoratidza zviri mukati mefolda yandakachengeta bhuku rangu rebasa. Bhuku rangu rekushanda reExcel rine mapepa matatu ane chati pane rimwe nerimwe - uye muforodha yandakasarudza, tinoona machati matatu akachengetwa semafaira emifananidzo. . Png.

Sezvaunoziva, PNG ndeimwe yeakanakisa kumanikidza mafomati mafomati umo pasina kurasikirwa kwemhando. Kana iwe uchida kushandisa mamwe mafomati emifananidzo, wobva washandura iwo .jpg, . Gif, .bmp kana imwe haizove yakaoma.

Kuchengetedza Chati seMufananidzo Uchishandisa VBA Macro

Kana iwe uchiwanzoda kuendesa kunze Excel machati semifananidzo, unogona otomatiki basa iri uchishandisa VBA macro. Neraki, kune akawanda macros akadaro akatonyorwa, saka isu hatifanirwe kudzoreredza vhiri 🙂

Semuenzaniso, unogona kushandisa yakaedzwa uye yechokwadi mhinduro yakatumirwa naJohn Peltier pane yake blog. Iyo macro iri nyore kwazvo:

ActiveChart.Export "D:My ChartsSpecialChart.png"

Iyi mutsara wekodhi inogadzira graphic faira mune yakapihwa folda . Png uye inotumira kunze dhayagiramu kwairi. Iwe unogona kugadzira yako yekutanga macro izvozvi mumatanho mana ari nyore, kunyangwe kana usati wambozviita muhupenyu hwako.

Usati watanga kunyora macro, gadzirira folda yekutumira kunze kunze. Kwatiri, iyi ichava folda MaChati angu pa diski D. Saka, gadziriro dzese dzapera, ngatiitei macro.

1. Mubhuku rako rekushanda reExcel, vhura iyo tab yokuvaka (Developer) uye muchikamu kodhi (Code) tinya icon macro (Makorosi).

Cherechedza: Kana iwe ukagadzira macro kekutanga, saka, kazhinji, iyo tebhu yokuvaka (Developer) zvichavanzwa. Muchiitiko ichi, enda kune tab faira (Faira), tinya Parameters (Sarudzo) uye vhura chikamu Gadzirisa ribhoni (Gadzirisa Ribhoni). Muchikamu chekurudyi chehwindo, mune runyorwa Main tabs (Main Tabs) tarisa bhokisi riri padivi pe yokuvaka (Developer) uye tinya OK.

2. Ipa zita kune iyo nyowani macro, semuenzaniso, SaveSelectedChartAsImage, uye ita kuti iwanikwe mubhuku rebasa rino chete.
3. dzvanya sika (Gadzira), izvi zvichavhura iyo Visual Basic edhita hwindo, umo kutanga uye kupera kweiyo macro itsva kuchatoratidzwa. Mumutsara wechipiri, tevedzera zvinotevera macro zvinyorwa:

   ActiveChart.Export "D:My ChartsSpecialChart.png"

   

4. Vhara iyo Visual Basic Mharidzo uye pane tab faira (Filet) knead Save as (Sevha se). Sevha bhuku rako rekushanda se Macro-enabled Excel workbook (Excel Macro-Enabled Workbook, *.xlsm). Ndizvozvo, wazviita!

Zvino ngatimhanyei macro yatakangogadzira kuti tione kuti inoshanda sei. Imbomira zvishoma… Pane chimwezve chinhu chatinofanira kuita. Isu tinofanirwa kusarudza iyo Excel chati yatinoda kutumira kunze kwenyika nekuti macro edu anongoshanda nechati yakasarudzwa. Dzvanya chero kumucheto kwechati. Rakajeka grey furemu rinoonekwa rakatenderedza dhayagiramu rinoratidza kuti rakasarudzwa zvizere.

Vhura iyo tab zvakare yokuvaka (Developer) uye tinya chiratidzo macro (macros). Rondedzero yemacros inowanikwa mubhuku rako rebasa ichavhurwa. Simbisa SaveSelectedChartAsImage Uye chengetedza manya (Mhanyai).

Zvino vhura iyo folda yawakatsanangura kuti uchengetedze faira - panofanirwa kuve nemufananidzo . Png ine dhayagiramu inotumirwa kunze kwenyika. Unogona kuchengetedza machati mune imwe fomati nenzira imwechete. Kuti uite izvi, zvakakwana kuti uchinje mune macro . Png on .jpg or . Gif - sezvizvi:

ActiveChart.Export "D:My ChartsSpecialChart.jpg"

Ndizvo zvanhasi chete, uye ndinovimba mave nenguva yakanaka muchiverenga chinyorwa ichi. Ndinokutendai nekuteerera!