Document toolboxDocument toolbox

Chart

Structure

{mainTitle}

{subTitle}

 

importance secondary

importance primary

Chart Legend

importance primary

 

 

 

importance primary

 

 

 

Usage

  • Add a new “Chart Legend” column in a table style to allow for horizontal bar charts to be inserted

Expand word template table style with column “Chart Legend
Modify header cell (i.e., cell with “Chart Legend” in word template) to apply style & alignment to chart legend in report
  • Chart Legend” text should be on the level of the column groups. The chart legend is then produced by merging the column group and column cells together.

    • If any chart column does not have a name set or is set to empty string (““), the chart legend will not be generated

  • Bar coloring follows the defined theme. Once all colors are used, they start cycling.

  • The column width can be set by setting tableChart.chartColumnWidth in the metadata (see below on how to set metadata) or the DimensionGroup.width property

  • The last column width need to be set in percent

Table Style Metadata

Table Style Metadata Parameter

Explanation

Default

Visualization

Table Style Metadata Parameter

Explanation

Default

Visualization

tableChart.axisBorderColor

Defines the color of the border line between negative and positive bar chart.

This value is set in Hex.

#000000

(Black)

 

tableChart.axisBorderWidth

Defines the width of the border line between negative and positive bar chart.

This value is set in pt.

0.5 pt

 

tableChart.barHeightInPt

Defines the desired bar height in the chart. This value is only effective if no resizing (proportional shrinking) of the chart is required.

This value is set in pt.

8.50394pt

(0.3 cm)

 

tableChart.minimumAxisWidthInMM

Defines the minimal width of the negative and positive bar chart side.

This value is set in mm.

4 mm

tableChart.minimumBarHeightInPt

Defines the minimum bar height in the chart. This value is guaranteed and will force the cell height to grow if necessary.

This value is set in pt.

4.25197 pt

(0.15 cm)

 

tableChart.minimumChartPaddingInPt

(new)

Defines the minimal vertical padding for the bar chart.

Notes:

  • Padding is achieved by adding additional row on top and bottom of the chart

  • Effect of parameter only visible if:

#bars*minimumBarHeightInPt + 2*minimumChartPaddingInPt > highest_cell_in_row

  • Bar Chart placement follows alignment settings of word channel (should ideally be set to centered). Important for cases where the effect is not visible.

  • If minimumChartPaddingInPt is set to 0 or the row’s height is set to Exactly, this parameter will have no effect

This value is set in pt.

Depends

 

chartColumnWidth

Defines string aliases to be used for the otherwise numeric chartWidth BB parameter.

This value of chartColumnWidth is an object from string to number, where the number is in % (from 2-100).

ex.:

chartColumnWidth: { "narrow": 20, "standard": 48, "wide": 60 }

Note: Many table-chart BBs support the parameter chartWidth, albeit only via JSON code-view.

 

 

 

Behavior

The axis is positioned based on the data in the abstract report. There are four positions with a distance of 25% of the column width of eachother. If there are no negative values, the axis is placed at position 0 (i.e. to the left). If there are only negative values smaller than 25% of the total, the axis is positioned at position 1 (which is at 25% of the column width) and so forth. Please see the the examples section for concrete applications of this principle.

 

Examples

Example 1: Showing a simple case with a one bar chart

Example 2: Showing how the values determine the axis position

Example 3: Showing how bar colors are repeated

Example 4: Showing how to change the left and right margin

Example 5: Showing how to set the column width using a chartColumnWidths mapping in the metadata (JSON comment)

Example 6: Showing how to set the column width in the abstract report

Example 7: Various minimumChartPaddingInPt set with table bar charts with 3 and 4 charts