Hi community
So I am trying to build a chart where I do have Actual Production by site from 2019-2022 and severall Forecasts for 2023 Full Year
- One Forecast done in 2022year end) - called 2023B
- One Forecast done in 2023Mar - Called 2023MYR
- One Forecast done in 2023Jun - Called 2023LE
I wanted to create a chart that emcompass all 3 2023 forecasts into it and how do they compare vs 2022 - but based on the dataset I cannot "convert" all of the 3 scenarios as 2023 since they will overlap
Simple example as screenshot below - I want to monitor how does 2023 estimates compare vs 2022
Edit:
The data structure is a google sheet for now but it is formatted in that way