mickeystanford_alumni
Board Regular
- Joined
- May 11, 2022
- Messages
- 129
- Office Version
- 2021
- Platform
- Windows
- MacOS
Hi All, I am trying to make a graph similar to the one below: source: McKinsey
Is there any way in Excel by having two columns with Year and Sales, to add a different trend for each year?
So that I can see the trendline of the growth from 2022 to 2023, and then the trend that I am plugging on the forecast.
I assume the graph below is done manually, but I would like to automate this so that I can easily replicate on other graphs.
*Also is there any way to include that "Today" line in excel?
If not, any other alternative?
Data
Is there any way in Excel by having two columns with Year and Sales, to add a different trend for each year?
So that I can see the trendline of the growth from 2022 to 2023, and then the trend that I am plugging on the forecast.
I assume the graph below is done manually, but I would like to automate this so that I can easily replicate on other graphs.
*Also is there any way to include that "Today" line in excel?
If not, any other alternative?
Data
| TOTAL | Sales | YoY Growth % |
| 2016 | 10 | |
| 2017 | 15 | |
| 2018 | 50 | |
| 2019 | 70 | 39% |
| 2020 | 55 | -5% |
| 2021 | 150 | 56% |
| 2022 | 380 | 206% |
| 2023 | 1,200 | 181% |
| 2024 | 3,000 | 181% |
