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 ...

Step-by-step tutorial on creating an analytical dashboard in Excel that updates automatically using a pre-designed template or from scratch.

Excel doesn’t offer a floating bar chart of its own, and finding the option isn’t intuitive. First, we’ll create a line chart, and that chart type offers floating bars.