Creating a diagram cell
A diagram cell displays 2 other divided cells. Make sure you have already added 2 cells with the ID and a label with the numeral value (or hour).
For example: a cell with ID A has label 2 and a cell with ID B has label 5. The diagram cell based on these cells shows the pie chart 2/5.
The diagram cell can also be used to represent hours.
For example: an activity that lasts less than an hour (for example 20 minutes) is displayed in a diagram divided into 4 quarter hours. An activity that lasts more than an hour (for example 8 hours) is displayed in a diagram divided into 12 hours.
- Edit the cell (F5).
- Click Advanced in the Edit dialog.
- Choose Chart from the Type: drop-down list.
- Complete the following fields:
- Cell ID of dividend, the ID of the cell of which the value in the label becomes the counter.
- Cell ID of divisor, the ID of the cell of which the value in the label becomes the denominator.
- Click OK.