View Source

Overview

Rendered Chart

Table Filter, Charts & Spreadsheets for Confluence - Knowledge base > Column, Stacked Column, Bar, Stacked Bar chart types > column.png

Table Filter, Charts & Spreadsheets for Confluence - Knowledge base > Column, Stacked Column, Bar, Stacked Bar chart types > stacked column.png

Table Filter, Charts & Spreadsheets for Confluence - Knowledge base > Column, Stacked Column, Bar, Stacked Bar chart types > bar.png

Table Filter, Charts & Spreadsheets for Confluence - Knowledge base > Column, Stacked Column, Bar, Stacked Bar chart types > stacked bar.png

Parameters in Macro Browser

Type	Column / Stacked column / Bar / Stacked bar
Labels column	Period
Values column	Opened Tickets Pending Tickets Successfully Closed Tickets Tickets Closed w/o Response Unsuccessfully Closed Tickets

Data Table in Macro Placeholder

Period	Opened Tickets	Pending Tickets	Successfully Closed Tickets	Tickets Closed w/o Response	Unsuccessfully Closed Tickets	Total Tickets
Q1 2018	207	42	381	20	14	664
Q2 2018	278	31	247	58	39	653
Q3 2018	227	27	200	23	31	508
Q4 2018	257	20	237	58	40	612

Settings Tab

Select the chart type

To select the chart type in the page view mode:

Insert the Chart from Table macro.
Hover over the chart controls on the right of the table.
Locate the Type option and select the chart type. The chart will be automatically re-generated.
To save the modifications in the macro body, click the cogwheel icon and select Save changes .

To select the chart type in the macro browser:

Switch the page to the edit mode.
Insert the Chart from Table macro and paste the table within the macro body.
Select the macro and click Edit.
Locate the Type option in the Settings tab and select the chart type.
Save the macro and the page.

Table Filter, Charts & Spreadsheets for Confluence - Knowledge base > Column, Stacked Column, Bar, Stacked Bar chart types > type view.png

Select data series

Labels column - the column containing labels for data values.

Values column - the column or columns containing numerical values for chart generation.

To select data series in the page view mode:

Insert the Chart from Table macro.
Hover over the chart controls on the right of the table.
Locate the Labels column and Values column options and select the table columns containing data for chart generation. The chart will be automatically re-generated.
To save the modifications in the macro body, click the cogwheel icon and select Save changes .

To select data series in the macro browser:

Switch the page to the edit mode.
Insert the Chart from Table macro and paste the table within the macro body.
Select the macro and click Edit.
Locate the Labels column and Values column options in the Settings tab and select the table columns containing data for chart generation.
Save the macro and the page.

Table Filter, Charts & Spreadsheets for Confluence - Knowledge base > Column, Stacked Column, Bar, Stacked Bar chart types > lables column view.png

Adjustments Tab

Set the table data orientation

Switch the page to the edit mode.
Select the macro and click Edit.
Switch to the Adjustments tab.
Locate the Table data orientation option.
Select the Vertical or Horizontal option.
Save the macro and the page.

Table Filter, Charts & Spreadsheets for Confluence - Knowledge base > Column, Stacked Column, Bar, Stacked Bar chart types > table data orientation.png

Set the decimal separator

Switch the page to the edit mode.
Select the macro and click Edit.
Switch to the Adjustments tab.
Locate the Decimal separator option.
Specify the correct decimal separator for numeric values in the source table (point or comma).
Save the macro and the page.

Table Filter, Charts & Spreadsheets for Confluence - Knowledge base > Column, Stacked Column, Bar, Stacked Bar chart types > decimal separator column.png

Set the worklog settings

Please ensure that the worklog parameters set in the macro are identical to parameters configured in Atlassian JIRA.

Switch the page to the edit mode.
Select the macro and click Edit .
Switch to the Adjustments tab.
Click the Set worklog settings button.
In the opened form, define the worklog parameters, as follows:
1. Days in week - enter the number of business days in a week.
2. Hours in day - enter the number of working hours in one business day.
3. Time format - select the used time format in worklog values.
4. Week shortening - enter the shortening for the week time unit if you use any language different from English.
5. Day shortening - enter the shortening for the day time unit if you use any language different from English.
6. Hour shortening - enter the shortening for the hour time unit if you use any language different from English.
7. Minute shortening - enter the shortening for the minute time unit if you use any language different from English.
Save the macro and the page.

Worklog time units in different languages are denoted with different shortenings. Please adjust them according to your JIRA localization settings.

Table Filter, Charts & Spreadsheets for Confluence - Knowledge base > Column, Stacked Column, Bar, Stacked Bar chart types > worklog column.png

Set the minimal and maximal values

Minimal value - the minimal value for showing only data values greater than the specified minimal value.

Maximal value - You can specify the maximal value for showing only data values not greater than the specified maximal value.

Switch the page to the edit mode.
Select the macro and click Edit.
Switch to the Adjustments tab.
Locate the Minimal and Maximal value options and set the values.
Save the macro and the page.

Table Filter, Charts & Spreadsheets for Confluence - Knowledge base > Column, Stacked Column, Bar, Stacked Bar chart types > min and max.png

Set the scale step

Scale Step - the required scale step for showing the numeric values in the chart.

Switch the page to the edit mode.
Select the macro and click Edit.
Switch to the Adjustments tab.
Locate the appropriate option depending on the chart type and set the scale step.
Save the macro and the page.

Table Filter, Charts & Spreadsheets for Confluence - Knowledge base > Column, Stacked Column, Bar, Stacked Bar chart types > scale step.png

Set the logarithmic scale

Logarithmic Scale - the option for very small or very large numeric values that cannot be properly aligned on the standard arithmetic scale.

Switch the page to the edit mode.
Select the macro and click Edit.
Switch to the Adjustments tab.
Locate the Logarithmic Scale option and enable the option.
Save the macro and the page.

Table Filter, Charts & Spreadsheets for Confluence - Knowledge base > Column, Stacked Column, Bar, Stacked Bar chart types > bar logarythmic scale.png

Show trendline

Switch the page to the edit mode.
Select the macro and click Edit.
Switch to the Adjustments tab.
Locate and enable the Show trendline option.
Save the macro and the page.

Table Filter, Charts & Spreadsheets for Confluence - Knowledge base > Column, Stacked Column, Bar, Stacked Bar chart types > trendline column.png

Look Tab

Set the height and width of the chart

Switch the page to the edit mode.
Select the macro and click Edit.
Switch to the Look tab.
Locate the Height and Width fields.
Enter the appropriate dimensions of the chart.
Save the macro and the page.

To set the Height and Width of the chart in the page view mode:

Hover over the chart controls on the right of the table.
Locate the Height and Width fields.
Enter the appropriate dimensions of the chart.
To save the modifications in the macro body, click the cogwheel icon and select Save changes .

Table Filter, Charts & Spreadsheets for Confluence - Knowledge base > Column, Stacked Column, Bar, Stacked Bar chart types > dimensions edit.png

Table Filter, Charts & Spreadsheets for Confluence - Knowledge base > Column, Stacked Column, Bar, Stacked Bar chart types > dimensions view.png

Set colors

Switch the page to the edit mode.
Select the macro and click Edit.
Switch to the Look tab.
Locate the Select colors button and click it.
Select the appropriate colors for each label.
To set individual column colors, locate the Color scheme option.
Select the Multicolor or Colors in the table columns option.
Save the macro and the page.

To set the colors in the page view mode:

Hover over the chart controls on the right of the table.
Click the cogwheel icon, locate the Select colors option. Select the Multicolor or Colors in the table columns option. Pick the colors or columns with colors and click Apply. The chart will be automatically re-generated.
To save the modifications in the macro body, click the cogwheel icon and select Save changes .

The Multicolor setting enables you to select the appropriate colors for each value of the Label column specified in the data series field of the chart.

The Colors in the table columns setting enables you to add colors as either its simple name (e.g. green, yellow) or a HEX code (e.g. #808080-> gray) in a separate custom-made column to paint values of the Labels column(-s) specified in the data series field of the chart.

Table Filter, Charts & Spreadsheets for Confluence - Knowledge base > Column, Stacked Column, Bar, Stacked Bar chart types > image-2024-6-3_17-8-40.png

Table Filter, Charts & Spreadsheets for Confluence - Knowledge base > Column, Stacked Column, Bar, Stacked Bar chart types > Multicolor3.png

Table Filter, Charts & Spreadsheets for Confluence - Knowledge base > Column, Stacked Column, Bar, Stacked Bar chart types > Multicolor2.png

Table Filter, Charts & Spreadsheets for Confluence - Knowledge base > Column, Stacked Column, Bar, Stacked Bar chart types > Multicolor4.png

Table Filter, Charts & Spreadsheets for Confluence - Knowledge base > Column, Stacked Column, Bar, Stacked Bar chart types > Multicolor1.png

Table Filter, Charts & Spreadsheets for Confluence - Knowledge base > Column, Stacked Column, Bar, Stacked Bar chart types > Column chart settings edit.png

Table Filter, Charts & Spreadsheets for Confluence - Knowledge base > Column, Stacked Column, Bar, Stacked Bar chart types > Column chart custom color.png

Align chart

Switch the page to the edit mode.
Select the macro and click Edit.
Switch to the Look tab.
Locate the Align chart option.
Select the appropriate chart alignment, as follows:
- Left
- Center
- Right
Save the macro and the page.

Table Filter, Charts & Spreadsheets for Confluence - Knowledge base > Column, Stacked Column, Bar, Stacked Bar chart types > aligning column.png

Set the legend position

Switch the page to the edit mode.
Select the macro and click Edit.
Switch to the Look tab.
Locate the Legend Position option.
Select the appropriate legend position, as follows:
- None
- Right
- Bottom
Save the macro and the page.

Table Filter, Charts & Spreadsheets for Confluence - Knowledge base > Column, Stacked Column, Bar, Stacked Bar chart types > legend position column.png

Show/Hide source data

Switch the page to the edit mode.
Select the macro and click Edit.
Locate the Source data option and select the appropriate option, as follows:
- Show all content
- Hide tables
- Hide all content
Save the macro and the page.

To show/hide source data in the page view mode:

Hover over the chart controls on the right of the table.
Click the cogwheel icon, select the Show source content, Hide source content (Hide tables, Hide all content) option.
To save the modifications in the macro body, click the cogwheel icon and select Save changes .

Table Filter, Charts & Spreadsheets for Confluence - Knowledge base > Column, Stacked Column, Bar, Stacked Bar chart types > 2021-03-29_18h50_42 copy.png

Hide chart controls

Switch the page to the edit mode.
Select the macro and click Edit.
Switch to the Look tab.
Locate and enable the Hide chart controls option.
Save the macro and the page.

Table Filter, Charts & Spreadsheets for Confluence - Knowledge base > Column, Stacked Column, Bar, Stacked Bar chart types > hide controls edit column.png

Set the chart title

Switch the page to the edit mode.
Select the macro and click Edit.
Switch to the Look tab.
Locate the Chart title option and enter the title.
Save the macro and the page.

Table Filter, Charts & Spreadsheets for Confluence - Knowledge base > Column, Stacked Column, Bar, Stacked Bar chart types > title column.png

Set axis labels

Switch the page to the edit mode.
Select the macro and click Edit.
Switch to the Look tab.
Locate the Row axis label and Value axis label options and enter the labels.
Save the macro and the page.

Table Filter, Charts & Spreadsheets for Confluence - Knowledge base > Column, Stacked Column, Bar, Stacked Bar chart types > labels column.png

Show data labels

Switch the page to the edit mode.
Select the macro and click Edit.
Switch to the Look tab.
Locate the Show data labels option and select the appropriate option, as follows:
- None
- Value
- Percentage
- Value (Percentage)
- Percentage (Value)
Save the macro and the page.

Table Filter, Charts & Spreadsheets for Confluence - Knowledge base > Column, Stacked Column, Bar, Stacked Bar chart types > show data labels.png

Filter the source table

Select one or more chart columns/sectors/bars.
Only the related rows of the source table are displayed.
Deselect all the columns/sectors/bars to display the whole source table.

Table Filter, Charts & Spreadsheets for Confluence - Knowledge base > Column, Stacked Column, Bar, Stacked Bar chart types > filter table.png