您的Excel® 基于制图解决方案
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.

版权 © 2009-10 ARTICQUE USA LLC. 版权所有. MapInXL是ARTICQUE美国有限责任公司的注册商标.
微软®™, 微软®™ Office®™, Excel®™, 和Windows®™ 是微软公司的商标或注册商标.

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