Configuring Series Settings for Studio Reports Charts

Series tab of Chart Properties dialog box has behavior and formatting settings for Series.  This tab is divided in 5 sub-tabs:

• General

• Border

• Marker

• Point Labels

• A chart type specific tab (Gauge, OHLC, CandleStick or Split-pie)

For all of these sub-tabs, select either <<All Series>> or respective series before making settings.  Some of the entry boxes may not be applicable on the selected chart type and so it will be disabled.  To move a series up or down, click the respective series and click Up arrow or Down arrow available on the right of series selection box.

As you shift the highlight on chart types tabs specifically required for the highlighted (selected) chart type appears.

When you select <<All Series>>, the chart type selected on Settings tab’s General sub-tab gets selected.

General Tab

Figure 11: General tab of Settings

Figure 12: Series > General tab

Legend Text: Specify text for legend of this series.

Hyperlink: Specify hyperlink properties to make this series a clickable hyperlink.  When you click this series, it will open a URL or report as specified.

Tooltip: Specify tool tip that will appear when you hover the mouse on series.  Tool tip can be static or dynamic.  To have a dynamic tooltip, specify field within <% and %>.

Axis: Select the axis on which this series should be placed.

Fill Pattern: Select pattern for selected series.

Multiple Colors: Select (check) this check box to have multiple colors for series.  Select the color you want for selected series.

Gradient Fill: Select (check) this check box to have gradient effect on chart series.

Transparency: Select transparency settings by dragging the slide button towards the left or right side.  0 is opaque, 100 is completely transparent.

Null Values (line charts): Select how a null value should be handled on chart.

Convert to Zero: To consider Null as zero.  Line of the chart will pass through the point plotting zero value.

Ignore: For not considering the value to be plotted on chart. Line from previous point will not be plotted further touching point.  Another line will be plotted from next point.

Trend: For not considering the value to be plotted n chart.  But line from previous point will be plotted to connect next point, depicting the trend.  Line will not break like that in Ignore.

Border tab

Figure 13: Border tab under Series

Figure 14: Series > Border tab

Visible: Select (check) this checkbox if border should be visible.

Line Style: Select line style from drop down options.

Line Weight: Specifies thickness of line in pixels.  Select color of border by clicking the Color button.

Marker tab

This is applicable for following chart types:

• Area

• Line charts

• Curve

• Curve Area

• Scatter

Figure 15: Marker tab on Series

Figure 16: Series > Marker tab

Shape: Select shape of the marker from the drop down.

Size: Select size of markers.

Step: Specify difference in value (steps) to be kept between two markers.  For example, if you provide 2 here, market will be placed at every 2^nd data point.

Point Labels tab

These are the markers that appear on chart and near the series and display value.

Figure 17: Point labels on Series tab

Figure 18: Series > Point Labels

Visible: Check this to make point labels visible.

Font: Select font properties for text of point labels.

Angle: Specify angle of point label.

Horizontal Offset: Specify horizontal distance (in pixel) from series from where point label’s text will start.

Vertical Offset: Specify vertical distance (in pixel) from series from where point label’s text will start.

Data Format: Select the format for the data from the available options.

Gauge tab

Figure 19: Gauge tab on Series

Figure 20: Series > Gauge tab

Dial

• Start Angle: Specify angle at which dial should start. This is specified in degrees and from left to right.

• End Angle: Specify angle at which dial should end. This is specified in degrees and from left to right.

• Label: Select Outside to place labels outside the dial area. Select Inside to have labels inside the dial.

• Scale: Inside to display scale inside the dial area. Select Outside to display it outside the dial.

Needle, Marker

Select Needle to have a needle starting from center like automobile dials.  Select a marker to have a marker indicating the point.

• Length: Specify length of needle in terms of percent of radius.

• Base: Specify base width in terms of percent of radius.

• Begin Style: Select any one from Line and Pointer.

• End Style: Select end style for needle.

Zones

Your dial may have multiple zones.  This increases readability of the chart.

Single zone

To have single zone, select Single checkbox, select Gradient Start color and End color.

Multiple Zones

For each zone, specify Start Value, End Value and Color.  To get color picker, click the button in Color column.

New row appears automatically.  To delete a row, select it and click X button on top-left of the table.

OHLC tab

This tab will appear when you select OHLC as chart type.

Figure 21: OHLC tab on Series

• Positive Color: Select the color that should plot positive difference.

• Negative Color: Select the color to plot negative difference.

• Line Width: Specify line width

Candle Stick

This tab will appear when you select Candle Stick as chart type.

Figure 22: Candle Stick tab on Series

• Positive Color: Select the color that should plot positive difference.

• Negative Color: Select the color to plot negative difference

Pie tab

Figure 23: Pie tab on Series and its effect on pie chart

Split Pie: Check the checkbox to get split-pie appearance.

Pie Labels

• Label: Check (select) this checkbox to get Labels on Pie chart.

• Value: Check (select) this checkbox to get actual values on Pie chart.

• Percentage: Check (select) this check box to get value as percent of total (of values) on Pie chart.

• Format: Appears automatically as per checkboxes selected above.