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.

   
   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.

   
   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

     
     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.

   
   Description of the illustration grphxaxs.gif
   
   

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

   
   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.

   
   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.

   
   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.

Description of the illustration grph.gif

Notes

• To automatically arrange graph components, right-click on the graph border and choose Auto Layout.