Recession bands (Fill range)

How to:

How to add recession bands to chart?

To add recession bands (shading), right-click in a chart and choose Fill range. In the Fill range window, click on the Import button and choose the desired country or region. When clicking OK, the selected recession band (shade) will be imported and can be further customized. The recession bands will be displayed as vertical shades over the specified period

Note: the Fill Range feature works as a charting tool, meaning that the recessions bands won't be updated with new recessions. Instead, you can directly use the recession series in the document and display them as a "fill" in Graph Layout, which will add shaded area to the chart.

How to edit recession bands?

To edit a recession band or any other type of range, right-click in a chart and choose Fill range. You can now edit the dates. Check the tick-box named custom to change the color and the opacity of the range.

How to remove a recession from the chart?

To remove a recession period, right-click in the chart and choose Fill range. Right-click on the recession you wish to exclude and choose delete. You can select several ranges to be deleted by holding down CTRL and clicking on them. Using CTRL+A will select all periods at once.

How to create my own recession bands?

To create your own recession bands, or any other type of range, right-click in a chart and choose Fill range. To define a recession band, click on the add-button and set the start and end date. You can add several ranges to your chart in the same way.

How to save my custom created recession bands?

In the fill range window, click the Export-button, choose an account, assign the recession bands a name and click the OK button to save your work.

How to import dates from Excel to fill range?

Construct two columns in Excel, the left column indicating the start date and right column indicating the end date of the range. Simply copy the dates from excel (using CTRL+C), right click in the Fill range window and paste the dates (using CTRL+V).

Using fill range – video


Transcript