How to create a Tableau lookalike cross-tab chart with Microsoft Excel
Matt Grams, author of Bullet Graphs for Excel: A Simple Way? is kind enough to contribute another guest post here on Clearly and Simply, this time discussing how to create cross-tab charts with Microsoft Excel.
Trellis charts. Panel charts. Visual cross-tabs. Cross-tabs. Variations of small multiples. Whatever you want to call these charts, one thing seems clear to me: Tableau offers aesthetically restrained yet beautiful implementations.
So how about constructing a visual cross-tab with similar aesthetics in Excel? Today’s post describes the how-to, including an Excel workbook with detailed explanations for free download.