Your Excel® based mapping solution
enzh

Functionalities

Scenarii - Bar Charts

Bar Charts

Description

This representation can be used to display historical data sets: growth of sales over several years, evolution of a population, evolution of votes over a given period, etc.

A histogram is assigned to each surface and point on the working map. All the bars are of the same width, but their height is proportional to the values. Each bar has its own color.

Input data

Quantitative and numeric data for each sector.

Properties

Each property can be changed according to two methods: directly with the ribbon, or indirectly with the dialog boxes. These boxes contain more information and appear by double-clicking on the working map selection.
Each property can be changed according to two methods: directly with the ribbon, or indirectly with the dialog boxes. These boxes contain more information and appear by double-clicking on the working map selection.

Size

At first the bar size is automatic. If the box Automatic size is not selected you can choose the height and the width of the maximum bar value (Its value is indicated in the box value) The unit is the same than the one for the map.

At first the bar size is automatic. If the box Automatic size is not selected you can choose the height and the width of the maximum bar value (Its value is indicated in the box value) The unit is the same than the one for the map.


Colors

The table Columns matches classes and colors. The row table number equals to the number of data columns. Pre-defined palettes can be chosen (Spring, Autumn, Grey, etc) but each class color can be changed by clicking on its color zone.

The table Columns matches classes and colors. The row table number equals to the number of data columns.

Pre-defined palettes can be chosen (Spring, Autumn, Grey, etc) but each class color can be changed by clicking on its color zone.


Caption

You can choose to see or not the caption on your map with the box show the caption

You can choose to see or not the caption on your map with the box show the caption

You can modify the titles for each caption (Pie and proportional) and the font.

At first the caption size is automatic. If the box Automatic size is un-selected you can choose the caption size.

Number precision allows to choose the number of numerals after and before the comma.


Example

This representation can be used to display historical data sets: growth of sales over several years, evolution of a population, evolution of votes over a given period, etc.

Copyright © 2009-10 ARTICQUE USA LLC. All rights reserved. MapInXL is a registered trademark of ARTICQUE USA LLC.
Microsoft®™, Microsoft®™ Office®™, Excel®™, and Windows®™ are trademarks or registered trademarks of Microsoft Corporation.

Want More ? Geocoding, Geo Marketing… Go visit on Articque.com