Customizing Charts

You can customize a chart using the Customization window. This window can only be opened by clicking the Customize icon on the chart button bar. You can display a chart from your Inbox or by clicking the Preview button on Report Designer window.

The customizations are applied to the report that is currently displayed. Once you have completed the customization you can save the settings as a descriptor file and load this descriptor file into other charts of the same type. To save the descriptor, click the Save icon on the chart button bar, as described in Saving a Chart Descriptor on page 111.

The Customization window tab names are the same for each chart type, however, the tab content changes depending on the type of chart displayed.

 

   Note:


    If you wish to customize the pivot table on a Combo chart, you must click the pivot table before clicking the Customize icon. Otherwise the tabs for the 2D or 3D chart are displayed.


Chart Options Tab - 2D Charts

The Chart Options tab is only available for 2D and 3D charts. The options are slightly different for 2D and 3D charts. For details of the 3D chart options, see Chart Options Tab - 3D Charts on page 282.

The Chart Options tab for 2D charts is shown below.

 

   Figure 177: Chart Options

This tab lets you set basic characteristics for the chart (not all characteristics are relevant for every chart format).

2D Chart Options

Table 52 lists all of the possible options for two dimensional charts.

 

   Note:


  Not all of the options listed in this table are displayed in Figure 177.


 

Table 52: 2D Chart Options

Option

Description

Bar width on bar chart

Sets the relative width of each bar. This feature is ignored if the chart is not a bar or box chart.

Number of divisions on scale

Sets the number of dividing horizontal lines to draw on the Y-axis. If this is set to asterisk (*), the chart will automatically adjust the number of divisions.

Base value on box chart

Sets the baseline of a box chart. Values above this baseline grow up from the baseline; values below it grow down. By default the baseline is 0.

Axis handles position

Specifies where the page dimensions are listed. By default, they are listed at the top of the chart; you can override this default, and specify the side or bottom of the chart.

Legend position

Sets the position of the legend. By default, the chart displays the names and colors of members of the measure dimension at the bottom of the chart; you can override this, and specify the top or sides of the chart.

Show percent values on pie chart

When selected, the pie charts indicate what percentage of the pie each slice represents.

Display chart in vertical direction

Rotates the chart axis. The measure dimension appears on the Y-axis and the numeric value on the Y-axis. This setting is ignored for pie charts.

Show legend on pie chart

When selected, the pie charts display a legend indicating what each section of the pie represents.

Grid on: axis 1, axis 2

When selected, the chart puts dividing tic marks on the selected axis.

Tics on label

Determines which members of the display dimension are listed on the chart. If the value is 1, every selected members name is displayed (see Figure 178). If you set a higher value, not all labels are displayed; intervening members are just indicated by a tic mark. For example, if you set this property to 2, every other label is displayed (see Figure 179).

Tics on scale

Determines which numeric labels appear in the charts scale. The default is 1, indicating that a number should be shown for every scale line (see Figure 180). If you set a higher value, numbers are given for fewer scale lines. For example, if you set a value of 3, numbers are displayed only for every third scale line.

Line up dual scale tics

Lines up the tic marks on both scales if you are using dual (or split) scales. If not checked, tic marks on the primary scale are lined up with grid lines, but tic marks for the second scale can appear somewhere between these lines. Additionally, if a box chart is displayed, the base value is included in both scales.

Scale minimum and maximum

Determines the highest and lowest numbers on the scale. The default setting for these properties is asterisk (*), indicating that the chart should pick an appropriate scale for the values being displayed.

X axis label

Specifies a label for the X-axis (optional).

Scale label

Specifies a label for the scale (optional).

Show data values on chart

When selected, the exact numerical values for each bar, point, and pie slice are displayed on the chart.

Line width

Specifies the width of each line, in pixels. This value is ignored if the chart is not a line chart.

Smooth line

When selected, the chart engine makes the line appear to be the same width, no matter what the line's slope. This may make the graph slightly less precise. If the option is not checked, the graph's data points are displayed precisely, but the line's width may appear to vary, depending on the line's slope. This feature is ignored if the chart is not a line chart.

Center labels around tics

Centers labels around the tic mark. If not checked, labels are left-aligned with the tic mark.

The figure below shows an example chart for one tic on the display dimension label.

 

   Figure 178: One Tic on Display Dimension Label

The figure below shows an example chart for every other tic.

 

   Figure 179: Displaying Every Other Tic

The figure below shows tics on a scale set to one.

 

   Figure 180: Tics on Scale Set to One

Chart Options Tab - 3D Charts

The Chart Options tab is only available for 2D and 3D charts. The options are slightly different for 2D and 3D charts. For details of the 2D chart options, see Chart Options Tab - 2D Charts on page 278. The Chart Option tab for a 3D chart is shown below.

 

   Figure 181: 3D Chart Options

The 3D Chart Options tab has a few properties that are different from the 2D chart properties panel. These are listed in Table 53.

Table 53: 3D Chart Options

Option

Description

Line width on line chart

Sets the width of each line, in pixels. This value is ignored if the chart is not a line chart.

Bar width on bar chart

Sets the relative width of each bar. This feature is ignored if the chart is not a bar or box chart.

Number of divisions on scale

Sets the number of dividing horizontal lines to draw on the Y-axis. If this is set to asterisk (*), the chart automatically adjusts the number of divisions.

Base value on box chart

Sets the baseline of a box chart. Values above this baseline grow up from the baseline; values below it grow down. By default the baseline is 0.

Axis handles position

Determines where the page dimensions are listed. By default, they are listed at the top of the chart; you can override this default, and specify the side or bottom of the chart.

Legend position

Sets the position of the legend. By default, the chart displays the names and colors of members of the measure dimension at the bottom of the chart; you can override this, and specify the top or sides of the chart.

Show percent values on pie chart

When selected, pie charts indicates what percentage of the pie each slice represents.

Display chart in vertical direction

Rotates the chart axis. The measure dimension appears on the Y-axis and the numeric value on the Y-axis. This setting is ignored for pie charts.

Wrap label text

Wraps long label text automatically.

Save data specific selections

Specifies that a chart descriptor should save information specific to the data of the current chart. For Example, in a chart that displays the total salary of three departments, you might elect to show data for only two of the three departments. This would be considered a data specific selection because if the data changes, the two selected departments may no longer be valid. In order to save this particular information, you should check the save data specific selections check box. Otherwise, only generic information will be saved.

Show null value as 0 value

Shows 0 for null values.

Grid on: axis 1, axis 2, axis 3

When selected, the chart puts dividing tic marks on the selected axis.

Tics on label

Determines which members of the display dimension are listed on the chart. If the value is 1, every selected member's name is displayed (see Figure 178). If you set a higher value, not all labels are displayed; intervening members are just indicated by a tic mark. For example, if you set this property to 2, every other label is displayed (see Figure 179).

Tics on scale

Determines which numeric labels appear in the chart's scale. The default is 1, indicating that a number should be shown for every scale line (see Figure 180). If you set a higher value, numbers are given for fewer scale lines. For example, if you set a value of 3, numbers are displayed only for every third scale line.

Chart width and height

Sets the relative height and width of the chart. If you set these properties to asterisk (*), Netcool Reporter sizes the chart to fit the window. You can also resize the chart by grabbing a corner and dragging it with the mouse.

Scale minimum and maximum

Determines the highest and lowest numbers on the scale. The default setting for these properties is asterisk (*), indicating that the chart should pick an appropriate scale for the values being displayed.

Numeric Format Tab

The Numerical Format tab is used to customize how the table displays numbers, which is useful if the data is stored in an unusual way. For example, a chart might store sales figures measured in cents; you might want to display the data as dollars, or even as thousands of dollars. You can also specify how to format the numbers and how to display negative and zero values.

The Numerical Format tab is shown below:

 

   Figure 182: Numerical Formatting: General

You can set the default numerical format for all numbers in the chart.

If you click the Clear All Member Formats button, all special measure-dimension formatting is cleared, and all numbers are displayed using the formatting you set with this window. This button does not change the default numeric format you set; it cancels all measure-dimension format overrides.

This window displays a raw number (such as you might find in the data source), and it also shows how that number would appear under the current format settings. This lets you experiment with formats within the window.

The selection list gives you the following options for formatting numbers:

 

   Note:


    The Main Format and Right Axis Format radio buttons are not displayed when customizing pivot tables. If the Main Format is selected you set the format for the left, or main, axis. If Right Axis Format is selected, you set the format for the right axis (used in split-scale displays) if there is one.


General

Numbers are displayed as a sequence of digits. No extra characters (such as commas or other punctuation) are added, and the number is not rounded or truncated in any way.

The Numerical Format tab with the General option selected, is shown in Figure 182 on page 284.

Number

The following figure shows the Numerical Format tab with the Number option selected.

 

   Figure 183: Numerical Formatting: Number

This format can be used for general numbers. You have several options for customizing the way the number is displayed:

Percentage

The following figure shows the Numerical Format tab with the Percentage option selected.

 

   Figure 184: Numerical Formatting: Percentage

This format lets you show numbers as percentages. You have two options for customizing the way percentage is displayed:

Custom

The following figure shows the Numerical Format tab with the Custom option selected.

 

   Figure 185: Table Numerical Formatting: Custom

This option lets you specify any numerical format you like, by defining one or more format masks. The format masks are similar to the ones used by Microsoft Excel.

You can select a mask by choosing one from the list. You can also create or modify one by typing in the text box. The box can contain between one and three masks, separated by semicolons. If you enter a single mask, it is used for all numbers. If you enter two masks, the second one is used for negative numbers and zero. If you enter three masks, the second one is used for negative numbers, and the third one is used for zero values.

Masks are made up of placeholder characters and other characters. All non placeholder characters are displayed as typed. Placeholder characters are replaced with the actual number.

If the number has more digits to the right of the decimal point than there are placeholders in the format, the number is rounded to as many decimal places as there are placeholders. If the number has more digits to the left of the decimal point than there are placeholders in the format, the extra digits are displayed. If the format contains only number signs (#) to the left of the decimal point, numbers less than 1 begin with a decimal point. To display a leading 0 for a number less than 1, use the 0 placeholder to the left of the decimal point.

Table 54: Numerical Formatting Placeholders and Special Characters

Character

Description

#

Displays significant digits. Does not display insignificant zeros (that is, leading zeros to the left of the decimal point, or trailing zeros after).

0

Always displays digits. Displays as a zero if appropriate. (For example, if the database contains the number 123, and the mask is 0000.0, the number is displayed as 0123.0).

?

Displays as a digit, if the digit is significant; otherwise, displays as a space. This is useful for making sure numbers are aligned.

^

Displays the entire number, in general format.

%

If present, causes the number to appear as a percentage. For example, if the data source contains the number 0.12, and the mask is ^%, the number is displayed as 12%.

To display a number in scientific notation, use a format mask that contains E-, E+, e-, or e+. Scientific notation numbers are formatted as follows:

Colors Tab

The Customization window displays the Chart Colors tab for 2D and 3D charts and the Report Colors tab for pivot tables. These tabs are identical in operation, however, the objects that can be colored are different.

The Report Colors tab is shown below.

 

   Figure 186: Customizing Table Colors

The available options can be seen in the following table.

Table 55: Report Colors Tab Options

Option

Pivot Table

2D Chart

3D Chart

Frame

 

x

x

Dim Name

 

x

x

Box

 

x

x

Background

 

x

x

Text

x

x

x

Line

x

x

x

Show Value

 

x

 

X-Axis Legend

 

x

 

Scale Legend

 

x

 

Report Header

x

 

 

Column Names

x

 

 

Row Titles

x

 

 

Report Cells

x

 

 

Cell Hilite

x

 

 

Axis Handle

x

 

 

Marker

x

 

 

Threshold

x

 

 

Background

x

 

 

Change the colors of each part by clicking the Color button for that component. The Pick a Frame Color window is displayed, as shown below.

 

   Figure 187: Pick a Frame Color Window

You can also set the bevel width of the row and column titles. A bevel width of 2 gives the titles a three-dimensional look, making them seem to stand out from the page. A bevel width of 1 makes the effect milder, and a bevel width of 0 eliminates this effect.

Fonts Tab

The Customization window displays the Chart Fonts tab for 2D and 3D charts and the Report Fonts tab for Pivot tables. These tabs are identical in operation, however, the text objects that can be changed are different.

The Report Fonts tab is shown below.

 

   Figure 188: Customizing Table Fonts

You can control which font is used for each text element in the table. For each element, you can set the font and size and toggle whether the text should be italicized.

 

   Note:


    Since the table is a Java applet, you can only select from among the typefaces provided by Java. You cannot use any special fonts that may be installed on your machine.


The fonts for the pivot table are described in the following table.

Table 56: Table Font Options

Option

Description

Cell

Sets the numeric values displayed in the table's cells.

Column title

Sets the names of members of the column dimension (or the innermost column dimension, if there is more than one).

Column subtitle

If there is more than one column dimension, sets the typeface used for all but the innermost dimensions.

Row title

Sets the names of members of the row dimension (or the innermost row dimension, if there is more than one).

Row subtitle

If there is more than one row dimension, sets the typeface used for all but the innermost dimension.

Cell

Sets the numeric values displayed in the table's cells.

Column title

Sets the names of members of the column dimension (or the innermost column dimension, if there is more than one).

The fonts for the chart are described in the following table.

Table 57: Chart Font Options

Option

Description

Scale

Sets the numbers listed along the Y-axis.

Label

Sets the names of dimension members (except members of the measure dimension, which are listed in the legend).

Legend

Sets the names of members of the measure dimension, listed in the color-coded legend.

Title

Sets the names of the dimensions, displayed in the dimension buttons.

Header, Footer

Sets the text displayed at the top and bottom of the chart. Note that the presentation page may contain title text displayed above or below the chart object; this text is not part of the chart, and cannot be changed with the chart properties panel.

Title Tab

The Customization window displays the Chart Title tab for 2D and 3D charts and the Report Title tab for pivot tables. These tabs are identical in operation.

Both tabs allows you to place a title in the body of the chart

The Report Title tab is shown below.

 

   Figure 189: Report Title Tab

Enter a chart title in the Title field.

To insert a field, place the cursor in the title where you want to insert the field, then click the Insert Field button. Choose the appropriate field from the following list:

If you choose Current Date or Current Time, a formatting menu is displayed so you can set the format (for example, mm/dd/yyyy) for these fields.

The Clear Title button clears the field.

The Enable Context Header checkbox, when selected, displays the page dimension values that you have selected as the last line of the title.

For example, if you have a page dimension called State at the top of the chart, and Rhode Island is selected in the State list, selecting this checkbox causes State=Rhode Island to be displayed as the last line of the title.

Advanced Tab

The Advanced tab is only available on the Customization window for pivot tables. The tab is shown below.

 

   Figure 190: Advanced Table Properties

This tab is used for miscellaneous table options that are not appropriate for any of the other tabs. The following sections describe the options.

Disable Load

If you select the Disable Load checkbox, the table only loads data from the datasource when you click the Data Refresh button.

If you open new cells while load is disabled, the cells are empty until you click the Refresh button. This feature is useful if you need to drill through several layers to get to the data you are interested in. You can navigate to the right area of the table without having to wait for data every time you drill down or swap dimensions. When you reach the area, you can refresh the data manually or enable automatic refresh again.

Cell Alignment

Use this option to specify whether the numbers should be centered in their cells, or right-aligned in their cells.

Column Width

If you wish, you can specify the width of each column in pixels.

Show Grid

This option is disabled for SQL charts.

Show Axis Handles

This option is disabled for SQL charts.

Chart Scale Tab

The Chart Scale tab is only displayed in the Customization window for 2D Charts. The tab is shown below.

 

 

   Figure 191: Chart Scale Tab

This tab allows you to adjust the scales for the display dimensions on your 2D chart. By default the Auto checkboxes are all selected.

If you wish to adjust any of the scale values manually, deselect that value's Auto checkbox, then enter a value into the corresponding text field.

Fields in the Primary Scale area apply to the chart's primary scale. If your chart uses dual, or split scales, the values in the Secondary Scale area affect the secondary scale.

The following table describes the fields in the Primary Scale section of the tab.

Table 58: Primary Scale Fields

Field

Description

Maximum Value

Sets the maximum value for your chart's primary scale. Deselect the Auto checkbox and enter a maximum value. Note: The value you enter must be larger than the maximum value of any of the display dimensions. If you enter a smaller value, your value is ignored.

Minimum Value

Sets the minimum value for your chart's primary scale. Deselect the Auto checkbox and enter a minimum value. Note: The value you enter must be smaller than the minimum value of any of the display dimensions. If you enter a larger value, the minimum value of the display dimensions is used instead.

Unit Increment

Sets the increments for your chart's primary scale. Deselect the Auto checkbox and enter the increment value. For example, if you want the scale to contain values such as 0, 100, 200, 300, enter 100 as the unit increment.

Auto-calculate and align Secondary Scale to the primary

When selected, if your chart uses dual, or split scales, the chart engine automatically generates the values for the secondary scale and aligns that scale to the primary scale. If you want to set the secondary scale values manually, deselect this checkbox. The fields in the Secondary Scale area are enabled.

The following table describes the fields in the Secondary Scale section of the tab.

Table 59: Secondary Scale Fields

Field

Description

Maximum Value

Sets the maximum value for your chart's secondary scale. Deselect the Auto checkbox and enter a maximum value. Note: The value you enter must be larger than the maximum value of any of the display dimensions. If you enter a smaller value, your value is ignored.

 

Minimum Value

Sets the minimum value for your chart's secondary scale. Deselect the Auto checkbox and enter a minimum value. Note: The value you enter must be smaller than the minimum value of any of the display dimensions. If you enter a larger value, the minimum value of the display dimensions is used instead.

Unit Increment

Sets the increments for your chart's secondary scale. Deselect the Auto checkbox and enter the increment value. For example, if you would like the scale to contain values such as 0, 100, 200, 300, enter 100 as the unit increment.

Customizing Combo Charts

The Configure Combo Chart window is used to customize a combo chart.

After previewing a chart, click the Chart Type button on the toolbar and select Combo from the pop-up menu. This opens the Configure Combo Chart window, as shown below.

 

 

 

    Configure Combo Chart Window

Select the measure you want to change. The following table describes the properties in this window.

 Combo Properties

Property

Selected Values

Description

Chart Type

Area, Bar, Box, Line, XY

Specifies the chart type for the measure.

 

Color

None

Selects the desired color for displaying the

measure.

Axis

Primary, Secondary

Selects which axis you want to use to display

the selected measure.

Customizing Line Chart Lines

The Format Chart Measure window is used to customize a line chart. This is the only customization tool that does not appear as part of the Customization window.

On a line chart, right-click the measure legend for the line you wish to customize and select Set Formatting from the pop-up menu. The Format Chart Measure window General tab is displayed, as shown below.

 

   Figure 192: Format Chart Measure Window - General Tab

General Tab

To change the color, click the Choose button and select a new color from the Pick a Chart Color window.

If you are not using split scales, leave the Primary Axis radio button selected. If you are not using split scales and you select the Secondary Axis radio button, dual scales are created for you.

Marker Tab

The Marker tab is shown below.

 

   Figure 193: Format Chart Measure Window - Marker Tab

If you select the None radio button, the markers are not placed at each data point.

If you select the Character radio button, a text character is used as a marker for each data point. Type the character into the text box.

If you select the Shape radio button, a shape is used as a marker for each data point. Choose a shape from the drop-down list.

If you choose the Shape option, you can also choose the colors for the edge and inside of the shape. Select the Edge Color or Fill Color checkboxes as required. Click the Choose buttons to choose the colors. If you do not choose a color, black is used.