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.
|
|
•
|
|
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.
|
|
•
|
|
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.
|
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 by 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 by 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 val
ues. |
|
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.
|
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.
|