The YOY chart shown in Figure A displays a line for each year in the data set. If you want to compare the first quarter of 2022 to 2021 and 2022, you’d want to see three lines—one for each ...

If you want to compare data in a side-by-side fashion, then we suggest using the Scenario Manager feature in Excel. You can also use it to swap multiple sets of data within a single worksheet.