Defining Chart Data
When defining chart data, you identify the rows and columns from the controlling grid that contain the data to display.
You can reference data or formula rows and columns by selecting contiguous or non-contiguous rows and columns for the data range. You can also include or exclude auto calculations from the data set.
If you are designing a line, bar, or combo chart, you can reference multiple rows or columns from the grid. If you are designing a pie chart, you can reference any single row or column from the grid. When you define a combo chart, you specify the data rows and columns for the bar and line.
Charts display aggregate rows or aggregate columns that expand. For example, if you specify row 1 and row 1 contains a function that retrieves ten child members, the chart displays ten data sets, or one data set for each child member.
To define chart data: