I'm not arguing that PivotTables are now useless, because they still solve certain problems very well. However, after seeing how fluid, responsive, and adaptable GROUPBY and PIVOTBY can be, I've found ...
In the Format Data Point pane, click the "Fill and Line" paint pot, and in the Fill section, check "Solid fill," and change ...