Manage Pie Chart Data

The software supports up to 8 sets of data per region on the pie charts. Managing pie chart data can be done through the Data Grid. You can also export the data values, modify in Microsoft Excel and import back into the Data Grid.

• Using the pie chart data grid
• Import and export pie chart data

Using the pie chart data grid

The Pie Chart Data Grid is similar to the one in Region Properties. You can open tit by expanding the Map Properties Panel to the right side of the software. Pie chart can be seen under the Map Features section. Click the Edit Pie Chart in Data Grid button.

Here is the complete list of properties you can edit through Data Grid. Some columns include extra functions that can be applied to all regions on the map. Right click on one of the cells and select the function from the context menu.

Properties	Description
Title/Abbreviation	The name or abbreviation of the region shown in Regions Abbreviation or Regions Tooltip. This column is not editable in this Data Grid, but you can change this using the Region Properties Data Grid.
Item 1-8	Data for plotting the pie charts. Use zero to denote that there is no data for that item.
	Context Menu Options: Reset this column's data to zero: Reset all the data under the same column to zero. Reset this row's data to zero: Reset all the data on the same row to zero.

Import and export pie chart data

You can export the Region Properties as a data file or copy all properties into clipboard, and edit them using Excel, LibreOffice/OpenOffice Calc or even your text editor. After finishing your edits, you can import the data file or paste the modified data back into the Data Grid.

• Export pie chart data to edit in other software
• Import pie chart data into Data Grid
• Copy pie chart data to clipboard
• Paste pie chart data from clipboard into Data Grid

Export pie chart data to edit in other software

1. Click Export Data File to the bottom right corner of the Data Grid dialog. You will be prompted to save the Pie Chart data as a text file in Unicode Text Format.
2. Open the data file in your favorite software to change the data. We recommend using spreadsheet software like Microsoft Excel or LibreOffice/OpenOffice Calc for easy editing of the data. If you are using LibreOffice or OpenOffice, you may rename the extension of the file from .txt to .csv so that Calc can pick up the file directly.

Import pie chart data into Data Grid

1. Make sure that the header column is present, and have the same number of columns when it is compared with the original data file exported from Data Grid. Tab characters are not allowed within the data, and you must replace them with spaces.
2. Save the data file in our recommended format:
   • Microsoft Excel: Save as Unicode Text format (.txt). This can be found from the Save as Type drop down on the Save dialog.
   • LibreOffice/OpenOffice Calc: Save as Text CSV format (.csv). This can be found from the Filterdrop down on the Save dialog. Click Save to continue. In Export Text File dialog, please change the Field Options as follows:
     • Character Set: Unicode (UTF-8)
     • Field Delimiter: {tab}
     • Text Delimiter: Delete any characters and leave it blank.
3. Go back to iMapBuilder HTML5 software and open the Pie Chart Data Grid. Click Import Data File to the top of the dialog and browse for the data file. Click OK to import.

Copy pie chart data to clipboard

1. Click the Copy all to Clipboard button to the bottom right of the Data Grid dialog.
2. Open your favorite software and paste the data directly for editing. We recommend using spreadsheet software like Microsoft Excel or LibreOffice/OpenOffice Calc for easy editing of the data.

Paste pie chart data from clipboard into Data Grid

1. Select all relevant data from the software you have used to edit the data. Make sure that the header column is present, and have the same number of columns when it is compared with the original data copied and pasted. Tab characters are not allowed within the data, and you must replace them with spaces.
2. Go back to iMapBuilder HTML5 software and open the Pie Chart Data Grid. Click Paste from Clipboard to the top of the Data Grid dialog. You will be prompted if you have successfully pasted the data or not. If you cannot paste the data into the grid, please check if your data satisfy the conditions mentioned from step 1. Adjust the data and paste again.

[ Top of Page ]