How to remove a series from a chart or from a document?
In a chart, click on the series you wish to delete then press the ‘Delete’ key. If you wish to remove a series from the document completely you will need to delete it from the Series list.
Category: FAQ
How to create an index?
In Macrobond you can create index in two ways: 1. If your purpose is only to scale series to start at a specific value, like 100, then the Rebase analysis should be used. You’ll find more information on using the Rebase analysis here. 2. The Index Builder analysis can be used to create indices that … Continue reading “How to create an index?”
How to add a trend line/best fit line?
There are two ways of adding trend/best fit line – Statistics and Regression analyses. First one is designed for typical Time charts, second for Scatter charts. Note, it is also possible to omit both those analyses and just use calculations recreating what Regression does and present outcome on Category scatter chart. Line from Statistics In … Continue reading “How to add a trend line/best fit line?”
How to change the language of the automatic text in my chart?
Click anywhere on the white area in the background of the chart. Open the Presentation properties tab. In the Format panel, click ‘Language.’ Here, you can use the language in your current Windows settings or select language from the drop-down menu. See here pre-1.29 version view For more information: Elements of the chart
How to stop new series from being automatically added to a chart?
When you add a new series to a document, it’s automatically included in your charts. To disable this, you have to do the following for each of the charts: Click on an empty area in your chart (i.e., below the x-axis). This opens the general chart properties under the Presentation properties tab. Click ‘More’ in … Continue reading “How to stop new series from being automatically added to a chart?”
How to specify window length in formula language?
Some formulas require you to define a window length. Let’s take as example the formula for a rolling mean: Mean(series, window) For the window length you should input the number of observations over which the function will be calculated. The number of observations is based on the frequency of the document. Instead of typing a … Continue reading “How to specify window length in formula language?”
How to rearrange analyses in the Analysis tree?
Drag the analysis up or down. You can only move analyses within the same branch. This does not affect calculations but can help you reorganize your document. If you want to swap a higher analysis with a lower one (higher/lower in tree hierarchy), you can right-click on the analysis and click on ‘Move up’. Note … Continue reading “How to rearrange analyses in the Analysis tree?”
How to delete a document?
To delete a document, go to the upper menu, File and choose Open. Locate the document you would like to delete, select it and click the ‘Delete’ button at the top of the window. Note that the document will still be available in the Recently deleted folder in the account from where the document was … Continue reading “How to delete a document?”
How to rebase a series?
Add or insert the Rebase analysis in the analysis tree. This is different from the Index builder analysis, which is used for portfolio construction as well as creating indices from weighted averages of several series. You’ll find more information on using the Rebase here: Rebase analysis How to create an index? Rebase in Slice analysis
How to display multiple y-axes?
You can only add two axes to a chart in Macrobond. To display series on a second y-axis, click on the corresponding series, and check box for the setting ‘Use alternate scale’ in Presentation properties. It is not possible to add third y-axis in Macrobond. For more information: Elements of the chart