http://begraphic.com/forum/ |
|
How to use BeGraphic to make live-data custom maps? http://begraphic.com/forum/viewtopic.php?f=11&t=24 |
Page 1 of 1 |
Author: | BeGraphic Team [ Mon Jul 05, 2010 2:44 pm ] |
Post subject: | How to use BeGraphic to make live-data custom maps? |
Thematic maps / Live-data custom maps History: Thematic maps are also called choropleth maps or tinted maps. This colourful name is the exact title given by French Baron Pierre Dupin in 1826 to his new type of map showing the “Forces productives et commerciales de la France”. The terminology “choropleth map” came later, introduced by the American geographer John Kirtland Wright (1938: “Problems in Population Mapping”). Then came other designations: ‘intensity map”, “thematic map” (with customized editable maps), "interactive maps", “dynamic map”. How to use BeGraphic to make your custom map in Microsoft Excel and PowerPoint? Click on the “Geographical map” function (inside BeGraphic) to build maps in Excel: Size and position the red dashed rectangle in the sheet to the right place. This is the maximum size of your future map. Position (step 1): You have to position the red dash rectangle to the right place in the worksheet. It represents the position and the maximum size of the gauge.
Then, click on the “Validate step 1” button. Position (step 2): This parameter is about the ratio aspect. If you want your gauge keep its aspect (not distortion), select YES and define the anchor point to position it in the red dashed rectangle. Only the width or the height of the gauge will have the maximum size of the initial red dashed rectangle. If you want a gauge which fills the entire red dashed rectangle, select NO, but the gauge may be distorted. Once you have selected the option, click on the “Validate step 2” button. Select the map in the library
To add maps in the library, click on the “Add new maps in the library” button (2). This is optional. Once you have chosen a map, click on “Insert in Excel” (3). Prepare your data inside Excel 1. Put your data inside the table. 2. Use cell-based conditional formatting (no range-based). This format will be applied to the shapes linked to these cells. Set up BeGraphic 1. Select the shape (Freeform, AutoShape, Picture...) you want to set up. 2. Make a right-click on it to access the "Set parameters" function. Since Excel 2007: To find the "Set parameters" function, please use its button in the ribbon. 3. Choose the cell(s) that will control the animation of the shape. Indeed BeGraphic will duplicate the cell's format on the shape's one. Then validate. Here is an example when all countries are set up: You can see the how-to tutorial video of an example here. Put dynamic details (optional)
Example of a thematic map in Excel
|
Page 1 of 1 | All times are UTC |
Powered by phpBB® Forum Software © phpBB Group https://www.phpbb.com/ |