In our example, I have taken 18 periods of actual results (Cells B2 – S2) and 6 periods of future prediction (Cells T2 – Y2). If we get this part wrong the chart will not look how we expect it to. ![]() The layout of the data is one of the most important factors in creating a fan chart. The image below shows the finished fan chart which we will be creating in this tutorial. The term “fan chart” was created by the Bank of England who started using this method for displaying inflation in 1997. ![]() ![]() They look like a line chart, but the future values fan out to represent the range and probability of future values. They are often used to indicate inflation or exchange rate predictions, but can be used to display any data with an uncertain future value. An uncertainty chart, or a fan chart as they are known, is a way to display historical data along with a prediction of future values.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |