The selection of the materials in this section highlight the most essential tools and options of creating charts in Macrobond application.

Introduction to charting - overview video

Transcript (click to expand)
[01 General introduction - what is charting?]

In this video, we’ll introduce you to a few of the main elements of charting before going into more detail in the next steps of the curriculum. When it comes to charting, two things are important to our users:
the first is being able to clearly and persuasively present data,
and the second is being able to create these presentations quickly.
Some of the features that contribute towards these aims are intuitive point and click editing, a variety of chart styles to choose from, and customized style sheets, just to name a few. All in all, you’re saving time and getting your point across effectively.

[02 "Point and click" approach]

Point and click functions on the principle that any element of a chart you click on will activate the editing options for that element, in the command bar above. As you can see, when we click on the chart heading the presentation properties tab becomes active – here - and any changes made are instantly applied.

[03 Alternate scale and date range intro]

Besides adjusting the more cosmetic chart properties like color or font, you can easily modify properties such as scale and date range on the axes.

[04 Adding an alternate scale and date]

The same point and click principle applies, whether you’re adding an alternate scale or changing the date range.

[05 Additional chart modifications – adding horizontal line]

Besides the fundamental formatting options you also have the option to emphasize certain aspects of a chart. For example to draw attention to specific points you can add text annotations, markers or labels. For this chart, we might like to add a horizontal line at a specified value, you can do it manually, or just specify the precise position, here.

[06 Graph layout]

Now let’s look at the presentation styles I mentioned before, you’ll find them in the graph layout options. There are numerous reasons to make these changes of course, but in this case the chart might just be more impactful if we apply an area graph style for Industrial production, for example. Not bad, but it would be better if the graph line for ISM PMI weren’t partially hidden. So we’ll just fix that by adjusting the order. As you can see, the tools have been designed to be very intuitive to use.

[07 Fill range]

Let’s take a look at one last feature that will help you highlight a particular angle in a data – in this case recession bands will work nicely.

[08 Final comments]

This video should give you a good understanding of the logic of charting in the application, and an overview of some of the main features you can make use of. For more detailed coverage of the available tools, as well as step by step guide and tutorials have a look at the next stages of the curriculum.

Displaying data on a chart

Using the Fill range charting function - video

Transcript (click to expand)
[01 Introduction to Fill range function]

Fill range is a function that fills a segment of a chart with color, based on a defined range or sequence of dates. In this video, we’ll look at when to use a fill range, how to create a custom fill range, how to save a particular range for future use and how to add recession bands.

[02 When to use Fill range]

A fill range can be used to draw attention to a segment of the charted data, like this. Alternatively, you can use the fill range function to create an additional layer of information. In this example. We’ve added a fill range corresponding to periods of recession, creating recession bands that provide context for interpreting the chart. Once you’ve specified a custom range you can also save it if it’s something you’re likely to use again.

[03 Adding Fill range to chart - 1]

Let’s start by adding a fill range to a chart. Right click on the chart and select fill range from the context menu. You can also use the keyboard shortcut, Ctrl+F.

[04 Adding Fill range to chart - 2]

You’ll notice that the entire chart is filled because we haven’t defined a range yet. To do so click on the add button to define the settings for the fill range. To define more than one range, just click on add again.

[05 Customizing the Fill range]

To customize the range, you can specify a start and end point. In the start field, the first observation for the specified date will be used. In the end field, the last observation for the specified date will be used. For example, entering 2010 in start, and 2011 in end, will give you a fill range from the first observation for 2010, to the last observation for 2011. If you hold your cursor over the start or end fields, you’ll activate a tooltip describing different options for inputting the start and end points for the range.

[06 Customizing the color]

The default color for the fill range is based on your default stylesheet. To change the color, simply check custom, here, and select a color using the drop down menu or the advanced settings.

[07 OK and Export buttons]

Before finishing off let’s look at the buttons at the bottom of the dialog box. Use cancel to void the task, and ok to complete it and go further. The export button allows you to save the range you just created for quick access in the future. Simply select the account you’d like to save it to, and give it a name.

[08 Import button and Using pre-defined Fill range]

To access pre-defined and saved ranges click on import. You can either select from ranges created by you and your colleagues, or from a list of ranges defined by Macrobond.

[09 Recession bands - 1]

A quick way to apply recession bands to your chart is to select from the list in the Macrobond library. What you have here is a list of pre-defined ranges based on periods of recession in different countries. Where relevant, the source is referenced in parentheses. Ranges without a source listed are calculated by Macrobond.

[10 Recession bands - 2]

Let’s select the US recession range from NBER, and press ok. As you can see, there is a new row for every date range corresponding to a period of recession in the US. You can customize these ranges in the same way as before. When you’re done, click OK, to complete the task.

Using chart panes

In the graph layout options, you’ll find a button that allows you to add additional panes to a chart.

Additional panes are useful for:

  • Presenting multiple time series clearly, in a single chart
  • Presenting time series on more than two different scales

How to add a pane

  1. Open the Graph layout dialog
  2. Click on the Add pane button
  3. Drag-and-drop the time series, below the new pane section

There is no limit to the number of panes you can add. All panes, except the first one can be deleted.

Instead of adding panes one by one, you can select from various predefined layout in the Graph Layout window. That way the chosen number of panes will automatically be added to the document. At this point you can drag and drop series into the correct pane.

Changing the layout

Once you have your panes in place, this feature can also be used to quickly adjust the proportional size of the panes by selecting a different layout option. Of course, you can always adjust the size of the panes by manually dragging the border.

Graph layout - video

Transcript (click to expand)
[01 What you’ll learn]

The application includes a variety of features for customizing your charts, so even the most complex charts will communicate a clear message. In this video, we will look at the Graph Layout feature, which allows you to select graph styles, customize the chart layout, hide a series and add or remove panes. Before we begin, a quick reminder that in the application we refer to the graphic representation of each series in a chart, as a graph.

[02 Open the Graph layout dialog]

There are three ways to access the Graph Layout settings: you can click on the button, here, use the keyboard shortcut, CTRL + L, or right-click on the chart and select Graph layout from the context menu.

[03 Elements of the Graph layout dialog]

From here you can manage the appearance of your chart. On the left is a list of all the series from the document that you can add. On the right you can see which series are currently being displayed, the order they are displayed in and what graph-style is used for each.

[04 Apply a graph style to the chart/series]

At the top of the window you can choose from a list of graph styles. To change the style of a series, click on it and then select a graph style.

[05 Change the style of a series]

If you have a number of series listed under one graph style, the drop-down list is an easy way to change all of them at once. Check ‘Alt. scale’ if you want the graph drawn relative to the main or alternate scale.

[06 Customizing the chart layout]

Changing the layout of the graphs can also improve a chart. For example, in this chart it would be better to have the Area graph in the background, and the Line graph on top. To change the order of the graphs as they are presented, drag and drop each one into the right order. The graphs are added to the chart in the order shown, so the last series will be added to the chart last, and positioned on top of the other graphs.

[07 Deleting series from a chart]

Only time series shown in the Graphs section will be visible on the chart. So, if you don’t want a series displayed, simply remove it by selecting Delete from the context menu.

[08 Visualizing a series with more than one graph]

Visualizing a series more than once, and applying a different graph style, can help you to emphasize a particular point in the data. All the series in the Input list on the left can be added to the chart multiple times. In our case, we can for instance highlight the Area graph by adding the same series as a Line graph. Drag Industrial Production from the left to the right panel, and place it under the Line style.

[09 Add or remove chart panes]

If you want to display these series separately, add a new pane. Select from the predefined pane layouts here, or adjust the panes manually by dragging them up or down.

Adding more series to a document, but not to a chart

By default, when you add a series to a document, the series is automatically visualized in your chart(s). So, what do you do if you want to continue adding series to a document without having them appear in your completed chart? Simply switch off the default setting for the chart in question, and continue adding series.

How to stop series from being added to a chart
  1. Click on the background of the chart
  2. Select the Presentation properties tab

  3. Click on the More button in the Chart elements group
  4. Click on Include new series automatically to deselect the setting
Using in practice

As you can see, this setting is chart specific. That way you can continue to create new charts without having to manually add the series to them. Just make sure to switch off the settings every time you finish a chart if you want to keep adding series to your document.

Adding an alternate scale to charts

When building a chart, it may be useful to display time series on distinct axes. A typical use-case is when series are expressed in different units. The time charts you build in the application have two axes that series can be assigned to. This article will provide you with a quick overview of the alternate scale feature, as well as what to keep in mind when using it.

Setting the alternate scale

Like most of the charting functions, you start by clicking on a graphic element, a line or column for example, to select which series you want to work with. The alternate scale setting is found in the command bar, under the presentation properties tab.

You can also select which series should be shown on an alternate scale when working in the graph layout dialog.

Alternate Scale and Synchronizing axes

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, below.

  • 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.

Using different types of charts

Creating Bubble charts - video

Transcript (click to expand)
[01 Introduction]

In this video we’ll take a look at how bubble charts work in Macrobond, how to create them, and how to modify them.

[02 Constructing a bubble chart - basics]

Before we get into creating a bubble chart it’s worth knowing a bit about the logic behind it. As you can see on the axes, this chart looks at debt to GDP and the deficit or surplus to GDP, for a selection of European Union countries.

[03 Scalar analysis – Partition option]

Quite obviously, these series take care of where the bubbles are located on the grid. So, what about the size of the bubbles? In this chart the size of each bubble is defined by a third series, GDP and displayed relative to the other countries. To achieve that we used the Partition into 3 series setting in scalar Analysis.

[04 The size of the chart bubbles]

So, just to recap: the size of the bubbles is dependent on one series, while the location of the bubbles is dependent on another. For example, time charts and category charts require two series. Scatter charts and category scatter charts, as in the example, require three.

[05 Adding a Category scatter chart]

Now, sticking to our example, let’s take a step-by-step look at how we created this bubble chart. Once you have your data in place and have applied the necessary calculations the next step is to add a Category scatter chart, because the Scalar analysis produces category series.

[06 Graph layout dialog – bubble chart]

To change the presentation of the data to a bubble chart, go to Graph Layout - you can access it by right-clicking on the chart.

[07 Graph layout dialog - organizing series 1]

What we want to do in this window, is organize our series so that they are applied to the correct axes. First, change the type of chart to Bubble, here. Drag any series that are presented as a Line Graph to the Bubble graph and delete the Line graph.

[08 Graph layout dialog - organizing series 2]

As usual with scatter charts, the 1st series in the list is applied to the X-axis, the 2nd to the Y-axis and the 3rd series will be used to define the size of the bubbles.

[09 Adjusting size of bubbles]

To adjust the size of the bubbles, click on one of them. You’ll find the size settings under the presentation properties tab, here. The value is given in pixels. This number will set the size of the biggest bubble, all others will be adjusted proportionally.

[10 Negative bubbles]

By default, bubbles with negative values are not visualized. Simply mark the check box to include them. When negative bubbles are visualized the size of the bubble is defined by the absolute value of the series.

[10 Conclusions]

For more tutorials on using different chart styles have a look at the other materials provided in this section.

Editing text elements of the chart

Adding Annotations to a Chart

Using annotations will help you direct attention to the most important aspects of a chart, helping the reader to clearly identify what is relevant.

Under the chart annotations tab, you’ll find:

  • Inks – a free-hand option for highlighting portions of your chart
  • Chart ornaments – defined shapes or text boxes you can place anywhere in the graph area
  • Annotations – labels and lines that can be added to a particular value on the x and/or y axes

Inks don’t need much explanation, so we’ll focus on going through a quick description of chart ornaments and annotations.

Chart Ornaments

Ornaments are added independently of any value in a chart and moved freely

  • As a text box
  • As a line
  • As an arrow

The size and position of an ornament can be adjusted manually, by clicking and dragging.

If you shorten the date range of the x axis, resulting in a closer view of the graph lines, the text box will not move to accommodate the change.

How to add ornaments?

  1. Select the ornament type from the command bar
  2. Draw-out the ornament in the graph area, to an appropriate size
  3. Move it to an appropriate position if necessary

When to use ornaments?

  • When you want to add a general note
  • When you want to highlight something that is not related to a single value in the chart


Annotations are added relative to particular values in a chart:

  • As a vertical line, associated with a value on the x axis
  • As a horizontal line, associated with a value on the y axis
  • As an observation, associated with a value coordinate, on both the x and y axes

If you changed the scale of the y axis in the image below, the horizontal line would move with its reference value.

How to add annotations?

  1. Select the annotation type from the command bar
  2. Click on a relevant position in the graph area, to add the annotation

When to use annotations?

  • When you want to specify which values to add annotations to
  • If you plan to update the data in a chart, or make adjustments to the x or y axes, using annotations will ensure that the annotations you add remain in the correct position

Opening charts in a separate window - video

Transcript (click to expand)
[01 Why to use Presentation documents?]

In the command bar of the application you’ll see a button with a P on it, this allows you to present charts in a separate window. Besides being the first step in compiling a presentation of charts there are two other benefits to be had. You can use it to quickly open and compare a number of different charts. And you can use it as a viewing pane to monitor the changes to your chart as you make adjustments to time-series calculations. In this video, we’ll go through a quick use case for how to use the present button for these added benefits.

[02 Use case example – Covariation]

Let’s say we want to define the length of a rolling correlation, in a way that will best convey a particular point.

[03 Opening a chart in a separate window]

Click on the present button in the command bar, or use the Ctrl+Q keyboard shortcut.

[04 Performing changes in the analysis using information from the 2nd window]

With the chart open in a Presentation document window we can see how the visualization is affected as we specify different lengths for the rolling correlation, and adjust the settings until we get the desired results.

[05 Comparing two charts]

Before you finish off, you might want to compare this chart with another. Simply open the relevant document, we’ll take the one that’s already open here select a chart in the Analysis tree and present it in a new window.

[06 Conclusion]

As you can see, there are a few different ways you can make use of the present button to make it easier to work with charts. If you’d like to learn more about creating Presentation documents have a look at the suggested materials at the bottom of the page.

Change region - video

Transcript (click to expand)
[01 What you’ll learn]

In this tutorial we will look at what the change region feature is, when to use it, and go through a step-by-step example for how to do so.

[02 What is change region]

Change region allows you to take the data in a document and quickly change which country or region the data refers to. You can use it to change an existent document or duplicate the document and then apply it to create a new version. A typical use case and benefit is saving time when creating a report that looks at the same analyses for a number of countries.

[03 When to use change region]

Let’s say you are building a document using US data and you want to look at the same analyses, but for the UK. If you don’t want to change the original document, make sure to duplicate it first, by selecting Duplicate from the file menu, here.

[04 Select change region from the menu]

Once you’re ready, select Change region from the file menu to open the settings dialog. Right at the top you’ll see the list of series that Change region can be applied to. Click on the drop-down menu, here, to select the relevant country or region.

[05 Select the concept-type]

It’s possible that some series might reference more than one concept. In this case, the US ISM indicator refers to two concepts: PMI and Business Confidence. You can select which concept you want to use here.

[06 No equivalent for selected series]

You can only use change region for a series if Macrobond has mapped a suitable equivalent for the country or region you have selected. So, if you see one of the series listed here, you know why. You can try changing these series manually later – but bear in mind that some series haven’t been mapped because there isn’t a suitable equivalent available. All the series you can find in By concept though will work for Change region.

[07 Viewing changes]

Once you’ve made your selection you can view the changes before implementing them, by clicking on Apply. This will keep the settings dialog open, so you can easily make adjustments to your selection before finalizing the changes. When you’re ready, click on OK, or on Cancel to void the changes.

Return to the main page of Macrobond Learning Resources