Maps can expose trends in adjoining regions that would be hidden in a spreadsheet table or a numeric chart. You create maps just as you create charts, and they can be placed next to data or on their own page. The mapping component of Quattro Pro can be included with a custom installation, or installed using Install-As-You-Go.
In this section, you'll learn about
creating and positioning maps
presenting data on maps
editing maps
customizing map legends
For more information about adding maps to spreadsheets, see "Reference: Adding maps to spreadsheets."
Creating and positioning maps
You can create a map from the sample data provided with Quattro Pro. Sample data is stored in datamap files and can be copied to a spreadsheet and combined with your own data. These files are installed with the Quattro Pro mapping component and contain statistical and geographic data related to various world regions.
You can use a Quattro Pro mapping expert to create maps representing data. This expert allows you to create floating maps or full-page maps. Quattro Pro calculates the full range of map data and assigns each map region one of six colors or patterns, depending on where that region lies in the data range.
After creating a map, you can move it anywhere on a spreadsheet and adjust its size to fit in a specified area. The region displayed on a map is an object. Legends, titles, and any additional graphics you add to a map are also map objects. Each object can be moved or resized independently.
You can also change the aspect ratio of a map. When you change a map's aspect ratio, you are changing the height and width proportions of the map.
Quattro Pro lets you view a map (or a portion of a map) with increased or reduced magnification. For example, if you zoom in on a map of Africa you can view a single country (for example, Egypt) on the map.
For additional information about sample datamap files, see "Example: Setting up map data."
To copy data from a datamap file to a new notebook
1 Click File Open.
2 Choose the drive and folder where the datamap file is stored.
Datamap files are usually located in the programs\datamaps folder.
3 Choose All files from the File type list box.
4 Double-click the datamap (.wb3) file you want to open.
5 Select the data you want to copy to your notebook.
6 Click Edit Copy.
7 Click File New.
8 Click Edit Paste.
To create a map
1 Select the cells containing the map data.
The first selected cell must contain the first map region name.
2 Click Insert Graphics Map.
3 Follow the directions provided by the Map Expert.
If the Check regions dialog box is displayed, you can replace the unknown region by choosing a region from the Region list box, and clicking Replace. You can also leave the unknown region by clicking Skip or Skip all.
To add cities to your map, click Mark points on your map during the Map Expert process.
4 Position the pointer at the upper-left corner of the desired position for the map.
5 Drag diagonally until the map is the required size.
Tip
To create a map on a separate page, enable the Map window option in the Destination area. To create a blank map, don't type any cell references in the Color or Pattern boxes.
To move a map
1 Select the border of a map.
2 Drag the border to move the map to a new position.
Tip
If you want to move multiple map objects as a unit; select an object, hold down Shift, and select additional objects.
To resize a map
1 Select the border of a map.
2 Drag a sizing handle to change the width or height of the map.
Tips
If you want to change the width and height without changing map proportions, drag a corner sizing handle.
If you want to resize multiple map objects as a unit; select an object, hold down Shift, and select additional objects.
To change the aspect ratio of a map
1 Select a map.
2 Click View, and click one of the following menu commands:
Floating chart-retains the proportions of the floating map, even when you print the map or display it on its own page
Printer preview-displays how the map looks when printed with the current page setup
Screen slide-displays the correct proportions for a map that you plan to use in an onscreen slide show
35mm slide-displays the correct proportions for a map that you plan to send to a slide service for processing into 35mm slides
Note
For information about printing maps, see "To print a chart or map."
To zoom in on a map
1 Select a map.
2 Right-click an area, and click Zoom in.
You can also
Return a map to its original magnification Right-click an area, and click Zoom to normal.
Reduce the magnification of a map Right-click an area, and click Zoom out.
Center a map on a point Right-click an area, and click Center.
Presenting data on maps
Colors and patterns can show ranges related to the data on a spreadsheet. You can include this information when you create a map, or you can add it to the map later. You can also remove the colors or patterns related to a data selection.
A map consists of one or more overlays with or without spreadsheet data. For example, a map of the United States usually shows state borders, but it may also show highways or the location of major cities. Each of these sets of boundaries or locations is called an overlay, because they can be laid on top of each other, like overhead transparencies or sheets of tracing paper. There are three types of overlays you can add to a map: region, static, and pin.
You can add region overlays to a map to display regional boundaries. You can also extend a map to include other regions. If you add another region to a map, make sure you add its region, color, and pattern data to the spreadsheet.
Unlike other types of overlays, static overlays do not require any notebook data. Static overlays display correctly only if they are appropriate for the current map. For example, a static overlay of United States highways is of no use in a map of Japan, so it will not display. Quattro Pro includes two static overlays: the U.S. Interstate Highways overlay, and the World Grid overlay. The U.S. Interstate Highways overlay marks in the major highways that cross the United States. The World Grid overlay adds longitude and latitude lines to the map.
Pin overlays can display locations of cities or towns. You can add pin overlays when you create a map or you can add them later. Before you add a pin overlay, make sure the spreadsheet data is organized correctly.
You can also add locations to a map using longitude and latitude. For example, you can show the location of important buildings, geographic landmarks, and towns or cities not included in one of the pin overlays.
You can change the appearance of a pin label by applying different font properties. As well, you can change the pin symbol that displays next to any label. For example, you can display symbols that represent schools, direction arrows, or other landmarks on a map.
To add color and pattern data to a map
1 Right-click a map, and click Map data.
2 In the Color data box, type the cell references for the data you want represented by colors.
3 In the Pattern data box, type the cell references for the data you want represented by patterns.
Tips
You can also add color and pattern data to a map by double-clicking the Map icon on the Objects sheet.
To remove color or pattern data, select the data to remove and press Delete.
To add a region overlay to a map
1 Right-click a map, and click Map data.
2 Click Add overlay.
3 In the Map Data dialog box, click the Region tab.
4 Choose a region from the list.
Note
When you create a map with the Map Expert, the first region overlay is added automatically.
To include another region on a map
1 Right-click a map, and click Map data.
2 Click Add overlay.
3 In the Map Data dialog box, click the Region tab.
4 Choose a region from the list.
5 Click OK.
6 In the Region names box, type the cell addresses for the new region.
7 In the Color data box, type the cell addresses for the new region data you want represented by color.
8 In the Pattern data box, type the cell addresses for the new region data you want represented by patterns.
Note
Quattro Pro can recognize regions belonging to installed maps only. For example, if a map contains data from states in India, Quattro Pro will not recognize those states as part of India unless the map India by State is installed.
To add a static overlay to a map
1 Right-click a map, and click Map data.
2 Click Add overlay.
3 In the Map Data dialog box, click the Static tab.
4 Choose a grid from the list.
To add a location to a map using a pin overlay
1 Right-click a map, and click Map data
2 Click Add overlay.
3 In the Map Data dialog box, click the Pin tab.
4 Enable the Use pin name option.
5 Choose a city overlay from the list.
6 In the Pin ID cells box, type the cell references containing the pin IDs.
7 In the Pin label cells box, type the cell references containing the pin labels.
To add a location to a map using longitude and latitude
1 Right-click a map, and click Map data
2 Click Add overlay.
3 In the Map Data dialog box, click the Pin tab.
4 Enable the Use lat/long option.
5 In the Name box, type a name for the overlay.
6 Click OK.
7 In the Latitude cells box, type the cell references containing the latitude values.
8 In the Longitude cells box, type the cell references containing the longitude values.
9 In the Pin label cells box, type the cell references containing the pin labels.
To change the appearance of pin labels on a map
1 Select a map.
2 Right-click a region on the map, and click Selection properties.
3 Click the Pin symbol tab.
4 Enable the Display pin labels check box.
5 Click the Font tab.
6 Modify any font properties.
Note
Pin labels display on a map only if you select them along with the pin names or latitude and longitude coordinates. If you do not include the labels in the selection, pin locations are marked with a symbol or left blank.
To change the appearance of pin symbols on a map
1 Select a map.
2 Right-click a region on the map, and click Selection properties.
3 Click the Pin symbol tab.
4 Enable the Display pin symbol check box.
5 Modify any font properties.
6 Choose a new symbol from the Symbol list.
Note
Pin labels display on a map only if you select them along with the pin names or latitude and longitude coordinates. If you do not include the labels in the selection, pin locations are marked with a symbol or left blank.
Editing maps
You can edit a map and its map objects by modifying the properties associated with each. As well, you can have your map redrawn automatically when you make changes to the spreadsheet data, or you can choose to manually update your map.
You can change a map border to coordinate with a color scheme used on the map. As well, you can change a map background to display colors, patterns, or wash effects.
Selecting different text properties like font, size, and color for titles, subtitles, and legend titles lets you change the appearance of titles. As well, you can edit map titles. For example, if you change the data shown in a map, you can update the titles to accurately reflect what data the map now displays.
You can also change the alignment of titles and subtitles.
To edit a map
1 Select a map.
2 Right-click an object on the map, and click Selection properties.
3 Modify any formatting settings.
To redraw a map
1 Select a map.
2 Right-click a region on the map, and click Selection properties.
3 Click the Redraw options tab.
4 Enable one of the following options:
Automatic-the map is updated every time the source data changes
Manual-the map is updated only when you click Redraw
To change the border of a map
1 Select the border of a map.
2 Click Format Selection properties.
3 Click the Border color tab.
4 Click the color palette.
5 Click a color on the palette.
6 Click the Box type tab.
7 Choose a new line style.
If you want to create a drop shadow behind the border, enable the Drop shadow check box.
To change the background of a map
1 Select a map.
2 Right-click the background of the map, and click Selection properties.
3 Enable one of the following options:
Pattern-lets you choose a solid color or two-color pattern
Wash-lets you choose a wash effect using one or two colors
Bitmap-lets you insert a bitmap image of your choice as the background
None-lets you leave the background blank
4 Modify any color or style settings.
Note
Background fill options are overridden if you make the background transparent. For information about making a background transparent, see "To make a map background transparent."
To make a map background transparent
1 Select the border of a map.
2 Click Format Selection properties.
3 Click the Box type tab.
4 Enable the Transparent check box.
To edit a map title
1 Right-click a map, and click Titles.
2 In the Main title box, type a new main title.
3 In the Subtitle box, type a new subtitle.
4 In the Legend box, type a new legend title.
To change text properties for a map title
1 Select a map.
2 Right-click a title on the map, and click Selection properties.
3 Click the Text font tab.
4 Modify any settings.
5 Click the Text settings tab.
6 Modify any settings.
To change the alignment of map titles
1 Select a map.
2 Right-click a title on the map, and click Selection properties.
3 Click the Alignment tab.
4 Choose a new alignment.
Customizing map legends
In Quattro Pro, legends are map objects that help control how data is represented on the map. You can add a map legend title at any time. You can also add new text to the legend.
You can edit the colors or patterns displayed in a legend. The position of a map legend can also be changed.
To add a title to a map legend
1 Select a map.
2 Right-click the legend, and click Selection properties.
3 Click the Title tab.
4 Enable the Show legend title check box.
5 Type the title in the Legend title box.
To add text to a map legend
1 Select a map.
2 Right-click the legend, and click Selection properties.
3 Click one of the following tabs:
Colors
Patterns
4 Type text in the Legend text boxes.
Tip
If you want to display only numeric values in the legend, leave the Legend text boxes blank.
To edit colors or patterns in a map legend
1 Select a map.
2 Right-click the legend, and click Selection properties.
3 Click one of the following tabs:
Colors
Patterns
4 Select a new color or pattern next to each color or pattern bin.
You can also
Exclude color or pattern data from a map legend Enable the Set bin values manually and Require exact match check boxes.
Change values in a map legend Enable the Set bin values manually check box and enter new values in the Maximum value boxes.
Hide color or pattern data in a map legend Disable the Show legend check box.
To change the position of a map legend
1 Select a map.
2 Right-click the legend, and click Selection properties.
3 Click the Legend position tab.
4 Choose a new legend position.
Tip
You can also change the position of a map legend by dragging it to a new position.
Reference: Adding maps to spreadsheets
When creating a map, Quattro Pro automatically selects the most appropriate map from those available, and then assigns colors or patterns to each region. Before you create a map, it is important to arrange the data from which a map will be created in a suitable format.
Example: Setting up map data
Quattro Pro automatically fills in a map with the data you provide. For Quattro Pro to interpret data correctly, enter it on the spreadsheet in the following sequence:
If you include latitude and longitude decimal values to identify a location, enter them in the following order:
Column A contains region names or IDs. You can list country names in full, (for example, United Kingdom, France, Germany), or you can list standard abbreviations (for example GB, FR, DE).
Column B contains color data associated with each region name. Variations in this set of data display as different colors in the map. Color data can be either numbers or text.
Column C contains pattern data associated with each region name. Variations in this second set of data display as different patterns in the map. Pattern data can be either numbers or text.
Column D contains either (1) the pin location or (2) latitude.
Column E contains either (1) the pin label or (2) longitude.
Column F contains pin labels if you have entered latitude and longitude in Columns D and E.
Latitude is expressed as degrees, minutes, and seconds north or south of the equator.
Longitude is expressed as degrees, minutes, and seconds east or west of the prime meridian that runs through Greenwich, England.
For Quattro Pro to interpret latitude and longitude coordinates, you must convert them to decimals. The simplest way to convert coordinates to decimals is to use the @LLDEC function to create a new series. The resulting coordinates are preceded by a minus sign if they are south of the equator or west of the prime meridian. For example, the longitude coordinate 38╫20'40"W converts to -38.334444. For more information about converting latitude and longitude values to decimals, see the Quattro Pro spreadsheet function @LLDEC in the Reference Information/Functions Help section of the online Help.
Map data is easier to select when you arrange it in adjacent columns. If a notebook has blank columns or columns containing other data between the map data columns, you need to exclude those columns.
