**How to:**

- change axis title?
- change chart scale?
- change step length?
- add thousand separator to y-axis?
- add an alternate axis (scale) to the chart?
- synchronize axes when adding alternate scale?
- set a logarithmic scale?
- change the scale of y-axis when working with large numbers?

# How to change axis title?

To rename units of the y-axis, click on the area right above the top of the axis. This will result in ‘Properties for Axis title’ to be shown in the Presentation properties group box. Then, click on the Edit button next to ‘Axis title’ and input your desired unit name. You can also use Dynamic text here. It will only change name of y-axis, the units will remain the same.

# How to change chart scale?

You can adjust the chart scale by accessing ‘Properties for Value axis’ in the Presentation properties’ group box by clicking on the y-axis. Here, the Scale section is where you can modify the scaling. You can define the *Display range* and *Step length*. *Reverse* the scale and *Logarithmic* scaling are also available options.

Click on the *More* button to access further options: *Scaling* where you can choose in which scale the y-axis will be presented and *Decimals* which modifies decimal places.

# How to change step length?

You can define the step length for scale of y-axis (or both if it's a Scatter chart).

# How to add thousand separator to y-axis?

Starting from 1.24 version of Macrobond it is now possible to use optional Thousand separator setting for the axes in the charts. It adds a separator after every third digit for numbers larger than 1,000.

#### From Presentation properties

This feature is available in Macrobond 1.24 and later.

There is a Thousand separator setting for the axes in the charts. It adds a separator after every third digit for numbers larger than 1,000. You can tick Thousand separator option in Format

#### From Dynamic text

It is also possible to use it in Dynamic text window

# How to add an alternate axis (scale) to the chart?

There are two ways to add an alternate axis to a chart:

- Click on a graph in your chart, in the tab presentation properties tick the checkbox “Use alternate scale”

- Right click in the graph area, choose
*Graph layout*and tick the checkbox for*Alt scale*

# How to synchronize axes when adding alternate scale?

Using the Synchronize settings will affect the way in which the alternate scale is displayed. Below we go over the outcomes of combing these settings

**Alternate Scale + Synchronize:***None*

Each axis has an independent scale and independent grid.**Alternate Scale + Synchronize:***Grid*

Each axis has an independent scale, but both axes will share the same grid. You can’t adjust the step length of the axes, only the scale range.**Alternate Scale + Synchronize:***Values*

Each axis will share the exact same scale and grid, which will void the outcome of applying an alternate scale.

# How to set a logarithmic scale?

Click on the y-axis and open the *Presentation propertie*s tab at the top of the window. In the Scale group, check the “Logarithmic” option.

You cannot set logarithmic scale from 0 as the logarithm of zero is not defined.

# How to change the scale of y-axis when working with large numbers?

When dealing with series expressed in large values, for instance billions or trillions, you can use a scientific notation for decimal precision instead of manually typing the whole number.

Let’s say you have a series that is expressed in trillions, and would like to change the range of the Y-axis scale, so that it reaches 10 trillions.

Instead of typing ‘1000000000000’ in the Display range box, you can type ‘1e12’. The Scientific E-notation is written as: ‘*x*e*y*’

(*x* times ten raised to the power of *y*).

70 000 000 can therefore be written as 7e7. It also works with decimals (e.g. 1.5e9, meaning 1,5 billions).