Charts are a flexible, interactive way to explore your data graphically. You can choose different levels of aggregation for rows and columns, change a field from a column to a row, pivot the entire chart, hide chart values, and zoom in to see chart details.
The following sections explain how to populate, edit, and format a chart. Many tasks related to work with charts are identical (or very similar) to those for tables and crosstabs.
Using Fields and Measures in Charts
You must add at least one measure to view a chart. Before any measures are added to the chart, the Reports Editor displays a placeholder with the legend displaying a single entry: Add a measure to continue. As you add measures, the editor displays the grand total of each measure in the chart.
The initial display only reflects the measures you add; it does not change when you add fields or dimensions. For example, for each measure you add to a bar chart, you see a bar with the total value of the measure, regardless of how many fields you add. This means you can add, remove, and arrange measures and fields without waiting for the display to update. Once you have added the fields and measures needed, use the sliders on the right to select the level of detail desired.
All fields are listed in the Data Selection panel, as either standard fields or measures.
Standard fields can be added to a column or a row.
Measures contain summarized values. They are typically numeric fields that determine the length of bars, size of pie slices, location of points (in line charts), and height of areas. They can be added to rows or columns, but must all be in the same target – that is, you can add one or more measures to the chart as columns, or add one or more measures to the chart as rows, but you cannot have one measure as a column and another as a row in the same chart.
When creating a chart, keep in mind that row and column groups are arranged in hierarchies, with the highest member of the hierarchy on the left.
Adding a Field or Measure to a Row or Column
In the Data Selection panel, select the field you want to add to the chart as a group. Use CTRL-click to select multiple items.
Drag the selected item into the Columns or Rows box in the Layout Band.
Hiding Group Members
Use the legends below the chart to hide or show group members.
To hide a group member, click on the member name in the legend below the chart. The member is removed from the chart and the legend is grayed out.
To show a group member that has been hidden, click on the grayed-out legend for the member.