| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "Maps"
| Line 2: | Line 2: | ||
XLCubed Maps are an optional extension which allow plotting geographic data directly in Excel and publishing to the XLCubed Web server. | 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. | ||
[[File:MapSample.png|center|thumb|300px]] | [[File:MapSample.png|center|thumb|300px]] | ||
| Line 10: | Line 12: | ||
==UI== | ==UI== | ||
| + | |||
| + | XLCubed expects your data to be arranged in a particular way to create maps. | ||
| + | |||
| + | {| class="wikitable" | ||
| + | | 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 [[Maps#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 [[File:MapButton.png]] in the XLCubed menu. | ||
Revision as of 14:23, 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.
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.
| 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 Maps#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 
in the XLCubed menu.
