<< Click to Display Table of Contents >>

X-Axis Advanced - If X-Axis Data Type is Number


If the data type of the X-Axis is number, set the advanced options for X-Axis in the Advanced dialog by clicking the [Advanced] button in the [X 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. When showing data in exponent format, the number of gridlines can not be set and setting value of Label Interval, Minor Gridline Unit are ignored. Pie and Gauge type of charts are not supported.

# of Gridlines

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

Unit of Gridlines

Sets the unit of gridlines.

Origin

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

Baseline

Sets the baseline of X-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 X-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.

If the X-Axis and Z-Axis are reversed,  the X-Axis will be displayed at a -45 degree angle.


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