Hi all,
I have difficulties to represent in the same line chart current and future values. I have attached a file with the initial table.
As you can see I have values for nine different months, which are the current ones. Then, I have forecasted those values in two different ways. Lag1 is forecasted one month later and Lag2 is forecasted two month later.
I have tried to plot that in a line chart with three lines (Actual, Lag1 and Lag2), but I have not been successful.
I guess I need to change the structure of the data?
Any help will be really appreciated.
Thanks in advance.
Bookmarks