OverviewLink to Overview

Rendered Chart

Parameters in Macro Browser

TypeTime line / Time area / Stacked time area
Values ColumnTickets per Hour, Calls per Hour
Dates columnDate

Data Table in Macro Placeholder

Date
Tickets per Hour
Average Time per Ticket (min)
Calls per Hour
25.06.20257.33.23.3
26.06.20258.53.11.8
27.06.20255.03.74.5
28.06.20252.25.82.7
29.06.20252.03.42.7

Settings TabLink to Settings Tab

Select the chart typeLink to Select the chart type

To select the chart type in the page view mode:

  1. Insert the Chart from Table macro.
  2. Hover over the chart controls on the right of the table.
  3. Locate the Type option and select the chart type. The chart will be automatically regenerated.
  4. 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:

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

Select data seriesLink to Select data series

Dates column - the column with dates for chart generation (horizontal axis).

Values column - the column or columns containing numerical values for chart generation (vertical axis).

To select data series in the page view mode:

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

To select data series in the macro browser:

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

Adjustments TabLink to Adjustments Tab

Set the decimal separatorLink to Set the decimal separator

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

Set the table data orientationLink to Set the table data orientation

  1. Switch the page to the edit mode.
  2. Select the macro and click Edit.
  3. Switch to the Adjustments tab.
  4. Locate the Table data orientation option.
  5. Select the Vertical or Horizontal option.
  6. Save the macro and the page.

Set the minimal and maximal valuesLink to Set the minimal and maximal values

Minimal X (Y) value - the minimal value for X (Y) axis for showing only data values greater than the specified minimal value.

Maximal X (Y) value - the maximal value for X (Y) axis for showing only data values not greater than the specified maximal value.

  1. Switch the page to the edit mode.
  2. Select the macro and click Edit.
  3. Switch to the Adjustments tab.
  4. Locate the Minimal X (Y) and Maximal X (Y) value options and set the minimal and maximal values.
  5. Save the macro and the page.

Set the scale stepLink to Set the scale step

Scale X (Y) Step - the required scale step of X axis or Y axis for showing the chart.

You can specify the appropriate number of days (Xd), months (Xm) or years (Xy) where the 'X' is the digit, as follows:

  • 10d  = 10 days as a scale step
  • 1m  = 1 month as a scale step
  • 2y  = 2 years as a scale step

Scale Y Step - the required scale step of Y axis for showing the chart.

  1. Switch the page to the edit mode.
  2. Select the macro and click Edit.
  3. Switch to the Adjustments tab.
  4. Locate the Scale X (Y) Step options and set the scale step.
  5. Save the macro and the page.

Set the interpolationLink to Set the interpolation

  1. Switch the page to the edit mode.
  2. Select the macro and click Edit.
  3. Switch to the Adjustments tab.
  4. Locate and select the Interpolation method for each line in your chart:
    • Linear
    • Step
    • Natural cubic
    • Monotone X cubic
    • Monotone Y cubic
    • Cubic Catmull-Rom
    • Cubic cardinal
    • Cubic basis
    • Straightened cubic basis
  5. Save the macro and the page.

To set the interpolation in the page view mode:

  1. Hover over the chart controls on the right of the table.

  2. Click the cogwheel icon, select the Set interpolation option and choose the method. The chart will be automatically regenerated.

  3. To save the modifications in the macro body, click the cogwheel icon and select Save changes.

Set the line type settingsLink to Set the line type settings

  1. Switch the page to the edit mode.
  2. Select the macro and click Edit.
  3. Switch to the Adjustments tab.
  4. Configure the line type (solid, dash, dot) and widths (in pixels) settings for each line in your chart.
  5. Save the macro and the page.

To set the line settings in the page view mode:

  1. Hover over the chart controls on the right of the table.
  2. Click the cogwheel icon, select the Modify line settings option. After modifying settings click Save. The chart will be automatically regenerated.
  3. To save the modifications in the macro body, click the cogwheel icon and select Save changes.

Set the logarithmic scaleLink to 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.

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

Show trendlineLink to Show trendline

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

Date & WorklogLink to Date & Worklog

Set the date formatLink to Set the date format

  1. Switch the page to the edit mode.
  2. Select the macro and click Edit.
  3. Switch to the Date & Worklog tab.
  4. Locate the Date format option.
  5. Specify the correct date format for date values in the source table.
  6. Save the macro and the page.
If the app detects the incorrect date format in the page view mode it presents you with the note panel where you can enter the correct date format. It is saved automatically if it is treated as the correct date format.

Set the worklog settingsLink to Set the worklog settings

Please ensure that the worklog parameters set in the macro are identical to parameters configured in Atlassian JIRA.
  1. Switch the page to the edit mode.
  2. Select the macro and click Edit .
  3. Switch to the Date & Worklog tab.
  4. Locate the Worklog settings option.
  5. Define the worklog parameters, as follows:
    1. Days in year - enter the number of days in a year.
    2. Days in week - enter the number of business days in a week.
    3. Hours in day - enter the number of working hours in one business day.
    4. Time format - select the used time format in worklog values.
    5. Year shortening - enter the shortening for the year time unit if you use any language different from English.
    6. Week shortening - enter the shortening for the week time unit if you use any language different from English.
    7. Day shortening - enter the shortening for the day time unit if you use any language different from English.
    8. Hour shortening - enter the shortening for the hour time unit if you use any language different from English.
    9. Minute shortening - enter the shortening for the minute time unit if you use any language different from English.
  6. 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.

Appearance TabLink to Appearance Tab

Set the height and width of the chartLink to Set the height and width of the chart

  1. Switch the page to the edit mode.
  2. Select the macro and click Edit.
  3. Switch to the Appearance tab.
  4. Locate the Height and Width fields.
  5. Enter the appropriate dimensions of the chart.

  6. Save the macro and the page.

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

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

Align chartLink to Align chart

  1. Switch the page to the edit mode.
  2. Select the macro and click Edit.
  3. Switch to the Appearance tab.
  4. Locate the Align chart option.
  5. Select the appropriate chart alignment, as follows:
    • Left
    • Center
    • Right
  6. Save the macro and the page.

Set the legend positionLink to Set the legend position

  1. Switch the page to the edit mode.
  2. Select the macro and click Edit.
  3. Switch to the Appearance tab.
  4. Locate the Legend Position option.
  5. Select the appropriate legend position, as follows:
    • None
    • Right
    • Bottom
  6. Save the macro and the page.

Set the chart titleLink to Set the chart title

  1. Switch the page to the edit mode.
  2. Select the macro and click Edit.
  3. Switch to the Appearance tab.
  4. Locate the Chart title option and enter the title.
  5. Save the macro and the page.

Set axis labelsLink to Set axis labels

  1. Switch the page to the edit mode.
  2. Select the macro and click Edit.
  3. Switch to the Appearance tab.
  4. Locate the Row axis label and Value axis label options and enter the labels.
  5. Save the macro and the page.

Show/Hide source dataLink to Show/Hide source data

  1. Switch the page to the edit mode.
  2. Select the macro and click Edit.
  3. Switch to the Appearance tab.
  4. Locate the Source data option and select the appropriate option, as follows:
    • Show all content
    • Hide tables
    • Hide all content
  5. Save the macro and the page.

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

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

Show gridLink to Show grid

  1. Switch the page to the edit mode.
  2. Select the macro and click Edit.
  3. Switch to the Appearance tab.
  4. Locate and enable the Show grid option.
  5. Save the macro and the page.

Hide chart controlsLink to Hide chart controls

  1. Switch the page to the edit mode.
  2. Select the macro and click Edit.
  3. Switch to the Appearance tab.
  4. Locate and enable the Hide chart controls option.
  5. Save the macro and the page.

Colors TabLink to Colors Tab

Set colorsLink to Set colors

  1. Switch the page to the edit mode.
  2. Select the macro and click Edit.
  3. Switch to the Colors tab.
  4. Select the appropriate colors for each label.
  5. Save the macro and the page.

To set the colors in the page view mode:

  1. Hover over the chart controls on the right of the table.
  2. Click the cogwheel icon, locate the Select colors option. After selecting colors click Save. The chart will be automatically regenerated.
  3. To save the modifications in the macro body, click the cogwheel icon and select Save changes.

Preview OptionLink to Preview Option

While working in the edit mode, use the Show/hide preview option to adjust the required settings before saving the macro and publishing the page.

Zoom in ChartLink to Zoom in Chart

  1. Open the page with the chart you want to zoom in.
  2. Hover your mouse pointer over this chart.
  3. Hold down Ctrl and rotate the wheel button forward to zoom in the chart.

You can also do the following:

To zoom in over the desired chart area:

  1. Click and hold the left mouse button.
  2. Drag the mouse pointer down and right over the chart.

To zoom out the chart:

  1. Click and hold down the left mouse button.
  2. Drag the mouse pointer left over the chart.

To scale up values along chart axes:

  1. Hold down Shift and drag the mouse pointer left or right. (for X axis)
  2. Hold down Shift and drag the mouse pointer upwards or downwards. (for Y axis)

To navigate across the chart:

  1. Hold down Ctrl (for Windows) or Alt (for MacOS) and drag the mouse pointer across the chart.