- add recession bands to chart?
- edit recession bands?
- remove a recession from the chart?
- create my own recession bands?
- save my custom created recession bands?
- import dates from Excel to fill range?
- Using fill range – video
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.
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.
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.
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.
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.
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).