Notes about creating bubble graphs

To create meaningful graphs in Discoverer, you need to have the correct worksheet configuration for the style of graph that you want to use.

When you create bubble graphs, follow these guidelines:

• You need at least three items per bubble:

  • the X item - the bubble's location on the X-axis

  • the Y item - the bubble's location on the Y-axis

  • the Z item - the size of the bubble (in positive numbers)

The figure below shows an example Discoverer worksheet and the worksheet data plotted on a bubble graph.

Figure 8-4 Example Discoverer worksheet and bubble graph

Description of the illustration gr_bub.gif

For example, you might have the following items on a bubble graph (see figure above):

• store size as the X item (the 'Store size m2' item on the worksheet)

• advertising costs as the Y item (the 'Advertising $' item on the worksheet)

• sales as the Z item (the 'Sales $' item on the worksheet)

You could then see whether the largest stores with the most advertising generated the highest sales revenue.

The figure above shows how worksheet data is represented on a bubble graph. The bubbles represent Sales. A large bubble represents large sales revenue. A small bubble represents small sales revenue.