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:

1. Select the chart in the Report Designer.
2. In Chart Properties, under Grid, select the grid that the chart will reference.

   The grid must exist in the current report.

3. In Legend Items from Grid, select Rows to reference row data or Cols to reference column data.
   Note: In Pie Charts, if Rows is selected, then the columns display in the legend, and if Cols is selected, then rows display in the legend.
4. In Data Range, under Rows and Cols, select the rows and columns to include in the chart.

   When selecting a data range, you can specify contiguous or non-contiguous rows and columns.

5. Optional. Select Include Auto Calculation to include auto calculations from the data set in the chart.