Index builder analysis should be used in this case.
There are several calculation methods to choose from - for more details please refer to the document available at: https://help.macrobond.com/analyses/operations/indexbuilder/.
You may also want to scale the series to start at some specific value, like 100.
The Transofmations - You can add the forecast either to the original time series or after applying some calculations to it.
He also discusses the strengths and limitations of Excel's available chart options.To highlight one component of a sales trend, you can use a stacked column chart.NOTE This book recommends not using pyramid charts or cone charts because they distort your message.It is likely that the data used to create the graph is coming from an Excel worksheet, so why not link the graph on the slide directly to the Excel data. I will describe each method, and then show a table that summarizes the differences.I’ll end with some recommendations of when each method should be used.