Quick answers & simple, step-by-step solutions

- Data
- Analysis
- Why does the Performance analysis not start with 0?
- How do you compare different time periods of a series in the Slice analysis?
- Why outcomes from Rate of change and Scalar’s Rate of change since are different?
- How do you use custom ranges in the Slice analysis?
- How do you use custom points in time in the Slice analysis?
- How do I create an index?
- How to read Category chart from the Correlation analysis?
- How do I add a dummy variable to a regression model?
- How do I add a regression line in a scatter chart?
- How to calculate the mean of a series for different periods?
- How to sort category series after Scalar?

- Calculations
- How do you calculate a Z-Score / Standardize a series?
- How do I annualize a monthly P/P series with a formula?
- How do you rebase a series?
- How do I aggregate a series?
- How do you calculate the median value for a series?
- How do I splice two series together?
- How do I calculate a spread, or subtract one series from another?
- How do you add a moving average / calculate a rolling mean?
- How do you calculate percentage change over period (Y/Y, Q/Q, P/P, M/M)?
- How do I “disaggregate” a series? (Some Chinese data is published by aggregating the periods for each year)
- How do I perform a rolling aggregation of a series?
- How do I lag or lead a series?
- How do I calculate / draw Bollinger lines?
- How do I replace all missing values in a time series with a 0?
- How do I output coefficient / beta in Regression?
- How do I calculate the percentile value of an observation in a series?
- How do you change a series from a ratio to a percentage?
- How do you calculate R2 parameter using a formula?
- How do you calculate a regression line using a formula?
- How do you add a trend line?
- How do you add a trend channel / trend band?
- How do I determine a percentile value of a series?
- How do I define custom formula functions?
- How do I reverse / invert a series?
- How to sum several series together?
- How to calculate a rolling correlation between series?

- Chart elements
- How to disable automatically adding new series into a chart?
- How do you remove (or increase) the gap between columns in a column chart?
- How do I remove grid lines?
- Can I scale all values in text column of Bar chart the same?
- How do you show legend labels on a chart?
- How do you change a Scatter chart from a connected line to dots?
- How do I remove borders from a chart?
- How do I highlight the latest observation on a Scatter chart?

- Chart style
- How do I change the default font?
- How do I add custom chart sizes for presentation purposes?
- How do I change the color of a series when it is below/above 0?
- How do I create, save and apply a new style sheet?
- How do I change the color of the graph area?
- How do I change the color and the font of the chart’s main title?
- How do I change the color of the x and y axis text?
- How do I change the graph’s color?

- Frequency & currency conversion
- Axis
- Can I display multiple y-axes?
- How do you add an alternate axis to the chart?
- How do you add a second, mirrored axis to a chart?
- How do you show value labels on the x-axis?
- How do you show value labels on the y-axis?
- How do I change the x-axis date intervals?
- How to reverse / invert y-axis?
- How do I set a logarithmic scale?

- Formula language
- Logical conditions
- Extending series
- Fill range
- Graph layout
- Text elements
- Annotations
- Bloomberg Connector
- General topics
- MS Office
- Excel
- Application
- Can I change my password?
- How do I check which version of Macrobond is installed?
- How do I check if I’m using a 32-bit or a 64-bit version of Macrobond?
- How do I log out from Macrobond?
- Can I run Macrobond on a Mac?
- Can I run Macrobond on Linux?
- Can I decide to print a chart from MB in color or grayscale from within the application?
- How do I use the automatic proxy configuration tool to find the right method of connecting to the Macrobond servers?