Settings=
h1>
Select the chart type
To select=
the chart type in the page view mode:
- Insert th=
e 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-generat=
ed.
- To save the modifications in the macro body, click the cogwheel ic=
on and select Save changes.
To select=
the chart type in the macro browser:
- Switch the page to the edit mode.
- Insert th=
e Chart from Table macro and paste the table within the macro body=
.
- Select the macro and click Edit.
- Locate the Type option in the S=
ettings tab and select the chart type.
- 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 d=
ata series in the page view mode:
- Insert th=
e 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 genera=
tion. The chart will be automatically re-generated.
- To save the modifications in the macro body, click the cogwheel ic=
on and select Save changes.
To select d=
ata series in the macro browser:
- Switch the page to the edit mode.
- Insert th=
e 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 Se=
ttings tab and select the table columns containing data for c=
hart generation.
- Save the macro and the page.
Select data series
X-axis value column - the column containing num=
erical values for chart generation (horizontal axis).
Y-axis value column - the column or columns containing =
numerical values for chart generation (vertical axis).
To select=
data series in the page view mode:
- Insert th=
e Chart from Table macro.
- Hover over the chart controls on the right of the table.
- Locate the X-axis value column and Y-axis valu=
e 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 ic=
on and select Save changes.
To select=
data series in the macro browser:
- Switch the page to the edit mode.
- Insert th=
e Chart from Table macro and paste the table within the macro body=
.
- Select the macro and click Edit.
- Locate the X-axis value column and<=
/span> Y-axis value column options in the&nbs=
p;Settings tab and select the table columns containin=
g data for chart generation.
- Save the macro and the page.
Select data series
Dates column - the column with dates f=
or 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:
- Insert th=
e Chart from Table macro.
- Hover over the chart controls on the right of the table.
- Locate the Dates column and Values column options and select the table columns containing data for chart ge=
neration. The chart will be automatically re-generated.
- To save the modifications in the macro body, click the cogwheel ic=
on and select Save changes.
To select=
data series in the macro browser:
- Switch the page to the edit mode.
- Insert th=
e Chart from Table macro and paste the table within the macro body=
.
- Select the macro and click Edit.
- Locate the Dates column and<=
strong> Values column options in the Settings tab and select the table columns containing data f=
or chart generation.
- Save the macro and the page.
Adjustments
- Switch the page to the edit mode.
- Select the macro and click Edit.
- Switch to the Adjustments tab.
- Locate the Date format option.
- Specify the correct date format for date values in=
the source table.
- Save the macro and the page.
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 t=
he source table (point or comma).
- Save the macro and the page.
Set the worklog settings
- 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:
- Days in week - enter the number of business days =
in a week.
- Hours in day - enter the number of working hours =
in one business day.
- Time format - select the used time format in work=
log values.
- Week shortening - enter the shortening for the we=
ek time unit if you use any language different from English.
- Day shortening - enter the shortening for the day=
time unit if you use any language different from English.
- Hour shortening - enter the shortening for t=
he hour time unit if you use any language different from English.
- Minute shortening - enter the shortenin=
g for the minute time unit if you use any language different from Engl=
ish.
- Save the macro and the page.
Set the table data or=
ientation
- 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.
Set the minimal an=
d 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 s=
howing 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.
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 v=
alue.
- Switch the page to the edit mode.
- Select the macro and click Edit.
- Switch to the Adjustments tab.
- Locate the Minimal X (Y) and Maximal X (Y=
) value options and set the minimal and maxi=
mal values.
- Save the macro and the page.
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.
Set the scale step
Scale X (Y) Step - the required scale step of Y ax=
is for showing the chart.
- Switch the page to the edit mode.
- Select the macro and click Edit.
- Switch to the Adjustments tab.
- Locate the Scale X (Y) Step options and set the s=
cale step.
- Save the macro and the page.
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 year=
s (Xy) where the 'X' is the digit, as follows:
- 10d =3D 10 days as a scale step
- 1m =3D 1 month as a scale step
- 2y =3D 2 years as a scale step
Scale Y Step - the required scale step of Y axis f=
or showing the chart.
- Switch the page to the edit mode.
- Select the macro and click Edit.
- Switch to the Adjustments tab.
- Locate the Scale X (Y) Step options and set the s=
cale step.
- Save the macro and the page.
Set the logarithmic scale=
Logarithmic scale X - the option for very small or very=
large numeric values that cannot be properly aligned on the standard arith=
metic scale.
Logarithmic scale Y - 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 X (Y) options and en=
able the option.
- Save the macro and the page.
Zoom in chart
- Open the page with the chart you want to zoom in.
- Hover your mouse pointer over this chart.
- 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:
- Click and hold the left mouse button.
- Drag the mouse pointer down and right over the chart.
To zoom out the chart:
- Click and hold down the left mouse button.
- Drag the mouse pointer left over the chart.
To scale up values along chart axes:
- Hold down Shift and drag the mouse pointer left or right. (for X axis)<=
/li>
- Hold down Shift and drag the mouse pointer upwards or downwards. (for Y=
axis)
To navigate across the chart:
- Hold down Ctrl (for Windows) or Alt (for MacOS) and drag the mouse poin=
ter across the chart.