DriveWorks Pro 16: Generate Pie Chart [send feedback...]

Generate Pie Chart

This Specification Macro Task will generate an image of a Pie chart. The appearance and data of chart can be configured using the properties in the Task.

The plotting behavior is intended to be the same as plotting a chart in Microsoft Excel.

Properties

Property NameDescription
TitleChanges the Title (not the name) of the Task.
DestinationThe Full File Path and Name of the image file to create, including its extension.
OverwriteTRUE to overwrite the destination file, otherwise FALSE.
Image Width (px)The pixel width of the image to output.
Image Height (px)The pixel height of the image to output.
TableA DriveWorks Table of data which will be plotted.

The first column of the Table will be used as the X plot. This column can be filled with text strings.

Every cell on the top row of each column of the Table will be used for series name. These cells be filled with text strings.

Every column thereafter the first will be used as the Y data plot. These cells can only contain numerical values.

Chart Title TextThe text that will be placed above the Chart. Can be left blank if no Title required.
Chart Title FontThe font string for the Chart Title. e.g. font-family: verdana; font-size 14.25pt.
Display LegendTRUE to display the Chart Legend. FALSE will not.
Chart Area BackColorThe color of the Chart Area background. The area in and around the Chart itself. Text, RGB and hex color values are accepted. Defaults to white if blank.
Image BackColorThe color of the Image background. The area not included in the Chart or Legend. Text, RGB or Hexadecimal values accepted. Defaults to white if blank.
Chart Color ThemeThe color theme of the Chart itself. Choose from one of the values in the list. See the chart below for examples.
Legend FontThe font used for the Legend.
Display Slice LabelsTRUE to display a Label on each slice. FALSE will not display a Label.
Slice Label FontThe font used for the Slice label/s. Only used if Display Slice Labels enabled. e.g. font-family: verdana: font-size: 14.25pt.

Example

When this Task is added the properties are static. To be able to build rules on a static properties see How To: Change A Static Property To A Dynamic Property.

Property NameExample RuleExample ResultMeaning
DestinationFsGetFullPath("<Specification>\CreatedChart.png")C:\MyDocuments\Projects\Specifications\Spec 9999\CreateChart.pngThis is the location where the new file will be created.
OverwriteTRUETRUETRUE will overwrite the file if it exists FALSE will not.
Image Width (px)600600This will be the new width in pixels of the image that will be created.
Image Height (px)400400This will be the new height in pixels of the image that will be created.
TableDwLookupGlobalTempatureDwLookupGlobalTempatureThis is the DriveWorks Table to look in for the data to use. This should be set out like the example below.
Chart Title Text"U.S. GDP By Industry" & NewLine() & "Source: Bureau of Economic Analysis"

U.S. GDP By Industry

Source: Bureau of Economic Analysis

This is the Charts name. The NewLine function simply adds the 'Source: NASA' part of the Title onto a new line.
Chart Title Font"font-family: calibri; font-size: 14pt; text-decoration:"font-family: calibri; font-size: 14pt; text-decoration:This is the font used for the Charts Title.
Display LegendFALSEFALSEFALSE will not display the Legend. TRUE would. The Legend will appear on the right side of the new image.
Chart Area BackColor"white"whiteThis is the color of the Chart Area background. The Value can be Text, RGB or Hexadecimal. Blank will default to white.
Image BackColor"white"whiteThis is the color of the Image background. The Value can be Text, RGB or Hexadecimal. Blank will default to white.
Chart Color Theme"EarthTones"EarthTonesEarthTones is one of the options themes that you can pick. Examples of other theme options can be seen below.
Legend Font"font-family: calibri; font-size: 11pt; text-decoration:"font-family: calibri; font-size: 11pt; text-decoration:This is the font to use for the Legend.
Display Slice LabelsFALSEFALSEFALSE will not show the Slice Labels. TRUE would.
Slice Label Font"font-family: calibri; font-size: 12pt; text-decoration:"font-family: calibri; font-size: 12pt; text-decoration:This is the font to use for Slice Labels.

Example Table Data

The table below is an example of the data in a Simple Table referenced by the Table property above.

Simple Table Name: USEconomy

IndustryGDP value added $ billions 2011
Real estate, renting, leasing1898
State and Local Government1336
Finance and insurance1159
Health/ social care1136
Other8018

Example Chart Color Theme Property

The table below shows examples of values for the Chart Color Theme property above.

Chart Color ThemeArea ChartColumn ChartLine ChartPie Chart
Berry
Bright
BrightPastel
Chocolate
EarthTones
Excel
Fire
Grayscale
Light
None
Pastel
SeaGreen
SemiTransparent

Table of Contents