On the attached spreadsheet, the tab 2021-2027 is the main data tab. The two summer charts and BESS are fine, but when I did the LT Scenario chart I somehow get data before 1/1/2021 but I don't have any data for that time frame and I don't know how to fix it. I have the same problem with the NQC tab. For sheet 5, when I built it, I don't know why I'm not automatically getting quarters and years for the months like all the other charts.
22 freelancers are bidding on average $79 for this job
i can do this. i have good command over Ms excel especially pivot table, charts, advance formulas, formatting, macro etc. Please inbox me and share detail. Thanks Abdul Haleem