Select the chart typeTo select the chart type in the page view mode:
To select the chart type in the macro browser:
|
Select data seriesLabels 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:
To select data series in the macro browser:
|
Select data seriesX-axis value column - the column containing numerical 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:
To select data series in the macro browser:
|
Select data seriesDates 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:
To select data series in the macro browser:
|
Set the date format
|
Set the decimal separator
|
Set the worklog settings
|
Set the table data orientation
|
Set the minimal and maximal valuesMinimal 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.
|
Set the minimal and maximal valuesMinimal 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.
|
Set the scale stepScale Step - the required scale step for showing the numeric values in the chart.
|
Set the scale stepScale X (Y) Step - the required scale step of Y axis for showing the chart.
|
Set the scale stepScale 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:
Scale Y Step - the required scale step of Y axis for showing the chart.
|
Set the interpolation
|
Set the logarithmic scaleLogarithmic scale X - the option for very small or very large numeric values that cannot be properly aligned on the standard arithmetic scale. Logarithmic scale Y - the option for very small or very large numeric values that cannot be properly aligned on the standard arithmetic scale.
|
Set the logarithmic scaleLogarithmic Scale - the option for very small or very large numeric values that cannot be properly aligned on the standard arithmetic scale.
|
Show trendline
|
Filter the source table
|
Set the height and width of the chart
|
Set colors
|
Set colors
|
Set colors
|
Set the line type settings
|
Align chart
|
Set the legend position
|
Show grid
|
Show/Hide source data
|
Hide chart controls
|
Set the chart title
|
Set axis labels
|
Set axis labels
|
Show data labels
|
Set dependencies
|
Zoom in chart
You can also do the following: To zoom in over the desired chart area:
To zoom out the chart:
To scale up values along chart axes:
To navigate across the chart:
|