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.
