<< Click to Display Table of Contents >>

Y-Axis - Advanced


Sets the advanced options for Y-Axis in the Advanced dialog by clicking the [Advanced] button in the [Y Axis] tab.

Major Gridlines, Minor Gridlines

Sets the position, length of Major/Minor gridlines.

Show in exponent format

Determines whether or not to show data as exponent format.

# of Gridlines

Sets the number of gridlines. Draw the gridline automatically according to data value by checking the "Auto" option, or directly input a number.

Unit of Gridlines

Sets the unit of gridlines.

Origin

Origin is the Y-Axis value of the location where X-Axis and Y-Axis cross each other. A baseline created by origin setting follows the Y-Axis Major Gridline style, and it can be changed by the "Line Style" option. But, it is only available when the "Show Major Gridline" option is checked.

Baseline

Sets the baseline of the Y-Axis.

Min/Round Down

Sets the minimum value and digit to round down. To automatically set the minimum value according to data, check the Auto option. To set the minimum value to a specific value, uncheck the Auto option and enter a value. When you enter the digit to round down, set a minimum value to an empty value.

Max/Round Up

Sets the maximum value and digit to round up. To automatically set the maximum value according to data, check the Auto option. To set the maximum value to a specific value, uncheck the Auto option and enter a value. When you enter the digit to round up, set a maximum value to an empty value.

Label Inclined

Sets whether or not to display the Y-Axis label at a 45 degree angle.

If the option is checked, the following restrictions apply.

The text direction is ignored, and the text is displayed in a single line. The newline character is converted to a space character.

When the report is exported to the PDF or SVG file, the labels will not be exported. But when the "Save chart to image" option in the PDF save option dialogue is checked, chart labels are exported.


Example - Round Down and Round Up

If you set these options as a positive value, the digits to the left of the decimal point are rounded. If you set these options as a negative value, the digits to the right of the decimal point are rounded.

The original value

Round Down

Applied Value

1276

2

1200

-1276

2

-1300

12.76

-2

12.7

-12.76

-2

-12.8

The original value

Round Up

Applied Value

1216

2

1300

-1216

2

-1200

12.16

-2

12.2

-12.16

-2

-12.1