Skip Headers
Oracle® Business Intelligence Discoverer Plus User's Guide
10g Release 2 (10.1.2.1)
B13915-04
  Go To Documentation Library
Home
Go To Product List
Solution Area
Go To Table Of Contents
Contents
Go To Index
Index

Previous
Previous
Next
Next
 

8 Creating graphs in Discoverer

This chapter explains how to create graphs in Discoverer Plus Relational to answer typical business questions, and contains the following topics:

What is a Discoverer graph?

A Discoverer graph is an interactive pictorial representation of worksheet data. If is often easier to analyze trends in your data using a graph. The example below shows a three-dimensional bar graph of profit figures for regions.

Figure 8-1 A three-dimensional bar graph in Discoverer

This graphic shows a Discoverer graph.
Description of "Figure 8-1 A three-dimensional bar graph in Discoverer"

Note: In the example above, the underlined axis labels (i.e. Centre, East, West) are links that enable you to drill down into the graph. For example, clicking on the West underlined axis label drills down to data for cities in the West region (e.g. Seattle, San Francisco).

About using graphs in Discoverer

Discoverer provides a wide range of graphs to help you analyze data visually (e.g. area, bar, line, and scatter graph). For a complete list of graph types available in Discoverer, see "About graph types available in Discoverer".

Discoverer creates a graph for each worksheet automatically, which you can display, hide, and edit.

Each Discoverer worksheet can have one graph. You create a graph for the items currently displayed on a worksheet. Before you create a graph, make sure that you display the numeric worksheet values that you want to plot on the graph.

You can drill up and down in a Discoverer graph in the same way as you can drill in a worksheet (for more information, see "How to drill up and down").

Discoverer provides the Edit Graph dialog to help you create and edit graphs (see figure below).

Figure 8-2 Discoverer Edit Graph dialog

This graphic shows the Graph Type page in the Graph Wizard
Description of "Figure 8-2 Discoverer Edit Graph dialog"

The Edit Graph dialog helps you:

If you change the data displayed in a worksheet, the graph automatically updates to show the new data.

Once you have created a graph, you can edit the graph using the Edit Graph dialog, or edit areas of the graph using the Graph toolbar and right-click menus (for more information, see "How to edit a graph").

You can hide and display a worksheet graph (for more information, see "How to hide and display a graph").

When you save a workbook, Discoverer saves graphs automatically for you as part of the worksheets in the workbook. In other words, you do not have to explicitly save graphs.

Notes:

About components of a Discoverer graph

Discoverer gives you great flexibility when producing graphs, enabling you to configure every component of a graph. The figure below shows the typical components of a Discoverer graph.

Figure 8-3 Components of a Discoverer graph

Different components of a Discoverer graph.
Description of "Figure 8-3 Components of a Discoverer graph"


Key to figure:
a. The graph title.
b. The Y-axis title.
c. The plot area, showing worksheet data represented on the graph.
d. Tick label.
e. The X-axis title.
f. The X-axis labels. Notice that the axis labels are underlined (i.e. linked), to enable you to drill into the graph.
g. Vertical grid line.
h. Horizontal grid line.
i. The graph legend (or key). Notice that the axis labels are underlined (i.e. linked), to enable you to drill into the graph.
j. A reference line, used to emphasize particular data values on a graph.

Discoverer enables you to change the font of each graph component.

About graph types and sub-types

To present your worksheet data visually in Discoverer, you can choose from a wide range of graph types. For example:

Each graph type has one or more variations, or sub-types. For example, the sub-types for the Bar graph type include the following:

Some graphs also have dual-Y sub-types, which have two Y-axes. Dual-Y graphs are useful for showing the following types of data:

About graph types available in Discoverer

The table below shows the graph types that are available in Discoverer.

Graph icon Graph category and description
This graphic is described in surrounding text.
Area - graphs to show trends or changes in data using filled-in areas. This graph is useful when showing accumulations or cumulative data.
This graphic is described in surrounding text.
Bar - graphs to compare values using vertical bars. Each value is represented by a single bar. Bar graphs shows variation over a period of time or illustrates comparisons between values. The stacked sub-type shows each value's relationship to a whole. Bar graphs can have two Y axes (for more information, see "Notes about creating dual-Y graphs").
This graphic is described in surrounding text.
Circular - graphs to show directional data and cyclical patterns in data.
This graphic is described in surrounding text.
Combination - graphs that combines bars, lines, and areas. This graph type emphasizes one or more series of data. You must have at least two series to use this graph type. Shows the relationship of one series to another. Most often used as a Dual-Y graph, where different series correspond to different Y axes.
This graphic is described in surrounding text.
Horizontal Bar - graphs to compare values using horizontal bars. This graph type is identical to a bar graph except that the bars lie horizontally, rather than standing vertically. The stacked sub-type shows each value's relationship to a whole. Bar graphs can have two Y axes (for more information, see "Notes about creating dual-Y graphs").
This graphic is described in surrounding text.
Line - graphs to show trends or changes in data at even intervals. Data is represented as a line that connects a series of data points.
This graphic is described in surrounding text.
Pareto - graph to show trends across groups periodically and cumulatively. Each group is displayed as a column. A plotted line also shows the cumulative value across groups.
This graphic is described in surrounding text.
Pie - graphs to show data as sections of a circle, similar to slices of a circular pie. A pie graph shows the proportion of parts to the whole. It is useful for emphasizing a significant element, such as the highest value. Note that a pie graph displays only one row or one column of data at a time (for more information, see "Notes about creating pie graphs").
This graphic is described in surrounding text.
Scatter/Bubble

Scatter - graphs to show data as points scattered over the plot area. Each point is a value whose coordinates are specified by two numeric measures. A scatter graph is useful for showing relationships between two measures, for example Sales and Cost. All points are the same size, regardless of their value.

Bubble - graphs to show data in a similar way to a scatter graph, but with an extra dimension that uses the size of the bubbles. Each bubble is a value whose coordinates are specified by three numeric measures. A bubble graph is useful for comparing data that has three measures (for more information, see "Notes about creating bubble graphs").

This graphic is described in surrounding text.
Stock graph - graphs to show the highest stock price, lowest stock price, and closing stock price as bands on a time axis. Stock graphs are useful for comparing the prices of different stocks or the stock price of an individual stock over time (for more information, see "Notes about creating high-low-close stock graphs").
This graphic is described in surrounding text.
ThreeD - graphs to show three-dimensional (ThreeD) data in a true three-dimensional graph, where you have an X axis, a Y axis, and a Z axis. 3D graphs have a floor, a wall, and a background.

Note: This graph type is not the same as a two dimensional graph with the 3D Effect turned on. The 3D Effect simply adds depth to any graph type.


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:

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

Example worksheet configuration required to create a Bubble Graph.
Description of "Figure 8-4 Example Discoverer worksheet and bubble graph"

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

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.

Notes about creating high-low-close stock graphs

An open-high-low-close stock graph is a graph that is specifically designed for showing the opening, high, low, and closing prices of a stock. Each stock marker displays four separate values.

Figure 8-5 Example high-low-close stock graph

Example worksheet configuration required to create a Stock Graph.
Description of "Figure 8-5 Example high-low-close stock graph"

When you create high-low-close stock graphs (sometimes known as stock charts), follow these guidelines:

The data structure for open-high-low-close stock graphs is as follows:

Each group in an open-high-low-close stock graph has four values:

You need the following worksheet layout for a open-high-low-close stock graph:

Notes about creating dual-Y graphs

When you create dual-Y graphs, follow these guidelines:

The figure below shows an example dual-Y bar graph with a Y axis for sales and a second Y axis for costs.

Figure 8-6 Example worksheet and dual Y graph

Example worksheet configuration required to create a Dual-Y Graph.
Description of "Figure 8-6 Example worksheet and dual Y graph"

In the figure above, the Y1 axis represents sales on the scale 0 to 1 million. The Y2 axis represents costs on the scale 0 to 50,000. You can therefore analyze sales and costs side by side even though they use different scales.

Notes about creating pie graphs

When you create a Pie graph (sometimes called a Pie chart), you specify whether to use columns or rows as the graph series (i.e. Series by Column or Series by Row). The figures below shows the difference between using columns or rows as the graph series.

Figure 8-7 Plotting a pie graph using Series by Column

Example worksheet configuration required to create a Pie Graph (by row).
Description of "Figure 8-7 Plotting a pie graph using Series by Column"

Figure 8-8 Plotting a pie graph using Series by Row

Example worksheet configuration required to create a Pie Graph (by column).
Description of "Figure 8-8 Plotting a pie graph using Series by Row"

How to edit a graph

You edit a graph to change the graph settings for the graph that Discoverer creates for you automatically for every worksheet. Discoverer graphs enable you to display data and trends visually. You can display, hide, and edit worksheet graphs.

Discoverer provides the Edit Graph dialog to enable you to change the graph settings for a graph. If at any time you want to use default settings for the remaining tabs in the Edit Graph dialog, simply click OK.

Hint: Before you start, make sure that the worksheet displays the data that you want to plot on the graph (for more information, see "About using graphs in Discoverer").

To edit a graph:

  1. Choose Edit | Graph to display the "Edit Graph dialog: Type tab", and choose a graph type from the list of graph types and graph sub-types.

    This graphic shows the Graph Type dialog.
    Description of the illustration gw.gif

    For more information about choosing a graph type, see "About graph types available in Discoverer".

    Note: If the worksheet already contains a graph that is hidden (i.e. the Graph check box is cleared in the View menu), Discoverer displays the Edit Graph dialog, which enables you to edit the graph.

  2. Display the "Edit Graph dialog: Style tab", which enables you to select a graph style.

    This graphic shows the Graph Type dialog.
    Description of the illustration grphst.gif

    A graph style is a predefined set of colors and text styles that Discoverer applies to the graph. For example, Default, Autumn, Financial, Black and White.

  3. Display the "Edit Graph dialog: Titles, Totals, and Series tab", where you:

    • (optional) define a graph title

    • use the What would you like to display? options to select what data you want to display (i.e. data only, totals only, or both data and totals)

    • use the Graph series by options to select whether to plot data by row or column

    • (optional) when creating a pie graph, select which row or column you want to plot on the graph

      Title, Totals, and Series dialog.
      Description of the illustration graph_2.gif

      If you are creating a pie graph, the Pie Chart Options button is active.

  4. (optional) If you are creating a Pie Chart, select the column or row that you want to plot on the graph, as follows:

    1. Click Pie Chart Options to display the "Edit Graph dialog: Pie Chart Options tab (column)" or "Edit Graph dialog: Pie Chart Options tab (row)".

    2. Select the row or column that you want to graph from the list of items.

    3. Click OK.

    Note: When you click Next, you go straight to the "Edit Graph dialog: Legend tab". You do not define X or Y axes for pie graphs.

  5. Display the "Edit Graph dialog: X-Axis tab", where you specify how the X axis is displayed.

    This graphic shows the X-Axis dialog.
    Description of the illustration grphxaxs.gif

  6. Display the "Edit Graph dialog: Y-Axis tab", where you specify how the Y axis is displayed.

    This graphic shows the Y-Axis dialog.
    Description of the illustration grphyaxs.gif

  7. (optional) If you are creating a dual-Y graph, display the "Edit Graph dialog: Y2-Axis page (on dual-Y type graphs)", where you specify how the Y-2 axis is displayed.

    For more information about creating dual-Y graphs, see "Notes about creating dual-Y graphs".

  8. Display the "Edit Graph dialog: Plot Area tab", where you specify the color and style of plotted data.

    This graphic shows the Plot Area dialog.
    Description of the illustration grphplot.gif

  9. Display the "Edit Graph dialog: Legend tab", where you specify the graph legend that provides information about how items are represented on the graph.

    This graphic shows the Legend dialog.
    Description of the illustration grphlgnd.gif

  10. Click the Finish button to save the details and display the graph.

    Discoverer displays the graph on the worksheet. By default, graphs are displayed at the right-hand side of worksheet data. To change where a graph is displayed, choose View | Graph Placement and choose a position from the list of options.

Discoverer worksheet with a graph displayed.
Description of the illustration grph.gif

Notes

How to hide and display a graph

You hide a graph when you no longer need it. You display a graph when you want to display worksheet data visually or edit a graph.

Note: Hiding a graph does not remove the graph from the worksheet. You can always display the graph later if required.

To hide or display a graph:

  1. Display the worksheet that contains the graph.

  2. Choose View to display the View menu, and do one of the following:

    • Select the Graph check box to display the graph for the current worksheet

      If this option is grayed out, to create a new graph choose Edit | Graph to display the Edit Graph dialog.

    • Clear the Graph check box to hide the graph for the current worksheet

    Discoverer updates the worksheet with the changes that you specify.

How to change the position of a graph

You change the position of a graph when you want to change where it is displayed in relation to the worksheet data. For example, you might want to display a graph below worksheet data, or display a graph in a separate window.

To position a graph:

  1. Choose View | Placement and choose one of the placement options.

    For example, choose the Graph below Table/Crosstab option to position the graph beneath the data, or choose Separate Window to display the graph in a separate window.

    Discoverer displays the graph in the position that you specified.

Notes