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. In the Appearance box, change the default font. You can use the ‘…’ button to select from the full list of installed fonts. For more information: Elements of the chart
In Search tab, choose ‘Include discontinued’ from the Filter drop-down list: In data-tree, enable the filtering option (funnel icon) and tick ‘Include discontinued series’:
To flip or reverse the y-axis: Select the y-axis on your Time chart. Switch to the Presentation properties tab and locate the Scale panel. Under ‘Reverse’ select ‘Yes’. For more information: Elements of the chart
There are two main possibilities to achieve this: 1. The Conversion settings tab in Series List You can set the ‘Missing Value Method’ as ‘Zero Value’. 2. Formula You can also use the formula: Null0(series) For more information: Formula analysis
To convert a ratio to a percentage, you need to multiply the ratio by 100. There are two main possibilities to achieve this: 1. The Arithmetic analysis Set the 2nd operation field to ‘Multiply’ and ‘Value operand’ to 100: 2. Formula You can also use the formula language, by appending ‘*100’ at the end of … Continue reading “How to turn series into percentage?”
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.
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?”
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?”
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
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?”