Creating map charts

Map charts can display locations or locations and associated values.

To display only locations, use a pin chart. A pin chart requires only a data series name and a reference to location information. Optionally, it can include location labels.

Any of the values charts requires a data series name, reference to location information, and a reference to the values to be represented. Optionally, it can include location labels and category labels.

To create a map chart:

  1. Click Map Chart Wizard on the Objects tool bar.
  2. Select the type of chart to display on the map, or select Pin to display location indicators.
  3. Click Next.
  4. Specify the data series name.
    You can specify a name or browse and select, for example, a variable name.
  5. Either select:
    • Latitude and longitude and specify the references of the cells which contain the Latitude and Longitude values.
    • Address and specify the references of the cells which contain the location addresses.
    To specify a range of cells, specify the references of the first and last cells in the range, separated by a colon. For example L31:L55.
  6. Specify the range of cells which contain the chart values.
    If you are creating a pin chart, the Values source field is disabled.
  7. Specify the reference of the cell which contains the category labels of the chart - for example, the heading of the column which contains the chart values.
    Category labels are displayed when you double-click a chart and rest the mouse pointer on a data series. The Category labels field is disabled for pin charts.
  8. Optionally, specify the reference of the cell which contains the location labels.
    The location is displayed when you rest the mouse pointer on a chart.
  9. Click Finish.
    A map is displayed, without charts or location information.
  10. Drag the edges of the chart to the required dimensions.
  11. Click Data Series.
    The data series of the map chart are listed. The first data series is selected by default and its properties are displayed in the Data Series Properties tool bar. The map is populated with the selected data series.
  12. To edit a data series, select it and click Edit in the Data Series Properties tool bar.
    See Editing the data series of a map chart.
  13. Close the Data Series Properties tool bar.
  14. Save the report.
Parent topic: Map charts