Create a report using charts: Select Insert > Recommended Charts, then choose the one you want to add to the report sheet.
I was drowning in XLOOKUP formulas, but Power Pivot gave me a cleaner way to build reports.