Chart’s graphics & elements
More about Chart elements can be found in: Elements of the chart
Category: FAQ
Formula language
Application’s functions
How to add/sum up series?
If you want to sum values across few series, there are two main ways to achieve this: 1. Formula language You can sum multiple series by typing a simple expression with the ‘+’ sign. It will add up only common part for all series. 2. Cross Section analysis Use the Cross section analysis to calculate … Continue reading “How to add/sum up series?”
How to specify date in formula language?
You should refer to a date using the Date() formula. Date(year, month, day) It returns the observation number of the specified date. Make sure you input the components of the date in the right order. For example: Date(2017, 01, 01) For more information: Formula analysis
Can I display series with different frequencies on the same chart?
In Macrobond, a chart can only display series with the same amount of observations per year. When adding several time series with different frequencies, if no settings are changed, the document will harmonize the frequency of each series to the highest available one. Time series with a lower frequency will be converted to the higher … Continue reading “Can I display series with different frequencies on the same chart?”
How to edit / remove the axis text: lhs and rhs?
Click outside the chart area and go to the Presentation properties tab. In the Format panel, you can edit or delete the ‘, lhs’ and ‘, rhs’ text. If you change your mind you can click on the ‘x’ button to bring back the default text. For more information: Elements of the chart
How to hide analysis texts like, c.o.p 12 months?
By default, the analysis text appears in brackets in the legend text. You can remove it by clicking outside of the chart area. In the Presentation properties tab, untick the setting ‘Analysis texts’. For more information: Elements of the chart
How to aggregate a series?
There are two main possibilities to aggregate series: 1. Aggregate analysis Specify the period over which you want to aggregate the series. You also have the option of making this a rolling sum. 2. Formulas AggregateSum(series) Sums up all values from the start of the series. AggregateSumAnnual(series) Sums up values of a series on a … Continue reading “How to aggregate a series?”
How to change how time range is displayed on the x-axis?
Click on the x-axis and open the Presentation properties tab at the top of the window. In the Labels group you can manipulate the scaling of the axis. The automatic setting will label the scale with the frequency that allows for the best view. Unchecking it will enable you to use the manual step option which … Continue reading “How to change how time range is displayed on the x-axis?”