Use this feature to define the appearance of the axes on your chart. To access it, when viewing a chart, right-click and select axes. The axes window appears.
As you change the settings for the chart, a preview of the chart style is shown at the bottom of the window.
In the axes list at the top left, select the axis you wish to change. Use the following tabs to edit the selected axis:
This tab allows you to set the overall appearance of the selected axis.
Visible: Select this option to display the selected axis. Clear (de-select) this option to hide the axis.
Title: Enter text here that you wish to appear on the selected axis.
Style: Select the shape of the axis (it must have width set to 1 or above for this to take effect).
Width: Specify the axis width.
Major ticks: Enter the number of divisions you want displayed on the axis.
Minor ticks: Enter the number of minor divisions you want displayed on the axis.
Format value: This property controls the layout of the numbers on the axis. Note: you can use special keywords to display information dynamically.
Automatic scale: Select this option if you want the axis to automatically display values based on the chart data. Clear (de-select) it if you want to enter custom values for the axis in min and max (see below).
Min: Enter the lowest value you want displayed on the axis. For example, if you wanted the values 10 to 80 to be displayed, you would enter 10 here. This option is available only if you have cleared (de-selected) automatic scale.
Max: Enter the highest value you want displayed on the axis. For example, if you wanted the values 10 to 80 to be displayed, you would enter 80 here. This option is available only if you have cleared (de-selected) automatic scale.
This tab allows you to set the colour and shading of the axis.
Fill effects: Specifies how the axis bar will be filled (with solid colour, a custom gradient, a texture from an image file, a repeated pattern, or merge all effects, which is a combination of all four fill methods). You can set further options for gradients, textures and patterns in the appropriate tabs. Note: colour or shading options only have an effect if the width option is set to at least 1 on the axis tab.
Transparency: Determines how transparent the axis is. By using the slider, you can set the axis to be solid, completely transparent, or anything in between. Note that if the axis has a border set on the border tab, its outline will still be visible.
Colour: If solid colour is selected in fill effects, this option determines the colour of the axis.
Mapping: Specifies the type of mapping used to apply the fill effect.
Lay-out: Determines how the fill effect is fitted to the axis bar.
X-Scale: Specifies the scaling to be used along the X dimension for the axis bar's background fill effect.
Y-Scale: Specifies the scaling to be used along the Y dimension for the axis bar's background fill effect.
Rotation: Specifies the rotation angle to be used for the axis bar's background texture.
Black texture background: If this option is selected, any parts of the axis bar not covered by the fill effect will be filled in black. If it is not selected, they will be filled according to the colour specified in the colour option, as described above.
This tab, which is available only if you select gradient or merge all effects in Fill Effects on the colour tab, allows you to set the details of the colour gradient for the axis.
width is set to at least 1 on the axis tab.
Begin: Select the colour with which you wish to begin the gradient. For example, if you want the gradient to run from green to white, you would select green here.
End: Select the colour with which you wish to end the gradient. For example, if you want the gradient to run from green to white, you would select white here.
Shading styles: Select the direction in which you want the gradient to run.
Variants: Select the specific pattern of shading. The available choice depends upon the selection you made in shading styles.
This tab, which is available only if you select texture or merge all effects in fill effects on the colour tab, allows you to set a background texture for the selected axis.
width is set to at least 1 on the axis tab.
File: Nominate the image file you want to use to fill the axis. The file must be in Windows Bitmap (BMP), JPEG or GIF format.
This tab, which is available only if you select pattern or merge all effects in fill effects on the colour tab, allows you to set a repeating pattern for the selected axis.
width is set to at least 1 on the axis tab.
Foreground: Select the pattern's foreground colour.
Background: Select the pattern's background colour.
Patterns: Select the pattern with which you want to fill the axis.
This tab allows you to set colour effects for the axis.
Ambient colour: The ambient colour to be applied to the axis. Ambient colour has no discernible source, so is even across the axis. Adding ambient color will usually make the axis brighter.
Diffuse colour: The diffuse colour to be applied to the axis. Diffuse colour comes from a particular direction.
Specular colour: The specular colour to be applied to the axis. Specular light comes from a specific direction and bounces off the axis surface in a specific direction.
Emissive colour: The emissive color to be applied to the axis. Emissive colour emanates from the axis itself.
Shininess: Determines the shininess of the color applied to the axis.
This tab allows you to control the appearance of the borders around the selected axis.
Style: Select the line style (e.g. dotted or solid).
Width: Select the line width.
Colour: Select the line colour.
This tab allows you to control the appearance of the lines that indicate the major units on the selected axis.
Style: Select the line style (e.g. dotted or solid).
Width: Select the line width.
Colour: Select the line colour.
This tab allows you to control the appearance of the lines that indicate the minor units on the selected axis.
Style: Select the line style (e.g. dotted or solid).
Width: Select the line width.
Colour: Select the line colour.
This tab allows you to control the appearance of the numbers (or, in the case of the rows axis, the row labels) that appear on the selected axis.
Facename: Select the font you want to use for the text.
Colour: Select the font colour.
Size: Select the font size.
.png?Policy=eyJTdGF0ZW1lbnQiOlt7IlJlc291cmNlIjoiaHR0cHM6Ly9kemY4dnF2MjRlcWhnLmNsb3VkZnJvbnQubmV0L3VzZXJmaWxlcy8xMTAwLzMzMjkvY2tmaW5kZXIvaW1hZ2VzL2JvbGQoNSkucG5nIiwiQ29uZGl0aW9uIjp7IkRhdGVMZXNzVGhhbiI6eyJBV1M6RXBvY2hUaW1lIjoxNzY3NDM1NTA2fX19XX0_&Signature=FgxdCLADtXFQqIq94shg2z7PoyGyuvYTqyAuxq3lYZAv-7j1u9EmsgU3RUTfLd67MUp-YxBWTcYWl1KwqYc9PH37xeVaTJTcX2WtVbfPyGwOvefLZPfcDbdFIIxDubCIT5qU~6PbyvIPB3FWRuVdtUN-cmukubG3sxG6Fnx6eFC23v4n72pKASiW0NRRfn9juyIxdB1RmtRufyt4xhyxNTkRJwMk3PnEy43bNg~jsHWh3naJETHz-HcsaQZJLEmWEKF0VcavVw4YWe9Uusrpd58ipRqGN2KXi7evItLEWssWASuZD1~iYUiASJVUZkMgfaGOAVpiUvWd-F2mK7g0Rg__&Key-Pair-Id=K2TK3EG287XSFC){kind=small}
.png?Policy=eyJTdGF0ZW1lbnQiOlt7IlJlc291cmNlIjoiaHR0cHM6Ly9kemY4dnF2MjRlcWhnLmNsb3VkZnJvbnQubmV0L3VzZXJmaWxlcy8xMTAwLzMzMjkvY2tmaW5kZXIvaW1hZ2VzL2l0YWxpYyg1KS5wbmciLCJDb25kaXRpb24iOnsiRGF0ZUxlc3NUaGFuIjp7IkFXUzpFcG9jaFRpbWUiOjE3Njc0MzU1MDZ9fX1dfQ__&Signature=GKKcKp4~i2UEWC6BAlfkjwh1PEEElsqLjxcpqNkr~IRxYNScanZXpkqVBjW4paLNA3hNm5tDxH35JkRCcoM4VMnVjxYaMGe3ZCBPRQyWmzoiFigxBLvP9vUPLCp5PxqKpxIng6k5NSqwd9hFPKoPBLXDhTS6ojnY~Z5kz0p1nuluLxk~cjZW6l9VI19XlHfh1ctz5tM5Beec5jitSpsAkqItOOJaGHMVBIaI4G6hB-l45c4FtEG8nAfucbw1bnc23N0zakvO2fec3ICusA6~TaM-kAOzscz2u8WsnjOSG9vB1wzU3lfrBQ5C-GgNkopbTcfPk0FMMgIW~NrYPB78CQ__&Key-Pair-Id=K2TK3EG287XSFC){kind=small}
.png?Policy=eyJTdGF0ZW1lbnQiOlt7IlJlc291cmNlIjoiaHR0cHM6Ly9kemY4dnF2MjRlcWhnLmNsb3VkZnJvbnQubmV0L3VzZXJmaWxlcy8xMTAwLzMzMjkvY2tmaW5kZXIvaW1hZ2VzL3VuZGVybGluZSg1KS5wbmciLCJDb25kaXRpb24iOnsiRGF0ZUxlc3NUaGFuIjp7IkFXUzpFcG9jaFRpbWUiOjE3Njc0MzU1MDZ9fX1dfQ__&Signature=BP1Mh2TRgVzIjKPH1sKpV2tvbdxM~xR7i6ov2K6BAfCHzyWYsnQUz92dBEznKX6dFQ7~eL8drsVpdGOfdYdmUdqWWz5HlIvHmVtenDnih-LZhpfc9J-mCYJKYKoT0~OA4CaIL2MN6b1jfl3nC8FCqKG0K50Pzdfajk4JVkUHmMU5x5L9jQuEfUoA0MV1xA64BdaaLQeUCLuEaQZaAac5Yhz9NaYQbJut45q1NvT2lGSU3dHapqetKBI-uq0lxrSnSQ-YwLC7L1Frn80ww~KyRBV8FZZ9YbtEtOwYSeZQ81uZvjUKb8NF87AgM~J4RP4ExVeAdxUDylv1ccRaH-GqGQ__&Key-Pair-Id=K2TK3EG287XSFC){kind=small}
Font emphasis (bold, italic, underline): Select font emphasis as required (bold, italic or underline).
2D text: Select this option to display two-dimensional (standard) text.
Offset X: Adjust this number to move the text horizontally. This option is available only if you select 2D text.
Offset Y: Adjust this number to move the text vertically. This option is available only if you select 2D text.
Orientation: Enter the angle (in degrees) at which you want the text to appear. For example, to display the text on its side, you might enter 90. This option is available only if you select 2D text.
3D text: Select this option to display the text with three-dimensional effects.
Rotation: Change the value here to adjust the position of the text. This option is available only if you select 3D text.
Elevation: Change the value here to adjust the position of the text. This option is available only if you select 3D text.
Distance: Change the value here to adjust the position of the text. This option is available only if you select 3D text.
Rotation around: X: Enter the angle (in degrees) you want to rotate the text on the X plane). This option is available only if you select 3D text.
Rotation around: Y: Enter the angle (in degrees) you want to rotate the text on the Y plane). This option is available only if you select 3D text.
Rotation around: Z: Enter the angle (in degrees) you want to rotate the text on the Z plane). This option is available only if you select 3D text.
Extrusion: Enter a small value (such as 0.1) to "stretch" the individual characters in the text. This option is available only if you select 3D text.
Horizontal align: Use this property to set the position of the text, relative to the axis.
Vertical align: Use this property to set the position of the text, relative to the axis.
This tab allows you to control the appearance of the title text that appears along the selected axis.
Facename: Select the font you want to use for the text.
Colour: Select the font colour.
Size: Select the font size.
Font emphasis (bold, italic, underline): Select font emphasis as required (bold, italic or underline).
2D text: Select this option to display two-dimensional (standard) text.
Offset X: Adjust this number to move the text horizontally. This option is available only if you select 2D text.
Offset Y: Adjust this number to move the text vertically. This option is available only if you select 2D text.
Orientation: Enter the angle (in degrees) at which you want the text to appear. For example, to display the text on its side, you might enter 90. This option is available only if you select 2D text.
3D text: Select this option to display the text with three-dimensional effects.
Rotation: Change the value here to adjust the position of the text. This option is available only if you select 3D text.
Elevation: Change the value here to adjust the position of the text. This option is available only if you select 3D text.
Distance: Change the value here to adjust the position of the text. This option is available only if you select 3D text.
Rotation around: X: Enter the angle (in degrees) you want to rotate the text on the X plane). This option is available only if you select 3D text.
Rotation around: Y: Enter the angle (in degrees) you want to rotate the text on the Y plane). This option is available only if you select 3D text.
Rotation around: Z: Enter the angle (in degrees) you want to rotate the text on the Z plane). This option is available only if you select 3D text.
Extrusion: Enter a small value (such as 0.1) to "stretch" the individual characters in the text. This option is available only if you select 3D text.
Horizontal align: Use this property to set the position of the text, relative to the axis.
Vertical align: Use this property to set the position of the text, relative to the axis.