### To Chart dialog

This dialog appears when you right-click a crosstab and then select To Chart on the shortcut menu or click Menu > Edit > To Chart. It allows you to specify settings for converting a crosstab into a chart excluding the organization chart and varies with different chart types: common chart types, heat map.

OK

Applies the settings and closes the dialog.

Cancel

Cancels the settings and closes the dialog.

Displays the help document about this feature.

Ignores the setting and closes this dialog.

#### For common chart types

See the dialog.

Title

Specifies a title for the chart.

Specifies the font properties of the chart title.

- Font
  Lists all the available font faces that can be selected to apply to the title.
- Font Style
  Specifies the font style of the title. It can be one of the following: plain, bold, italic, and bold italic.
- Size
  Specifies the font size of the title.
- Align
  Specifies the position of the title to be left, right, center or justify.
- Font Color
  Specifies the font color of the title.
- Background Color
  Specifies the background color of the title.

Resources

Displays all the view elements used in the crosstab.

Sorts the view elements in the specified order from the drop-down list. Once a user changes the order, it will be applied to all the resource trees where business view elements are listed for this user.

- Predefined Order
  Sorts the view elements in the order defined in the Business View Editor on JReport Designer.
- Resource Types
  Sorts the view elements by resource type, namely category objects come first, then group objects, then aggregation objects, and at last detail objects.
- Alphabetical Order
  Sorts the view elements in alphabetical order. Elements that are not in any category will be sorted first, then the categories, and the elements in each category will also be sorted alphabetically.

Launches the quick search toolbar to search for view elements.

- Text box
  The quick search toolbar treats view elements as strings and searches by consecutive text. Type in the text you want to search for in the text box and the matched text will be highlighted among the view elements.
- X
  Closes the quick search toolbar.
- Lists more search options.
  - Highlight All
    Specifies whether to highlight all matched text.
  - Match Case
    Specifies whether to search for text that meets the case of the typed text.
  - Match Whole Word
    Specifies whether to search for text that looks the same as the typed text.
- Highlights the previous matched text.
- Highlights the next matched text.

Adds the selected group or aggregation object to be displayed in the chart.

Category

Lists the group object that will be displayed on the category axis of the chart.

Series

Lists the group object that will be displayed on the series axis of the chart.

Show Values

Specifies the types for chart and sets the values for the Primary Axis or Secondary Axis separately.

- Primary Axis
  Adds a chart type to the primary axis.
- Secondary Axis
  Adds a chart type to the secondary axis.
- X Axis
  Lists the value you want to show on the X axis of the bubble chart.
- Y Axis
  Lists the value you want to show on the Y axis of the bubble chart.
- Radius
  Lists the value you want to show as the bubble radius.

Secondary Axis

Specifies whether to show the secondary axis in the chart.

Opens the Category Options dialog or Series Options dialog to define the sort order of the category or series values and specify the number of the category or series values that will be displayed in the chart.

Adds a combo chart to the Primary Axis or Secondary Axis.

Moves the selected view element one level up.

Moves the selected view element one level down.

Adds a new pair of Y Axis and Radius for the bubble chart.

Removes the selected view element.

#### For heat map

See the dialog.

Title

Specifies the title of the chart. The title is a special label bound with the chart. Though it can be positioned freely in a report, once you remove the chart from the report, the title will be removed too.

Specifies the font properties of the chart title.

Resources

Displays the resources that can be added to the chart.

Sorts the view elements in the specified order from the drop-down list. Once a user changes the order, it will be applied to all the resource trees where business view elements are listed for this user.

Launches the quick search toolbar to search for view elements.

Adds the selected field into the Groups or Summaries box.

Removes the selected field from the Groups or Summaries box.

Show Values

Displays Heat Map as the selected chart type.

Groups

Lists the fields used to group the data. There should be at least one group.

- Color by
  Specifies whether to color by a group. 0-n groups can be used as the color-by fields.
- Label by
  Specifies whether to show a group field in the innermost rectangle. 0-n groups can be used as the label-by fields.
- Moves the selected group field one level up.
- Moves the selected group field one level down.
- Opens the Group Options dialog to define the sort order of the group values and specify the number of the group values that will be displayed in the chart.
- Removes the selected group field.

Summaries

Lists the summaries used as size-by/color-by or displayed in the innermost rectangle.

The summaries should match the groups. For example, if the groups level is A > B > C, the static summaries grouped by C can be inserted into the Summaries box, but the static summaries grouped by A, B or other fields cannot.

If no group is specified in the Groups box, you can insert any static summary. And its group-by field will be inserted into the Groups box automatically.

- Size by
  Specifies to size by one summary or none.
- Color by
  Specifies to color by one summary or none.
- Label by
  Specifies whether to show a summary in the innermost rectangle. 0-n summaries can be used as the label-by fields.