您的Excel® 基于制图解决方案
enzh

Functionalities

Scenarii - Portions Charts

Portions Charts

Description

This representation is generally used to compare two sets of data, such as the classic prospects over customers, but it can be applied in many other fields, such as imported goods vs domestically produced ones.

Each surface and each point on the working map receives a circle divided into sectors (one for each input). Each sector is a regular portion of the circle. If there are four inputs, the circle is divided into four equal portions. Each portion has its own color. The surface of each portion is proportional to the data input.

Input data

Two sets of quantitative and numeric data.

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 Portion size is automatic. If the box Automatic size is not selected you can choose the size of the portions. The unit is the same than the one for the map.

At first the Portion size is automatic. If the box Automatic size is not selected you can choose the size of the portions. The unit is the same than the map.


Colors

For each data set you can choose a color. Just click on the color zone and choose a new color. Portions can be drawn with borders by ticking in the box With border and changing its color

For each data set you can choose a color. Just click on the color zone and choose a new color.

Portions can be drawn with borders by ticking in the box With border and changing its color


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 and the font.

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

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

Caption steps allows to choose the number of class to represent proportional data. Limit values can be modified after un-selecting Automatic caption values.


Example

This representation is generally used to compare two sets of data, such as the classic prospects over customers, but it can apply to many other fields, such as imported goods vs domestically produced ones.

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

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