Saka taswira a cikin Excel - sami haɗin haɗin ƙasa - haɗin UTM

Map.XL wani aikace-aikacen da ke ba ka damar saka taswira a cikin Excel kuma samun daidaito kai tsaye daga taswirar. Hakanan zaka iya nuna jerin latitudes da tsawo a taswirar.

Yadda za a saka taswira a Excel

Da zarar an shigar da shirin, ana ƙara shi azaman ƙarin shafin da ake kira "Taswira", tare da ayyukan Map.XL.

Kafin shigar da taswirar dole ne ka saita taswirar baya, ana yin wannan a cikin gunkin "Map Provider". Yana yiwuwa a saita bayanan baya ta amfani da taswirori biyu, azaman hoto ko matasan sabis:

• Google Duniya / Taswirai
• Taswirar Bing
• Bude Street Maps
• ArcGIS
• Yahoo
• Yaro
• Yandex

Taswirar yana nuna dama zuwa dama, amma za'a iya ja shi don yana iyo, ko kuma a kasa / saman kan tebur.

Wannan bidiyo ta taƙaita yadda ake aiwatar da dukan tsarin da aka bayyana a cikin wannan labarin, yayi aiki a kan shimfiɗar wani makirci ta amfani da Taswirar Bing azaman baya.

[ulp id='hIYBDKfRL58ddv8F']

Yadda za a sami daidaito daga Excel

Ana yin wannan tare da alamar "Samu daidaitawa". Ainihin tsarin shine:

• Latsa "Sai A hankali,
• Danna kan taswira,
• Danna maɓallin Excel
• Manna, ta amfani da "Ctrl + V", ko maɓallin linzamin kwamfuta na dama kuma zaɓi Manna.

Yadda za a yi lissafin Ma'aikata

Samfurin da aka nuna a misalin bidiyon, Geofumadas ya gina shi, kuma yana ba ka damar manna haɗin gwargwadon gwargwadon mai ganowa, don haka daga bisani zasu bi da layin latitude da tsawo.

MapXL kyauta ne, kuma zaka iya zazzage shi daga wannan mahaɗin. Hakanan zaku sauke tebur na Excel wanda aka yi amfani dashi a cikin misalin.

Aika haɗin kai zuwa taswirar.

Ana yin wannan tare da alamar “Ad markers”, bayan zaɓar yankin teburin da ke da sha'awa. Sa'an nan kuma wani nau'i ya bayyana yana nuna wane filin ne latitude, wanda shine Longitude, dalla-dalla na haɗin gwiwa da alamar taswirar. Don cire su kawai dole ne ku yi "Cire Alamomi".

Sauke nan Map.XL, ciki har da samfurin Excel.

[ulp id='hIYBDKfRL58ddv8F']

Wannan bidiyo yana nuna tsarin da aka bayyana a cikin wannan labarin, ta yin amfani da alamar alama ta yawon shakatawa a kan wani dutsen mai fitattun wuta, ta yin amfani da Open Street Maps a matsayin bango.

Dubi haɗin UTM akan taswira daga Excel:

zaka iya samun samfurin a nan.