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.
You can define the step length for scale of y-axis (or both if it's a Scatter chart).
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
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
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.
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.
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: ‘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).