Page History

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 The chart will be automatically re-generatedregenerated.
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 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:

1. Insert the Chart from Table macro.
2. Hover over the chart controls on the right of the table.
3. Locate the  Labels column   and  Values column   options and select the table columns containing data for chart generation. The chart will be automatically re-generatedregenerated.
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  the Labels column  and  and Values column  options  options in the Settings tab and select the table columns containing data for chart generation.
5. Save the macro and the page.

Create a chart with the same column as labels and values (an example of a use case)

Use case:

You need to visualize a distribution of categories or values within a whole list that is a table column. 

Solution:

1. Wrap the table in the Chart from Table macro.
2. Choose the Pie/Donut chart type.
3. Set the same column as the Values column and the Labels column.
4. Save the macro and the page.

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 Table data orientation option.Decimal separator option.
5. Specify the correct decimal separator for numeric values in the source table (point or comma)Select the Vertical or Horizontal option.
6. Save the macro and the page.

Image RemovedImage Added

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 Decimal separator option.Table data orientation option.
5. Select the Vertical or Horizontal optionSpecify the correct decimal separator for numeric values in the source table (point or comma).
6. Save the macro and the page.

Image Removed

Image Added

Set the worklog settings

1. Switch the page to the edit mode.
2. Select the macro and click Edit .
3. Switch to the Adjustments Date & Worklog tab.
4. Click the Set worklog settings buttonLocate the Worklog settings option.
5. In Define the opened form, 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.

Image RemovedImage Added

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 LookAppearance tab.
4. Locate the Height and Width fields.
5. Enter the appropriate dimensions of the chart.

6. Save the macro and the page.

Align chart

1. Switch the page to the edit mode.
2. Select the macro and click Edit.
3. Switch to the LookAppearance tab.
4. Locate the Select colors button and click itAlign chart option.
5. Select the appropriate colors for each label.
6. To set individual column colors, locate the Color scheme option.
7. chart alignment, as follows:
   • Left
   • Center
   • Right
   Select the  Multicolor or Colors in the table columns option.
8. Save the macro and the page.

Image Added

Show data 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 Show data labels option and select the appropriate option, as follows:
   • None
   • Value
   • Percentage
   • Value (Percentage)
   • Percentage (Value)
5. Save the macro and the page.

Image Added

Callouts

1. Switch the page to the edit mode.
2. Select the macro and click Edit.
3. Switch to the Appearance tab.
4. Locate the Callouts option and select the appropriate option, as follows:
   • None
   • Label
5. Save the macro and the page.

Image Added

Set the chart title

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

Image RemovedImage Added

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.

Hide chart controls

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

Image AddedImage Removed

Colors Tab

Set

colors

1. Switch the page to the edit mode.
2. Select the macro and click Edit.
3. Switch to the Look tab.Locate Colors tab.
4. Select the appropriate colors for each label.
5. To set individual column colors, locate the Color scheme option.
6. Select the Multicolor or Colors in the table columns option the Chart title option and enter the title.
7. Save the macro and the page.

Image Removed

Show data labels

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

Image Removed

Callouts

1. Switch the page to the edit mode.
2. Select the macro and click Edit.
3. Switch to the Look tab.
4. Locate the Callouts option and select the appropriate option, as follows:
   • None
   • Label
5. Save the macro and the page.

Image Removed

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.

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.

Image RemovedImage Added