Create a bubble chart

Bubble charts display the relationship between three data fields. Each dot corresponds with a single data point, and the variables’ values for each point are indicated by horizontal position, vertical position, and dot size.

Use bubble charts to present financial data. You can use a Bubble chart instead of a Scatter chart if your data has three data series that each contain a set of values. The sizes of the bubbles are determined by the values in the third data series.

The following data must be selected:

  • Series: One non-numeric field to define the correlation.
  • X-Axis, Y-Axis and Size Data: Three numeric fields in the following order to define the data:
    1. The value on the x-axis (horizontally).
    2. The value on the y-axis (vertically).
    3. The size value for each bubble.

To create a bubble chart:

  1. Click Create on the Main Menu bar.
  2. Select Report from the menu. A list of available data sources displays.

    3. Note: Data sources in this step are provided for example only. Your data sources will depend on the modules licensed and the permissions granted. For more information, see Data sources/views.

  1. Select the data source that you want to use for your report or graph/chart from the list.
  2. Click Next. The Report Layout page displays.

  1. Click Add report name box and type the name of your graph/chart.
  2. Click the Select report type drop-down arrow.

  1. Select Bubble from the list of available report types.

  1. Click the Save in drop-down arrow and select one of the following:
    • An existing folder from the list where you want to save the report or graph/chart.
    • Add New Folder to create a new folder where your report or graph/chart will be saved. See Create a folder.

    Note: Type values in this box to filter and find the folder where your report or graph/chart will be saved.

  1. Do the following to add fields to the graph/chart:

    • Select the desired filter to apply to the list of available fields. The available options are:
      • All Fields
      • Dimensions
      • Measures
      • Date
    • Start typing in the Search item box to begin searching for available fields.
    • Click Expand All or Collapse All to view or hide all available options in order to easily narrow down on the desired field(s).
    • Optional: Click Custom Fields to create a custom field.

      • For more information on how to create and use Custom Fields, see Create and use custom fields.

      Note: If you create a custom field, you must use it in your report. Otherwise, you will not be able to save the report.

    • Drag and drop the fields to add to the graph/chart from the Fields list to the Layout section.

    Note: The elements in the Layout section change depending on the requirements of the report type you are creating.

  2. Click to add a filter. For more information, see Add a filter.

    3. Note: You must create at least one filter.

  3. Optional: Click to add a pivot. For more information, see Add a pivot.
  4. Click the Preview button to preview your graph/chart. Your graph/chart displays in View Mode.

    5. Note: You can preview your graph/chart at any time by clicking on the Preview button. No Data Available displays when there is no data retrieved/found.

    Note: The following message displays when a report or graph/chart takes a long time to render:

    Click email to send the report or graph/chart in an email or cancel to stop the loading process.

  5. Click Save to open the Save context menu
  6. Select one of the available options:
    • Save: Selecting this option will save the graph/chart without exiting the graph/chart edit page.
    • Save as copy: Selecting this option will save a copy of the graph/chart. You will need to rename the graph/chart in the Navigation Menu.
    • Save & Close: Selecting this option will save the graph/chart and close the graph/chart edit page. The graph/chart will then run.
    • Save & send by email: Selecting this option will save the graph/chart and close the graph/chart edit page. A modal window will then give you the options to send the graph/chart. For more information, see Email a graph/chart.
    • Save & Create new: Selecting this option will save the graph/chart and close the graph/chart edit page giving you the option to create a new graph/chart.

You can customize a new or existing bubble chart using the available setting options.

  1. Open the Main Menu bar and click .
  2. Click one of the following:
    • Settings - available only to the Administrator or the chart creator.
    • My Settings - available to users with access rights to review the chart .