Available in Excel 2021 and Microsoft 365, XLOOKUP simplifies retrieving data from both vertical and horizontal datasets, making it a powerful tool for modern data analysis.

Choose a line chart with markers to represent monthly sales. The resulting chart shown in Figure D is a bit cluttered, but this article isn’t about formatting the chart, so try to ignore that.