Axis & Scale

How to:

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. 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 tab 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 lengthReverse 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.

There are two ways to use thousand separator:
  • 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 properties 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 trillion. Instead of typing '1000000000000' in the Display range box, you can type '1e12.' The Scientific E-notation is written as: 'xey' (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).

How to show year above month on x-axis?

This feature is available in Macrobond 1.25 and later.

By default, on x-axis month is shown above year. You can use setting - Spacing - with Distance, to change the order. Set Spacing to negative value to move years above months.