How to use Chart from Table macro

Selecting the chart type and data series

1. On the Confluence page opened in the edit mode, click the Chart from Table macro.
2. Click Edit.
3. In the Insert/Edit Charts from Table Macro form, define parameters of the macro, as follows:
   • Labels / Dates / X-axis value column - select the appropriate column containing the required data for chart generation. The name of the parameter, as well as data type may vary for different chart types.
   • Values column - select the column containing numbering values for chart generation.
   • Type - select the type of chart to generate.
4. Click Save.

Configuring look of the chart

1. On the Confluence page opened in the edit mode, click the Chart from Table macro.
2. Click Edit.
3. Switch to the Look tab.
4. Configure the parameters affecting the look of chart.
5. Click Save.
6. Save the page.

To set the chart dimensions:

1. Locate the Height and Width fields.
2. Enter the appropriate dimensions of the chart.

To set colors for chart elements (labels):

1. Locate the Select colors button and click it.
2. Select the appropriate colors for each label.

To set the chart alignment:

1. Locate the Align chart option.
2. Select the appropriate chart alignment, as follows:
   • Left
   • Center
   • Right

To show the chart legend:

1. Locate the Legend Position option.
2. Select the appropriate legend position, as follows:
   • None
   • Right
   • Bottom

Adjusting chart configuration

1. On the Confluence page opened in the edit mode, click the Chart from Table macro.
2. Click Edit.
3. Switch to the Adjustments tab.
4. Adjust the parameters affecting presentation of data series.
5. Click Save.
6. Save the page.

To set the date format:

1. Locate the Date format option.
2. Specify the correct date format for date values in the source table.

To show the trendline:

1. Locate and enable the Show trendline option.

Managing Charts in the Page View Mode

Once you have defined settings of the Table chart macro and saved the page, you get a page with the generated chart.

To the right side of your chart, you can locate the chart management sidebar. It allows you to alternate the following parameters of Chart table macro:

• Labels column - change the column with labels for another one. 
• Values column - change the column with data values. The chart will be automatically re-generated. Depending on the used chart type you may select column with numerical through Values column X and Values column Y fields.
• Dates column - change the column with dates. The chart will be automatically re-generated. This select box is shown for Time Line and Time Area charts only.
• Type - change the chart type for another one. You may need to re-select the table columns when changing the chart type.
• Height/Width - specify the required dimensions of the chart.

To save new parameters in the macro body:

1. Click the Cogwheel  icon.
2. Select Save changes.

To export the chart:

1. Click the Cogwheel   icon.
2. Select  Export to PDF  or  Export to Word.

To save the chart as image:

1. Click the Cogwheel  icon.
2. Select Chart as image.

To update the colors used for charts and graphs:

1. Click the Cogwheel  icon.
2. Click Select colors.
3. Click the color picker and select the appropriate color on the palette. 
4. Click Apply to use the selected colors and redraw your chart or graph.

To show the source table:

1. Click the Cogwheel  icon.
2. Select Show source table.

To set the date format:

From 3.12.0 version, the Table Filter and Charts app allows you to set the correct date format in the page view mode. If the app detects the incorrect date format 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.

Removing Chart from Table macro for Table

1. Switch Confluence page to the edit mode.
2. Select the Chart from Table macro with the table or macro outputting the table.
3. Click Unwrap.

Copying a table into Chart from Table macro

1. Switch Confluence page to the edit mode.
2. Position the mouse pointer into any cell of the table you want to copy.
3. Click the Copy Table  icon on the editor pane.
4. Paste the table into the Chart from Table macro on the same or on a new page.

Zooming 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.

Filtering the source table

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

Setting worklog settings

1. Switch the page to edit mode.
2. Select the macro and click Edit.
3. Switch to the Filtration tab.
4. Click the Set worklog settings button.
5. 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.
6. Click Save.
7. Save the macro and the page.