To show or hide data values
1. Right click the chart and select Format > Chart . The "Format Chart" dialog box appears.
2. Click the Appearance tab.
3. To display or hide the figures for each result on the chart bars, lines, markers, or segments, select or unselect Show data values.
To define the text and number format for axis values 1. Right-click the chart and select Format > Chart.
The Format Chart dialog box appears.
2. Click the Appearance tab, and then click Values on the appropriate axis on the preview pane on the left.
The options available for the selected axis appear.
3. Use the options in the formatting toolbar on the Appearance tab to format the text, cell background, and cell borders of the chart title.
4. If you want to change the number format applied to numerical values or dates, click the arrow next to the Number drop-down list box, and then select the appropriate format.
To set the frequency of values on an axis 1. Right-click the chart and select Format > Chart.
The Format Chart dialog box appears.
2. Click the Appearance tab, and then click Values on the appropriate axis on the preview pane on the left.
The options available for the selected axis appear.
3. If you want Web Intelligence to display values along the axis at an automatic frequency, select Auto axis value frequency.
4. If you want to specify the frequency at which the values appear, deselect Auto axis value frequency, and then type the frequency you want
If you type “2 ? every two values appear on the axis; if you specify “3 ? every three values appear on the axis, and so on.
To define minimum and maximum values on the Y axis 1. Right-click the chart and select Format > Chart.
The Format Chart dialog box appears.
2. Click the Appearance tab, and then click Values on the appropriate axis on the preview pane on the left.
The options available for the selected axis appear.
3. To specify the minimum value, select Min. value, and then type minimum value you want, in the text box.
4. To specify the maximum value, select Max. value, and then type maximum value you want, in the text box.
Auto-Scale Y-axis
Web Intelligence enables you to auto scale Y-axis by calculating the nearest value for the maximum and minimum range of values set for each chart block in a given report. Auto scale Y- axis is applicable for all kinds of charts, except the pie-chart.
To enable auto scale Y-axis select Auto Scale in the chart Properties tab.
After enabling the autoscale Y-axis, the minimum and maximum range of values set for a document initially is not displayed.
To move, add or remove data on charts 1. Right-click the chart you want to modify.
2. Select Format > Chart .
The "Format Chart" dialog box appears.
3. Click the Pivot tab.
4. To add objects to the chart, select objects from the Available Objects list and drop them onto the Y-Axis, X-Axis, and Z-Axis panes as appropriate.
5. To move objects from one axis to another, select the object in the appropriate axis pane, and then drag the object to the pane for the axis where you want to move it.
Displaying data in charts
8
Formatting chartsaxis pane, and then drop the object onto the Available Objects list.
7. Click OK.
Web Intelligence displays the chart with the data allocated to the chart axes as you specified.
To swap data on 3D chart axes
• Right-click the chart and select Swap axes on the menu.
The data on the X-Axis is moved to the Z-Axis and the data on the Z-Axis is moved to the X-Axis.
Linear and logarithmic axes scales
By default, Web Intelligence displays the Y-axis on charts as a linear scale.
You can set the axis to a logarithmic scale. Logarithmic scales allow you to examine values that span many orders of magnitude without losing
information on the smaller scales.
In a linear scale, the axis markers are evenly spaced. Linear scales are based on addition. Consider, for example, the linear sequence: 1, 3, 5, 7, 9 To get the next number in the sequence, you add 2 to the previous number.
Logarithmic scales are based on multiplication rather than addition. In a logarithmic scale, the steps increase or decrease in size. Logarithmic scales are based on multiplication (or division). Consider, for example, the
logarithmic sequence: 2, 4, 8, 16, 32
To get the next number in the sequence, you multiply the previous number by 2. We can say that this sequence represents ``base 2.''
Consider the following sequence: 1, 10, 100, 1000, 10000
This sequence represents ``base 10,'' because you get the next term in the sequence by multiplying the previous term by 10.
To display the Y Axis logarithmically in Web Intelligence 1. Right click the chart and select Format > Chart .
The "Format Chart" dialog box appears.
2. Click the Appearance tab, and then click Values on the Y-Axis area of the preview pane on the left.
The options available for the Y-Axis appear.
3. To display the Y-Axis as a logarithmic scale, select Logarithmic scale.
Displaying data in charts