SpreadsheetWEB Wizard also allows the user to integrate maps into their spreadsheet that can then be converted with the wizard. The option can be found under the SpreadsheetWEB ribbon menu.
"Maps" in the SpreadsheetWEB ribbon.
A wizard will appear, prompting the user to begin by selecting a region. Regions supported by SpreadsheetWEB include the world and continents, USA and counties, USA regions, Europe (by countries), Europe (by regions), United Kingdom, North America, South America, Central America, Canada (Provinces and Territories), Asia, Middle East, Oceania, and Africa. The user can then choose a map from the "Select Map" list.
Choose a region and a map from the list available.
The second page allows the user to select certain data that will be mapped. The option labeled "Data Label Range" allows the user to identify certain IDs within the spreadsheet that will correspond to locations on the map. The IDs can be internal IDs, short name, or long name. For instance, for a map of the United States (by states), an acceptable identifier for the state of New York would be either "New York" or "NY."
Selecting a data label range using long names of the states.
The second option, "Data Range," allows the user to select the range of data that corresponds to the labels.
Selecting an appropriate data range that corresponds to the data labels as shown in the previous Figure.
After the user presses "Next," the wizard will compare the "Data Label Range" with acceptable identifiers in the map and a warning message will be shown if there is a mismatch.
The third page allows the user to customize map options. Map Drill Down will provide a label to the information being seen by the end-user. By pressing the button and selecting a cell, the user defines that cell to display the ID of the region when it is selected. For instance, in a map of the United States (by states), if the state of New York is selected on the map, then the cell selected as the Map Drill Down will display the name "New York" or "NY" depending on the data label selected in the "Data Label Range."
If there are map dependencies, using the map drilldown will also allow for dynamic inputs and calculations. For example, if there is population information for the past twenty years for all of the states and a graph to represent it, clicking on various states on the map will alter the graph to display the information for that particular state.
Options available for the map in step 3.
This page also allows the user to determine the map color from a list and decide whether the map will show labels, shadows, and tooltips.
After the user presses "Finish," an image object will be inserted into the grid. The user can then move and resize the image although it will simply be a static image of the map selected on the first page of the wizard. The user can right click or double click on the map for map properties. Editing the map will open up the map wizard with pre-selected properties, allowing the user to edit them.
Completed map shows up in the Excel spreadsheet.
Completed map shows up in the web application.
OR Check out the online video!