Document Developer - instructions > Making the document dynamic > Adding dynamic data to object properties > Adding dynamic data to chart data

Adding dynamic data to chart data
For the data used in a chart you can:
To add dynamic data to chart categories
1
2
In the Properties panel Chart category, select Data and click the browse button. The Chart Data panel opens.
3
To add dynamic data to line properties
1
2
In the Properties panel Chart category, select Data and click the browse button. The Chart Data panel opens.
3
4
In the Properties panel Chart data item category, set modifications on Line thickness, Line dash style and/or Line color.
To enable a dynamic number of categories
1
2
In the Properties panel Chart category, select Data and click the browse button.
3
4
Select the Category cell.
5
Click Set modification.
6
7
Select the Value cell.
8
Click Set modification.
9
10
Select the Data label cell.
11
Click Set modification.
12
In the Data Selection dialog, select the field in the block with the value used for the data label value, (normally the same as the Value field), and click OK.
13
Select the Legend label cell.
14
Click Set modification.
15
In the Data Selection dialog, select the field in the block with the value used for the legend label value, normally an item name, and click OK.
16
Select the Color cell.
17
Click Set modification.
18
*
Instead of selecting a field and clicking Set modification, you can drag the field in a block to the corresponding cell in the Chart Data table.
Example 67
The Document Designer designs a pie chart and specifies that it will contain a dynamic number of categories.
The message contains a StreamIN Event with a block and the following fields:
The Document Developer opens the Chart Data panel for the chart and:
Drags the ItemName field from the Message panel to the Category cell in the Chart Data table.
Drags the ItemQuantity field from the Message panel to the Value cell in the Chart Data table.
Drags the ItemQuantity field from the Message panel to the Data label cell in the Chart Data table.
Drags the ItemName field from the Message panel to the Legend cell in the Chart Data table.
Drags the ItemColorfield from the Message panel to the Fill color cell in the Chart Data table.
The Event is a StreamIN configuration where the input format for the ItemQuantity field is k=, d=
This means that, for example, 1,000.00 is interpreted as 1000 and not 1.00.
The input file contains three item records:
ITEM;Nots;1,250.00;RGB(255,0,0)
ITEM;Bolts;2000;RGB(0,255,0)
ITEM;Screws;1000;RGB(0,0,255)
With this configuration, the block is repeated three times and there are three categories in the chart with the colors red, blue, and green.
Click to enlarge
Figure 58
 
OpenText StreamServe 5.6.2 Updated: 2018-01-26