On this tab, fields to be placed on Group axis (X-axis) and Value axis (Y-axis) are set. The fields received from query are listed in the Available Fields.
Figure 3: Data mapping field of chart dialog box
Placing a field on Value Axis
Click the field and click button near Value Fields title. Selected field will be listed under Value Fields. If other than the default, select function to be applied on field. Multiple fields can be placed on this axis.
To remove a field, click the field listed in Value Fields and click button.
Placing a field on Group Axis
Click the field and click button near the Group Fields title. Selected field will be listed under the Value Fields. Multiple fields can be placed on this axis. In that case, you can select the grouping by clicking Merge Values check box.
To remove a field, click the field listed in the Group Fields and click button.
Setting Data formats
On this tab, we set data format for fields placed on Group Axis.
Figure 4: Setting data format
X-Axis Field: Select the field for which data format is being setup.
Date Group By: For a date type field, select group option here.
Num Group By: If the field is of number type, specify a number indicating group. For example, to form group of 1-5, 6-10, specify 5.
Format (Date): For a date type field, specify format here.
Format (Num): For a number type field, specify format here.
Display Field: Select a field here if a different field should be displayed on axis.
Label Interval: Specified as a number, label will appear on every ‘n’th value. For example, if you specify 2 and axis has Date set by month, Labels for Jan, March, May, etc. will appear.
First (N): To include only few top values in the chart. For example, in a chart having sales summary field, specify 20 to include records having top 20 figures of sales summaries.
Chart – Settings Tab
Chart type, visual effects and legend related settings are done on Settings tab.
Settings tab has the following three sub-tabs:
Select Chart type from the list available. Click the respective chart type to select it.
Figure 5: Chart Settings – General Tab
- Text: Specify text that will appear as title of the chart.
- Font: Font properties for the title text.
- Fore Color: Select text color for the chart.
Specify space to be kept blank from Left, Right, Top and Bottom edges of chart component.
Figure 6: Chart > Settings > General tab
By specifying Top (N) details you can limit number of data points plotted on chart. For example, if you have 100 products, but want to plot product having highest 5 sales, specify Top (N).
Field: This dropdown lists all the fields selected for X axis and Y axis.
N = The number of data points to be plotted.
Sort Order: Select ‘Ascending’ to plot lowest of the ‘N’ values. Select ‘Descending’ to plot highest of the ‘N’ values.
Auto Format: Select (check) this check box to automatically apply these formatting aspects:
- Label Angle (Axis > Style)
- Chart Margins (Settings)
- Angle (Series > Point labels)
Theme: To apply pre-configured color combination (theme) on the chart.
Figure 7: Chart Settings – Look and feel effects
3D chart: Select this checkbox to have the chart having three-dimensional effect.
3D Depth: Set depth of the third dimension.
Figure 8: Chart Settings > Effects tab
3D Wall Gradient: Select this checkbox if you want gradient effect on wall.
Embedded in HTML: The way chart should be embedded when report is viewed as HTML. Select ‘Image (Jpeg)’ to embed image as a JPEG format image. Select ‘Flash’ to embed image as a flash animation.
Animation time: Applicable when Embedded in HTML is set as Flash. Specify time in second for which animation should continue.
Stacked Bar: Applicable for bar charts. Select ‘Side by side’ to place bars one besides other, Accumulated to place bars one above other, select ‘Percentage’ to have accumulated in percent form.
Grid Style: Select the grid style among options – Horizontal, Vertical, Both or Secondary Y-axis.
Select colors for Chart area (Chart Area Color), plot area (Plot Area Color) and alternate color for plot area (Alternate Plot Area).
Legend related settings are done on Legend tab of the Settings tab.
Figure 9: Setting – legends
Figure 10: Settings > Legends tab
Visible: Select to make legends to appear (visible) on chart.
Font: Select font properties for legend text.
Align: Select placement option for legend text from Left, Right, Top or Bottom.
Width and Height: Setup width (top and bottom alignment) and height (left and right alignment) of legend box.
Tip: You may need to change chart margins (Settings > General tab on Chart Properties dialog) to get actual effect of Width / Height of Legend box.
Select color options for Back color of legend box and Fore color of legend box.