It is currently Thu Jun 20, 2024 5:57 am

All times are UTC




Post new topic Reply to topic  [ 2 posts ] 
Author Message
PostPosted: Mon Dec 20, 2010 8:12 pm 
Offline
Site Admin

Joined: Thu Jul 01, 2010 9:06 am
Posts: 175
Sometimes, when you zoom in (maximum = 400%),
you can see on the map that some countries have been moved.

It is very annoying because some countries have been moved as if they were islands!

THIS IS DUE TO AN EXCEL BUG ! THE SPREADSHEET DOESN'T HANDLE WELL THE UNGROUP FUNCTION !

To solve this problem nicely (not just by putting a bigger border that hides the gap), you have to
  • download the map inside PowerPoint (by using the "" function)
  • select the complete map (by covering the map area with your mouse)
    explanation: http://www.begraphic.com/forum/viewtopic.php?f=11&t=88
  • ungroup all shapes (several times... because groups can include sub-groups)
  • as Microsoft Office (both PowerPoint or Excel) often duplicates shape (ANOTHER MICROSOFT BUG),
    you have to kill all clones except one (e.g.: the Florida state map can be put 2 or 3 times, including with or without border)
  • regroup all last freeforms in one single shape
  • resize the shape (right-click the shape to access the "Size & Position" function)
  • export the map (copy and paste) to Excel
  • inside Excel, ungroup the map

By using this procedure, you avoid the buggy Excel ungrouping function (and use the PowerPoint's one that works fine).

.


Top
 Profile Send private message  
 
PostPosted: Thu Mar 26, 2015 8:21 am 
Offline

Joined: Thu Mar 26, 2015 8:17 am
Posts: 1
... a comprehensive measure of the total value of all food expenditures by final purchasers. ... The series also constitutes a measure of total sales through different food ... ERS provides estimates of food eaten away from home and food eaten at ... that were consumed at home, by selected countries, 2013, Download as Excel ...

_________________
Cut down your exam stress by using our latest Testking ccna answers and questions by using our latest exam testking ielts exam We also offer up-to-date hartford.edu and answers for your prep of


Top
 Profile Send private message  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ] 

All times are UTC


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB® Forum Software © phpBB Group