Worksheet Display page: (Graph tools)

Previous

Next

---

You can use the following graph tools in a worksheet:

• "Graph"

• "Tools"

• "Layout"

• "Sort"

• "Graph"

• "Saved Selections"

• "Data"

Graph

Use the arrow icon to display or hide worksheet graph data.

Tools

Use the arrow icon to display or hide worksheet graph tools.

Layout

Use this tool to rearrange the layout of the worksheet graph data.

Note: This option is only displayed with worksheets created using OLAP connections.

Use the drop down lists to:

• move a worksheet item to a specified position on the worksheet

  Use the Move option from the first drop down list, select the item that you want to move from the second drop down list, and select the location to move the item to using the third drop down list.

• swap worksheet items, rows, columns or page items with one another

  Use the Swap option from the first drop down list, select a worksheet item, row, column, or page item from the second drop down list, and select an option to swap with from the third drop down list.

Sort

Use this tool to sort the graph data based on selected criteria in a worksheet. The changes made here do not affect settings made by the Table/Crosstab sort tool.

Note: This option is only displayed with worksheets created using OLAP connections.

• Sort

  Use this drop down list to select the values that you want to use to sort the worksheet data.

• Based on

  Use this drop down list to select a item or measure on which to base the sort order for the values that you selected in the Sort drop down list.

• For

  Use this drop down list to specify the dimension members to use when sorting based on measure values.

  Note: This option is only displayed with worksheets created using OLAP connections.

• Order

  Use this drop down list to select a sort order for the values that you selected in the Sort drop down list.

• Go

  Use this button to apply the sort settings in the current worksheet.

• More

  Use this link to display the "Multiple Sort page", where you can specify how Discoverer Viewer sorts the data displayed in multiple worksheet columns.

  Note: This link is not displayed with worksheets created using OLAP connections.

Graph

Use this tool to select the graph type and specify how the graph is displayed as follows:

• Type

  Use the first drop down list to select the graph type (e.g. Pie).

  Use the second drop down list to select the graph subtype (e.g. Multiple Pie).

• Width

  Use this field to change the display width of the graph. If you change the width, Discoverer will scale the graph height maintaining the height-to-width aspect ratio.

• 3D Effect

  Use this check box to give the graph the appearance of depth.

• Gradient

  Use this check box to display the chart using a graded shading effect.

Saved Selections

Use this tool to apply a previously saved selection to a dimension that is displayed in the worksheet graph.

Note: This tool is only displayed with worksheets created using OLAP connections.

• Dimension

  Use this drop down list to select the dimension to which you want to apply a saved selection.

• Action

  Use this drop down list to specify whether to add, keep, remove, or replace the members from the specified saved selection, as described in the following list.

  • Add

    Adds the members from the specified saved selection to the current selection.

  • Keep

    Keeps the members from the specified saved selection that were already present in the current selection and discards all other members.

  • Remove

    Removes from the current selection any members that are specified in the saved selection.

  • Replace with (Default value)

    Replaces the current selection with new members from the specified saved selection.

• Saved Selection

  Use this drop down list to select the saved selection that you want to use.

• Go

  Use this button to apply the saved selection to the dimension in the worksheet.

Data

Use this tool to include in the graph either all the data in the worksheet, or just the rows and columns that are currently being displayed.

Note: This option is only displayed with worksheets created using OLAP connections.

• All data

  Use this radio button to include in the graph all the worksheet data.

• Displayed data

  Use this radio button to include in the graph only worksheet data from the rows and columns that are currently being displayed in the worksheet. For example, if Discoverer Viewer is currently displaying rows 50 to 75 and columns 10 to 15, only the data in these currently displayed rows and columns will be included in the graph.

• Go

  Use this button to apply the settings to the graph in the current worksheet.