Multiway Dot Plot in Excel

Description
Small multiples—an expression coined by Edward Tufte—is a series of small frames sharing the same graphical design structure, yet showing different data as the eye moves from one panel to the next.

Small multiples are efficient architecture for showing a large amount of multivariate data all in one eye span—hence enabling comparisons.

One type of small multiples is the Multiway Dot Plot invented by William Cleveland. Their stength is to study how a quantitative response variable (i.e. count of livestock) depends on two categorical variables (i.e. country and Livestock type).

Unfortunately, Excel charting library doesn't include native multiway dot plots. Users are either obliged to resort to VBA or to take the time consuming task of creating each and every chart, formatting them and arranging them in a suitable way to show patterns. If the data changes, the process has to be repeated. Not fun. Not Efficient.

So here I'm offering you an Excel template that takes a data set as an input and creates a Multiway Dot Plot with the following capabilities:

- Handles up to 2 data series (i.e. 2006, 2017).
- Easily switch panels and Levels.
- Easily adjust the number of columns.
- Sort categories by alphabetical order, mean, median, sum or as per the original data source.
- Sort categories by descending or ascending order.
- Define the horizontal scale (tick-mark spacing), its number formatting nad type (Linear, log2 or log10).
- Adjust the margin from the edges of the panels to the data to fit the category labels.
- Highlight a category on the chart from a drop-down list.
- Adjust the above settings with a user-friendly interface.
- Data entered into Excel Table—hence the chart and formulas update automatically when the datasource expands or shrinks.
- The size of the data matrix is only limited by Excel's charting and calculating capabilities.
- Fully customizable chart using standard Excel functionality enabling you to design a large variety of charts.
- Unlocked workbook/worksheets with ability to expand template to suit your needs.

What's the refund policy?

If what you see is not what you expected, just reply to the download email within 30 days, and you'll get a full refund. No questions asked.


NOTE: THE TEMPLATE RELIES HEAVILY ON EXCEL'S DYNAMIC ARRAYS CAPABILITIES, ONLY AVAILABLE TO MICROSOFT 365 SUBSCRIBERS.