txheem
Tom qab nyeem tsab xov xwm no, koj yuav kawm paub yuav ua li cas los tsim ib daim duab sib cais (.png, .jpg, .bmp lossis lwm hom) los ntawm daim ntawv qhia hauv Excel lossis xa tawm nws, piv txwv li, mus rau Word daim ntawv lossis kev nthuav qhia PowerPoint.
Microsoft Excel yog ib qho ntawm cov ntaub ntawv txheeb xyuas cov ntaub ntawv muaj zog tshaj plaws. Hauv nws lub arsenal muaj ntau yam cuab yeej thiab kev ua haujlwm rau kev pom cov ntaub ntawv no. Cov kab kos (lossis graphs) yog ib qho cuab yeej zoo li no. Txhawm rau tsim ib daim ntawv qhia hauv Excel, koj tsuas yog yuav tsum xaiv cov ntaub ntawv thiab nyem rau ntawm daim ntawv qhia icon nyob rau hauv seem ntawv qhia zaub mov.
Tab sis, hais txog qhov zoo, nws yog qhov yuav tsum tau hais txog qhov tsis muaj zog. Hmoov tsis zoo, tsis muaj txoj hauv kev yooj yim hauv Excel kom txuag tau daim ntawv qhia ua duab lossis xa mus rau lwm daim ntawv. Nws yuav zoo yog tias peb tuaj yeem nyem nyem rau ntawm daim duab thiab pom cov lus txib zoo li Txuag raws li kev kos duab or export. Tab sis, txij li Microsoft tsis tau saib xyuas tsim cov haujlwm zoo li no rau peb, ces peb yuav los nrog peb tus kheej.
Hauv tsab xov xwm no, kuv yuav qhia koj 4 txoj hauv kev los cawm daim ntawv Excel ua ib daim duab uas koj tuaj yeem muab tso rau hauv lwm cov ntaub ntawv Office, suav nrog Lo Lus thiab PowerPoint, lossis siv nws los tsim qee cov infographics txaus nyiam.
Luam daim duab mus rau cov duab editor thiab khaws cia ua ib daim duab
Ib tug phooj ywg ntawm kuv ib zaug tau qhia tsis pub lwm tus paub nrog kuv: nws feem ntau luam nws cov kab kos los ntawm Excel rau Xim. Nws tsim ib daim ntawv qhia thiab tsuas yog nias tus yuam sij Tshuab luam tawm, ces qhib Xim thiab pastes lub screenshot. Tom qab ntawd, nws qoob loo qhov tsis xav tau ntawm cov duab thiab txuag cov duab ntxiv rau hauv cov ntaub ntawv. Yog tias koj tau ua ib yam li ntawd los txog tam sim no, ces theej tsis nco qab thiab tsis txhob siv txoj kev me nyuam yaus no ntxiv! Peb yuav ua sai dua thiab ntse dua! 🙂
Piv txwv li, hauv kuv Excel 2010, kuv tau tsim ib daim duab zoo nkauj XNUMX-D daim duab qhia txog cov ntaub ntawv hais txog cov pej xeem ntawm peb cov neeg tuaj saib, thiab tam sim no kuv xav xa daim ntawv qhia no los ntawm Excel ua daim duab. Cia wb ua nws ua ke:
- Txoj nyem rau ntawm daim ntawv qhia cheeb tsam thiab nyem Copy (Copy). Tsis tas yuav nyem rau ntawm daim duab nws tus kheej, vim qhov no yuav xaiv tus kheej cov ntsiab lus, thiab tsis yog tag nrho daim duab, thiab cov lus txib. Copy (Copy) yuav tsis tshwm.
- Qhib Paint thiab paste daim ntawv siv lub icon Insert (Paste) tab Tsev (Tsev) thiab nias Ctrl + V.
- Tam sim no nws tseem tsuas yog khaws cov duab kos ua cov duab nraaj. Nyem Txuag li (Txuag li) thiab xaiv ib qho ntawm cov tswv yim tawm tswv yim (.png, .jpg, .bmp lossis .gif). Yog tias koj xav xaiv lwm hom ntawv, nyem Lwm hom ntawv (Lwm hom ntawv) tom kawg ntawm daim ntawv.
Nws tsis yooj yim dua! Txhawm rau txuag daim ntawv Excel hauv txoj kev no, txhua tus neeg kho duab yuav ua.
Export ib daim ntawv los ntawm Excel rau Lo Lus lossis PowerPoint
Yog tias koj xav tau xa tawm daim ntawv qhia los ntawm Excel mus rau lwm daim ntawv thov Office, xws li Word, PowerPoint, lossis Outlook, txoj hauv kev zoo tshaj los ua qhov no yog los ntawm cov ntawv teev cia.
- Luam daim ntawv los ntawm Excel raws li hauv qhov piv txwv dhau los ntawm Kauj ruam 1.
- Hauv ib daim ntawv lo lus lossis PowerPoint kev nthuav qhia, nyem qhov koj xav ntxig daim duab thiab nyem Ctrl + V. Los yog tsis txhob nias Ctrl + V, right-click nyob qhov twg hauv daim ntawv, thiab tag nrho cov txheej txheem ntxiv yuav qhib rau pem hauv ntej ntawm koj hauv ntu Paste Options (Kev xaiv muab tshuaj txhuam).
Lub ntsiab kom zoo dua ntawm txoj kev no yog tias nyob rau hauv txoj kev no ib daim ntawv qhia ua haujlwm Excel raug xa tawm mus rau lwm cov ntaub ntawv, thiab tsis yog daim duab xwb. Daim duab yuav txuas mus rau daim ntawv Excel qub thiab yuav hloov kho thaum cov ntaub ntawv hauv Excel daim ntawv hloov pauv. Qhov no txhais tau hais tias koj tsis tas yuav luam thiab muab daim ntawv qhia dua nrog txhua qhov kev hloov pauv hauv cov ntaub ntawv siv los tsim nws.
Txuag ib daim duab hauv Lo Lus thiab PowerPoint raws li daim duab
Hauv Chaw Ua Haujlwm 2007, 2010, thiab 2013 daim ntawv thov, daim ntawv Excel tuaj yeem luam tawm raws li daim duab. Hauv qhov no, nws yuav coj tus cwj pwm zoo li daim duab ib txwm muaj thiab yuav tsis hloov kho. Piv txwv li, cia peb xa daim ntawv Excel rau ib daim ntawv Word 2010.
- Hauv Excel phau ntawv ua haujlwm, luam daim ntawv, tom qab ntawd qhib cov ntaub ntawv Word, tso tus cursor qhov twg koj xav muab daim ntawv qhia, thiab nyem rau lub xub dub me me hauv qab ntawm lub pob. Insert (Paste), uas nyob rau ntawm lub tab Tsev (Lub tsev).
- Hauv cov ntawv qhia zaub mov uas qhib, peb txaus siab rau cov khoom Paste tshwj xeeb (Paste Tshwj Xeeb) - Nws yog qhia los ntawm ib tug xub nyob rau hauv lub screenshot saum toj no. Nyem rau ntawm nws - lub thawv sib tham ntawm tib lub npe yuav qhib nrog cov npe ntawm cov duab muaj nyob, suav nrog Bitmap (bitmap), GIF, PNG thiab JPEG.
- Xaiv cov hom ntawv xav tau thiab nyem OK.
Feem ntau yuav yog ib lub cuab yeej Paste tshwj xeeb (Paste Tshwj Xeeb) kuj muaj nyob rau hauv cov ntawv ua ntej ntawm Chaw Ua Haujlwm, tab sis lub sijhawm ntawd kuv tsis tau siv, yog li kuv yuav tsis hais 🙂
Txuag tag nrho Excel phau ntawv ua haujlwm raws li cov duab
Cov hau kev uas peb nyuam qhuav tham tau yooj yim thaum nws los txog rau ib qho me me ntawm daim duab. Tab sis yuav ua li cas yog tias koj xav tau luam tag nrho cov kab kos los ntawm Excel phau ntawv ua haujlwm? Yog tias koj luam thiab muab tshuaj txhuam lawv tus kheej, nws tuaj yeem siv sijhawm ntev heev. Kuv maj mam ua kom haum koj - koj tsis tas yuav ua qhov no! Muaj ib txoj hauv kev los cawm tag nrho cov kab kos los ntawm Excel phau ntawv ua haujlwm ib zaug.
- Thaum koj ua tiav tsim cov kab kos hauv koj phau ntawv ua haujlwm, nyem qhov cov ntaub ntawv (Cov ntaub ntawv) thiab nyem lub pob Txuag li (Txuag li).
- Ib lub dialog box yuav tshwm sim Txuag ib daim ntawv (Txuag li). Hauv daim ntawv teev npe Cov Ntaub Ntawv Hom (Txuag li hom) xaiv Webpage (Web page, *.htm, *.html). Kuj xyuas qhov ntawd hauv seem Txuag (Txuag) xaiv xaiv Phau Ntawv (Tag nrho Phau Ntawv Ua Haujlwm) raws li qhia hauv lub screenshot hauv qab no:
- Xaiv ib lub nplaub tshev kom txuag tau cov ntaub ntawv thiab nyem lub pob Txuag (Txuag).
Mus rau lub nplaub tshev xaiv nrog rau cov ntaub ntawv .html Tag nrho cov kab kos muaj nyob hauv Excel phau ntawv ua haujlwm raws li cov ntaub ntawv yuav raug theej . Png. Lub screenshot hauv qab no qhia cov ntsiab lus ntawm daim nplaub tshev uas kuv khaws kuv phau ntawv ua haujlwm. Kuv phau ntawv ua haujlwm Excel muaj peb nplooj ntawv nrog daim ntawv qhia ntawm txhua tus - thiab hauv daim nplaub tshev uas kuv tau xaiv, peb pom peb daim ntawv khaws tseg ua cov duab nraaj . Png.
Raws li koj paub, PNG yog ib qho ntawm cov duab compression zoo tshaj plaws uas tsis muaj qhov tsis zoo. Yog tias koj xav siv lwm hom duab, ces hloov lawv mus rau .jpg, . Gif, .bmp ua los yog lwm yam yuav tsis nyuaj.
Txuag ib daim ntawv ua duab siv VBA Macro
Yog tias koj feem ntau xav tau xa tawm cov kab kos Excel ua cov duab, koj tuaj yeem ua txoj haujlwm no siv VBA macro. Hmoov zoo, muaj ntau yam macros tau sau, yog li peb tsis tas yuav rov tsim lub log 🙂
Piv txwv li, koj tuaj yeem siv cov kev sim thiab qhov tseeb tshaj tawm los ntawm John Peltier ntawm nws qhov blog. Nws macro yog yooj yim heev:
ActiveChart.Export "D:My ChartsSpecialChart.png"
Cov kab ntawm cov cai no tsim cov duab nraaj hauv cov ntawv teev cia . Png thiab export daim duab rau nws. Koj tuaj yeem tsim koj thawj macro tam sim no hauv 4 cov kauj ruam yooj yim, txawm tias koj tsis tau ua nws ua ntej hauv koj lub neej.
Ua ntej koj pib sau cov macro, npaj cov ntawv tais ceev tseg rau daim ntawv xa tawm. Hauv peb cov ntaub ntawv, qhov no yuav yog daim ntawv tais ceev tseg Kuv Daim Ntawv Qhia ntawm disk D. Yog li, tag nrho cov kev npaj tiav, cia peb ua cov macro.
- Hauv koj phau ntawv ua haujlwm Excel, qhib lub tab tsim tawm (Tus tsim tawm) thiab hauv ntu Code (Code) nyem icon Ntsig (Macros).
Nco ntsoov: Yog tias koj tsim lub macro thawj zaug, ces, feem ntau yuav, tab tsim tawm (Tus tsim tawm) yuav muab zais. Hauv qhov no, mus rau lub tab cov ntaub ntawv (Cov ntaub ntawv), nyem tsis (Kev xaiv) thiab qhib ntu Configure ribbon (Customize Ribbons). Nyob rau sab xis ntawm lub qhov rais, hauv cov npe Main tabs (Main Tabs) khij lub npov nyob ib sab ntawm tsim tawm (Developer) thiab nias OK.
- Muab lub npe rau lub macro tshiab, piv txwv li, SaveSelectedChartAsImage, thiab ua kom nws tsuas muaj rau phau ntawv no xwb.
- xovxwm tsim (Tsim), qhov no yuav qhib qhov Visual Basic editor qhov rai, uas qhov pib thiab qhov kawg ntawm macro tshiab yuav raug qhia. Hauv kab thib ob, luam cov ntawv macro hauv qab no:
ActiveChart.Export "D:My ChartsSpecialChart.png" - Kaw lub Visual Basic Editor thiab ntawm lub tab cov ntaub ntawv (Filet) knead Txuag li (Txuag li). Txuag koj phau ntawv ua haujlwm li Macro-enabled Excel phau ntawv ua haujlwm (Excel Macro-Enabled Workbook, *.xlsm). Qhov ntawd yog nws, koj tau ua nws!
Tam sim no cia peb khiav lub macro peb nyuam qhuav tsim los saib seb nws ua haujlwm li cas. Tos ib pliag... Muaj ib qho ntxiv uas peb yuav tsum ua. Peb yuav tsum xaiv daim ntawv Excel peb xav xa tawm vim tias peb cov macro tsuas yog ua haujlwm nrog cov ntawv xaiv. Nyem qhov twg ntawm ntug ntawm daim ntawv. Lub teeb grey ncej uas tshwm nyob ib ncig ntawm daim duab yuav qhia tau tias nws tau xaiv tag nrho.
Qhib lub tab dua tsim tawm (Developer) thiab nias lub icon Ntsig (macros). Ib daim ntawv teev cov macros muaj nyob hauv koj phau ntawv ua haujlwm yuav qhib. Qhov tseem ceeb SaveSelectedChartAsImage Thiab nias qhov khiav (Khiav).
Tam sim no qhib lub nplaub tshev uas koj tau teev tseg kom txuag tau cov ntaub ntawv - yuav tsum muaj daim duab . Png nrog daim duab exported. Koj tuaj yeem txuag cov kab kos hauv ib hom ntawv sib txawv hauv tib txoj kev. Txhawm rau ua qhov no, nws txaus los hloov pauv hauv macro . Png on .jpg or . Gif - zoo li no:
ActiveChart.Export "D:My ChartsSpecialChart.jpg"
Qhov ntawd yog txhua yam rau hnub no, thiab kuv vam tias koj tau muaj sijhawm zoo nyeem cov ntawv no. Ua tsaug rau koj mloog!