Hi All, (thanks in advance for any help)
I am looking to forecast some data for the next 6 months based on existing data but I can't seem to get the forecast button to include more then one data line. I would like to see the current and forecasted data on one graph. (I do not need to see the upper / lower confidence bounds.)
I have the data for an active project in a table I have columns A:F - A. Month, B Cost 1, C Cost 2, D Cost 3 , E Sales , F Sales including a variation. We have the real data monthly from the start of the project (2021) to date but I want to forecast all costs and sales (B:F) as individual lines/bars on a graph for the next 6 months.
Please see image of what the graph with the current actual data looks like and what I have managed to achieve with the forecast button so far. I would like the combination chart to just have the forecast going on 6 months in a different colour to the real data.
Really hope this makes sense! Thank you in advance.
I am looking to forecast some data for the next 6 months based on existing data but I can't seem to get the forecast button to include more then one data line. I would like to see the current and forecasted data on one graph. (I do not need to see the upper / lower confidence bounds.)
I have the data for an active project in a table I have columns A:F - A. Month, B Cost 1, C Cost 2, D Cost 3 , E Sales , F Sales including a variation. We have the real data monthly from the start of the project (2021) to date but I want to forecast all costs and sales (B:F) as individual lines/bars on a graph for the next 6 months.
Please see image of what the graph with the current actual data looks like and what I have managed to achieve with the forecast button so far. I would like the combination chart to just have the forecast going on 6 months in a different colour to the real data.
Really hope this makes sense! Thank you in advance.