Difference between revisions of "Maps"

Line 13: Line 13:
 
==UI==
 
==UI==
  
XLCubed expects your data to be arranged in a particular way to create maps.
+
XLCubed expects your data to be arranged in a particular way to create maps. The columns should contain the following.
  
 
{| class="wikitable"
 
{| class="wikitable"
 +
! Column
 +
! Description
 +
|-
 
| Map Name
 
| Map Name
 
| Title of the map, a map will be created for each different name.
 
| Title of the map, a map will be created for each different name.
Line 29: Line 32:
 
|-
 
|-
 
| Colour (optional)
 
| Colour (optional)
| Defines the colour of the point plotted, can be a number or text. If no column is selected then all points will be the same colour. See [[Maps#Colours]]
+
| Defines the colour of the point plotted, can be a number or text. If no column is selected then all points will be the same colour. See [[Maps#Colours|Colours]]
 
|-
 
|-
 
| Size (optional)
 
| Size (optional)
Line 36: Line 39:
  
 
To create a Map from Excel simply highlight the relevant data and click the Map button [[File:MapButton.png]] in the XLCubed menu.
 
To create a Map from Excel simply highlight the relevant data and click the Map button [[File:MapButton.png]] in the XLCubed menu.
 +
 +
==Colours==
 +
 +
This column can contain numbers or text. If you have numbers the colours will be from a colour gradient, defined on the properties screen.

Revision as of 13:24, 18 April 2011

Introduction

XLCubed Maps are an optional extension which allow plotting geographic data directly in Excel and publishing to the XLCubed Web server.

You can plot the data locations, and optionally set the colour and size of the plotted points to show values.

MapSample.png

Video demonstration

For a tutorial, try watching our Map Videos

UI

XLCubed expects your data to be arranged in a particular way to create maps. The columns should contain the following.

Column Description
Map Name Title of the map, a map will be created for each different name.
Location Name Title of the data point, shown when you hover over the point
Latitude Latitude of the point.
Longitude Longitude of the point.
Colour (optional) Defines the colour of the point plotted, can be a number or text. If no column is selected then all points will be the same colour. See Colours
Size (optional) Defines the size of the point, this must be a number. If no column is selected then all points will be the same size

To create a Map from Excel simply highlight the relevant data and click the Map button MapButton.png in the XLCubed menu.

Colours

This column can contain numbers or text. If you have numbers the colours will be from a colour gradient, defined on the properties screen.