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.
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.
|
This tab lets you set basic characteristics for the chart (not all characteristics are relevant for every chart format).
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.
|
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. |
|
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. |
|
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. |
|
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. |
|
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.
|
The figure below shows an example chart for every other tic.
|
The figure below shows tics on a scale set to one.
|
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.
|
The 3D Chart Options tab has a few properties that are different from the 2D chart properties panel. These are listed in Table 53.
|
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. |
|
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. |
|
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. | |
|
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. |
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:
|
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:
General
Number
Percentage
Custom
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.
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.
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:
Negative style - These radio buttons specify whether negative numbers are displayed with a leading hyphen, for example, -123, or in parentheses, for example, (123).
Use 1000 Separator - If this checkbox is selected, thousands are separated by commas, for example, 1,234,567.
Use currency symbol - If this is set, the number is displayed with a leading currency symbol. By default, the symbol is the dollar sign ($), but you can enter any character or characters you wish.
Decimal places - This determines what level of precision the number displays. If you set decimal places to 0, the number is rounded to the nearest integer (for example, 1234.56 is displayed as 1235). If you set the decimal places to a positive value, that many places are displayed after the decimal place (for example, if you choose one decimal place, 1234.56 is displayed as 1234.6).
Display number as - This field lets you scale the number. By default, the number is displayed as it is stored in the data source. If you choose 000, the number is divided by 1,000 before display (that is, you display the number of thousands). Similarly, you can display the number divided by 1,000,000 or 1,000,000,000.
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:
Multiply by 100 - If this is set, the number is multiplied by 100 before being converted to a percentage. For example, if the data source contains the number 0.5, it is displayed as 50%. When this option is disabled, 0.5 would be displayed as 0.5%.
Decimal places - This determines the level of precision is applied when displaying the number. If you set decimal places to 0, the number is rounded to the nearest integer (for example, 1.2345 appears as 123%). If you set the decimal places to a positive value, that many places are displayed after the decimal place (for example, if you choose one decimal place, 1.2345 is displayed as 123.5%).
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:
The number contains a lower case e or capital E depending on whether a lower case e or capital E was used in the mask.
The number of numeric placeholders to the right of the e-, determine the precision of the exponent.
If you use E- or e-, a negative sign is placed by negative exponents, but no sign is placed by positive exponents. If you use E+ or e+, a negative sign is placed by negative exponents and a positive sign by positive exponents.
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.
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. |
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:
Current Date
Current Time
Bookmark Name
Currency
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.
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.
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.
Use this option to specify whether the numbers should be centered in their cells, or right-aligned in their cells.
If you wish, you can specify the width of each column in pixels.
This option is disabled for SQL charts.
This option is disabled for SQL charts.
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. |
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. |
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 |
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.
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.