Each plate reproduces one of the chart forms from Visualize This (2nd ed.) — hot dogs, postage, Walmarts and all — then translates it into the question it answers on store / date / category / net-sales data and names the Power BI visual that does the job. Hover any mark for its value; every chart has a table twin.
| Year | Winner | HDB | Record |
|---|---|---|---|
| 1980 | Paul Siederman & Joe Baldini | 9.75 | |
| 1981 | Thomas DeBerry | 11 | yes |
| 1982 | Steven Abrams | 11.1 | yes |
| 1983 | Emil Gomez | 10.5 | |
| 1984 | Birgit Felden | 9.5 | |
| 1985 | Oscar Rodriguez | 11.75 | yes |
| 1986 | Mark Heller | 15.5 | yes |
| 1987 | Don Wolfman | 13.5 | |
| 1988 | Jay Green | 10 | |
| 1989 | Jay Green | 15.5 | |
| 1990 | Mike DeVito & Jay Green | 15 | |
| 1991 | Frank Dellarosa | 21 | yes |
| 1992 | Frank Dellarosa | 19 | |
| 1993 | Mike DeVito | 17 | |
| 1994 | Mike DeVito | 20 | |
| 1995 | Edward Krachie | 19.5 | |
| 1996 | Edward Krachie | 22 | yes |
| 1997 | Hirofumi Nakajima | 24.5 | yes |
| 1998 | Hirofumi Nakajima | 19 | |
| 1999 | Steve Keiner | 21.5 | |
| 2000 | Kazutoyo "The Rabbit" Arai | 25.13 | yes |
| 2001 | Takeru Kobayashi | 50 | yes |
| 2002 | Takeru Kobayashi | 50.5 | yes |
| 2003 | Takeru Kobayashi | 44.5 | |
| 2004 | Takeru Kobayashi | 53.5 | yes |
| 2005 | Takeru Kobayashi | 49 | |
| 2006 | Takeru "Tsunami" Kobayashi | 53.75 | yes |
| 2007 | Joey Chestnut | 66 | yes |
| 2008 | Joey Chestnut | 59 | |
| 2009 | Joey Chestnut | 68 | yes |
| 2010 | Joey Chestnut | 54 | |
| 2011 | Joey Chestnut | 62 | |
| 2012 | Joey Chestnut | 68 | |
| 2013 | Joey Chestnut | 69 | yes |
| 2014 | Joey Chestnut | 61 | |
| 2015 | Matt Stonie | 62 | |
| 2016 | Joey Chestnut | 70 | yes |
| 2017 | Joey Chestnut | 72 | yes |
| 2018 | Joey Chestnut | 74 | yes |
| 2019 | Joey Chestnut | 71 | |
| 2020 | Joey Chestnut | 75 | yes |
| 2021 | Joey Chestnut | 76 | yes |
| 2022 | Joey Chestnut | 63 | |
| 2023 | Joey Chestnut | 62 |
Start with the default barplot(), then take away: borders off, one hue for the bars that carry the story, gray for the rest, a wrapped annotation for the 2001 jump.
Weekly net sales by fiscal week with record weeks (or promo weeks) highlighted. The story is "which weeks broke the pattern", not "here are 52 bars".
Clustered column + conditional formatting on Column color driven by a flag measure, e.g. Is Record Week = IF([Net Sales] > [Prior Max Net Sales], 1, 0). Annotate with a text box, not a data label on every bar.
| Year | Rate |
|---|---|
| 1863 | $0.06 |
| 1883 | $0.04 |
| 1885 | $0.02 |
| 1917 | $0.03 |
| 1919 | $0.02 |
| 1932 | $0.03 |
| 1958 | $0.04 |
| 1963 | $0.05 |
| 1968 | $0.06 |
| 1971 | $0.08 |
| 1974 | $0.10 |
| 1975 | $0.13 |
| 1978 | $0.15 |
| 1981 | $0.20 |
| 1985 | $0.22 |
| 1988 | $0.25 |
| 1991 | $0.29 |
| 1995 | $0.32 |
| 1999 | $0.33 |
| 2001 | $0.34 |
| 2002 | $0.37 |
| 2006 | $0.39 |
| 2007 | $0.41 |
| 2008 | $0.42 |
| 2009 | $0.44 |
| 2012 | $0.45 |
| 2013 | $0.46 |
| 2014 | $0.49 |
| 2016 | $0.47 |
| 2017 | $0.49 |
| 2018 | $0.50 |
| 2019 | $0.55 |
| 2021 | $0.58 |
| 2022 | $0.60 |
| 2023 | $0.66 |
plot(type="s"): a value that holds until the next change is a step, and interpolating between changes invents movement that never happened.
Shelf price, fuel rack price, contract cost, tax rate — anything effective-dated. Draw the step from the effective date; your line chart of monthly average price is smoothing away the actual events.
Line chart → Format → Lines → Step on (2023+ builds). Feed it the effective-dated table, not a monthly average. For older builds, use Deneb with "interpolate": "step-after".
| Month | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Jan | 57% | 63% | 56% | 51% | 47% | 15% | 12% | 10% | 10% | 5% | 7% | 9% | 10% | 10% | 11% | 20% | 19% | 21% | 18% | 29% | 30% | 33% | 40% | 44% |
| Feb | 58% | 67% | 60% | 63% | 37% | 31% | 25% | 15% | 10% | 13% | 5% | 12% | 14% | 6% | 13% | 17% | 19% | 25% | 20% | 22% | 27% | 40% | 31% | 48% |
| Mar | 48% | 62% | 67% | 63% | 46% | 22% | 19% | 15% | 4% | 13% | 8% | 8% | 11% | 13% | 20% | 14% | 24% | 33% | 30% | 27% | 30% | 33% | 44% | 47% |
| Apr | 49% | 52% | 65% | 52% | 40% | 24% | 13% | 17% | 12% | 5% | 10% | 11% | 12% | 15% | 13% | 14% | 14% | 30% | 35% | 36% | 34% | 35% | 47% | 51% |
| May | 49% | 63% | 62% | 63% | 46% | 30% | 24% | 16% | 7% | 13% | 10% | 16% | 10% | 14% | 15% | 14% | 23% | 30% | 37% | 44% | 37% | 33% | 36% | 48% |
| Jun | 55% | 58% | 61% | 45% | 42% | 18% | 22% | 19% | 6% | 9% | 6% | 9% | 13% | 8% | 11% | 14% | 19% | 21% | 34% | 39% | 40% | 38% | 39% | 45% |
| Jul | 47% | 54% | 50% | 62% | 26% | 24% | 24% | 15% | 6% | 6% | 9% | 10% | 9% | 13% | 12% | 14% | 19% | 25% | 34% | 37% | 46% | 38% | 41% | 32% |
| Aug | 49% | 64% | 68% | 63% | 43% | 29% | 20% | 15% | 7% | 9% | 8% | 13% | 7% | 14% | 13% | 20% | 20% | 27% | 37% | 40% | 37% | 38% | 41% | 54% |
| Sep | 57% | 54% | 66% | 57% | 31% | 14% | 11% | 10% | 13% | 6% | 8% | 11% | 10% | 17% | 9% | 15% | 18% | 26% | 29% | 27% | 29% | 28% | 38% | 43% |
| Oct | 54% | 46% | 59% | 51% | 49% | 24% | 11% | 10% | 5% | 8% | 8% | 10% | 8% | 16% | 15% | 19% | 16% | 23% | 22% | 21% | 23% | 35% | 33% | 45% |
| Nov | 49% | 60% | 59% | 49% | 47% | 27% | 14% | 15% | 15% | 11% | 14% | 14% | 12% | 13% | 11% | 15% | 21% | 17% | 19% | 27% | 22% | 32% | 31% | 44% |
| Dec | 47% | 56% | 65% | 54% | 35% | 29% | 9% | 17% | 13% | 6% | 8% | 7% | 6% | 7% | 12% | 12% | 18% | 14% | 18% | 25% | 22% | 35% | 39% | 43% |
A time series with two periodic components wants a grid, not a 288-point line. One hue, six ordered steps, white gaps between cells, and the axes labelled in human units (12am, noon, 6pm).
Transactions or fuel gallons by day-of-week × hour per store — the labor-scheduling chart. Or week-of-year × year for seasonality drift.
Matrix visual with rows = hour, columns = weekday, values = measure, and Cell elements → Background color on a single-hue gradient. Turn off values if you want a pure heatmap. Or the Deneb rect mark with a scale: {"scheme":"blues"}.
| Year | single | nuclear-married-nochildren | nuclear-married-children | composite | extended | nuclear-mother | nuclear-father |
|---|---|---|---|---|---|---|---|
| 1976 | 20.8% | 23.1% | 37.2% | 3.6% | 7.4% | 7.0% | 0.8% |
| 1977 | 21.2% | 22.9% | 36.6% | 4.0% | 7.3% | 7.1% | 0.8% |
| 1978 | 22.2% | 22.3% | 35.3% | 4.3% | 7.6% | 7.4% | 0.9% |
| 1979 | 22.5% | 22.4% | 34.9% | 4.8% | 7.3% | 7.4% | 0.9% |
| 1980 | 22.7% | 22.6% | 34.2% | 5.0% | 7.0% | 7.6% | 0.9% |
| 1981 | 23.2% | 22.1% | 33.7% | 5.2% | 7.1% | 7.7% | 1.0% |
| 1982 | 23.4% | 22.4% | 32.7% | 5.3% | 7.3% | 8.0% | 1.0% |
| 1983 | 23.2% | 22.1% | 32.8% | 5.5% | 7.5% | 7.9% | 1.1% |
| 1984 | 23.6% | 21.8% | 32.6% | 5.7% | 7.2% | 8.1% | 1.0% |
| 1985 | 23.9% | 21.9% | 32.0% | 5.9% | 7.1% | 8.1% | 1.1% |
| 1986 | 24.1% | 21.6% | 31.9% | 6.0% | 7.2% | 8.1% | 1.2% |
| 1987 | 23.8% | 21.9% | 31.5% | 6.2% | 7.3% | 8.0% | 1.2% |
| 1988 | 24.3% | 21.9% | 31.2% | 6.3% | 7.2% | 8.0% | 1.2% |
| 1989 | 24.6% | 21.8% | 30.7% | 6.5% | 7.1% | 8.1% | 1.1% |
| 1990 | 24.8% | 21.9% | 30.2% | 6.8% | 7.1% | 8.0% | 1.2% |
| 1991 | 25.2% | 21.6% | 29.7% | 6.9% | 7.3% | 8.2% | 1.1% |
| 1992 | 25.2% | 21.6% | 29.4% | 7.2% | 7.2% | 8.2% | 1.3% |
| 1993 | 24.6% | 21.8% | 29.6% | 7.2% | 7.2% | 8.3% | 1.2% |
| 1994 | 24.4% | 21.4% | 29.2% | 7.8% | 7.5% | 8.6% | 1.2% |
| 1995 | 25.0% | 21.6% | 28.8% | 7.7% | 7.5% | 8.2% | 1.3% |
| 1996 | 25.0% | 21.7% | 28.2% | 8.0% | 7.5% | 8.3% | 1.4% |
| 1997 | 25.2% | 21.0% | 28.0% | 8.4% | 7.7% | 8.4% | 1.4% |
| 1998 | 25.7% | 21.3% | 27.9% | 8.3% | 7.5% | 8.0% | 1.4% |
| 1999 | 25.6% | 21.7% | 27.2% | 8.4% | 7.5% | 8.1% | 1.5% |
| 2000 | 25.6% | 21.9% | 26.9% | 9.0% | 7.6% | 7.7% | 1.4% |
| 2001 | 26.1% | 21.9% | 26.5% | 8.9% | 7.7% | 7.5% | 1.4% |
| 2002 | 26.4% | 21.9% | 26.1% | 8.7% | 7.7% | 7.7% | 1.5% |
| 2003 | 26.5% | 21.8% | 25.9% | 8.7% | 7.9% | 7.7% | 1.5% |
| 2004 | 26.4% | 22.1% | 25.6% | 8.8% | 8.1% | 7.5% | 1.5% |
| 2005 | 26.6% | 21.6% | 25.6% | 8.8% | 8.3% | 7.6% | 1.4% |
| 2006 | 26.7% | 21.5% | 25.3% | 9.0% | 8.3% | 7.7% | 1.5% |
| 2007 | 26.9% | 21.7% | 25.2% | 8.9% | 8.2% | 7.7% | 1.4% |
| 2008 | 27.6% | 21.6% | 24.5% | 9.1% | 8.2% | 7.5% | 1.5% |
| 2009 | 27.0% | 22.1% | 24.3% | 9.1% | 8.7% | 7.4% | 1.4% |
| 2010 | 26.7% | 21.6% | 23.8% | 10.1% | 9.0% | 7.4% | 1.5% |
| 2011 | 27.6% | 21.6% | 23.1% | 10.0% | 8.8% | 7.5% | 1.5% |
| 2012 | 27.4% | 21.8% | 22.8% | 10.1% | 8.6% | 7.7% | 1.6% |
| 2013 | 27.4% | 21.5% | 22.8% | 10.5% | 8.8% | 7.4% | 1.6% |
| 2014 | 27.8% | 21.6% | 22.8% | 9.9% | 8.9% | 7.5% | 1.6% |
| 2015 | 28.1% | 21.5% | 22.8% | 10.2% | 8.9% | 7.0% | 1.5% |
| 2016 | 28.3% | 21.7% | 22.4% | 10.3% | 8.6% | 7.2% | 1.6% |
| 2017 | 28.1% | 22.1% | 22.0% | 10.1% | 9.0% | 7.0% | 1.6% |
| 2018 | 28.1% | 22.1% | 21.9% | 10.7% | 8.9% | 6.8% | 1.6% |
| 2019 | 28.4% | 22.5% | 21.7% | 10.4% | 9.0% | 6.6% | 1.5% |
| 2020 | 28.2% | 22.6% | 22.0% | 10.2% | 9.1% | 6.5% | 1.5% |
| 2021 | 28.5% | 22.2% | 21.2% | 10.8% | 9.0% | 6.6% | 1.6% |
Pie charts are for ≤ 6 slices at a glance; sorted bars beat them for reading values; and when the proportions have a time axis, stack them — then reshape the long table to wide (his prepare-household-types.R) before plotting.
Category mix of net sales by fiscal period (tobacco / beverages / fuel / lottery…). The stacked-100% view answers "is the mix shifting"; the plain stacked view answers "is the total growing". Ask which question first.
100% stacked area (or stacked column for ≤ 24 periods). Sort legend by last-period share, fold anything under 3% into Other with a calculated column, and cap at 7 series — the palette stops being distinguishable past that.
| Activity | Men | Women | Gap (pts) |
|---|---|---|---|
| Physical care | 46.8% | 71.2% | 24.4 |
| Picking up/dropping off | 27.2% | 48.0% | 20.8 |
| Playing, not sports | 21.4% | 21.6% | 0.2 |
| Homework | 10.3% | 20.7% | 10.4 |
| Reading to/with | 9.1% | 14.5% | 5.4 |
| Talking with/listening | 5.7% | 13.8% | 8.1 |
| Looking after (as a pri. activity) | 5.1% | 12.1% | 7.0 |
| Waiting for/with | 4.9% | 11.7% | 6.8 |
| Organization and planning | 1.6% | 6.4% | 4.8 |
| Attending events | 2.6% | 4.8% | 2.2 |
| Obtaining medical care | 0.6% | 3.0% | 2.4 |
| Providing medical care | 0.8% | 3.0% | 2.2 |
| Meetings and school conferences | 0.5% | 1.7% | 1.2 |
| Waiting for children's health | 0.3% | 1.4% | 1.1 |
| Playing sports | 1.0% | 1.3% | 0.3 |
The D3 barbell: a band scale for rows, a line for the gap, two circles for the ends. Sort by one end so the gaps read as a shape. Label MEN / WOMEN once, on the top row, never in a legend the eye has to travel to.
This year vs. last year per store, or plan vs. actual per category. The connecting line is the variance — far more legible than clustered bars for 15+ rows.
No core dumbbell. Options: (a) Deneb — rule mark from [Prior] to [Current] plus two point layers; (b) the "MacGyver" scatter with Error bars; (c) a table with a variance column, which is often honest enough.
| Year | Beef | Chicken | Beef − chicken |
|---|---|---|---|
| 1909 | 51.1 | 10.4 | 40.7 |
| 1910 | 48.5 | 11.0 | 37.5 |
| 1911 | 47.2 | 11.1 | 36.1 |
| 1912 | 44.5 | 10.6 | 33.9 |
| 1913 | 43.6 | 10.3 | 33.3 |
| 1914 | 42.7 | 10.3 | 32.4 |
| 1915 | 38.8 | 10.2 | 28.6 |
| 1916 | 40.6 | 9.6 | 31.0 |
| 1917 | 44.6 | 9.4 | 35.2 |
| 1918 | 47.2 | 9.4 | 37.8 |
| 1919 | 42.4 | 10.1 | 32.3 |
| 1920 | 40.7 | 9.7 | 31.0 |
| 1921 | 38.2 | 9.5 | 28.7 |
| 1922 | 40.7 | 10.1 | 30.6 |
| 1923 | 41.1 | 10.4 | 30.7 |
| 1924 | 41.0 | 9.7 | 31.3 |
| 1925 | 41.0 | 10.1 | 30.9 |
| 1926 | 41.5 | 10.1 | 31.4 |
| 1927 | 37.5 | 10.8 | 26.7 |
| 1928 | 33.6 | 10.4 | 23.2 |
| 1929 | 34.2 | 10.1 | 24.1 |
| 1930 | 33.7 | 11.1 | 22.6 |
| 1931 | 33.4 | 10.0 | 23.4 |
| 1932 | 32.1 | 10.2 | 21.9 |
| 1933 | 35.5 | 10.4 | 25.1 |
| 1934 | 43.9 | 9.6 | 34.3 |
| 1935 | 36.6 | 9.3 | 27.3 |
| 1936 | 41.6 | 9.6 | 32.0 |
| 1937 | 38.0 | 9.7 | 28.3 |
| 1938 | 37.4 | 9.0 | 28.4 |
| 1939 | 37.6 | 10.0 | 27.6 |
| 1940 | 37.8 | 10.0 | 27.8 |
| 1941 | 42.6 | 11.0 | 31.6 |
| 1942 | 45.9 | 12.7 | 33.2 |
| 1943 | 43.0 | 16.0 | 27.0 |
| 1944 | 46.6 | 15.3 | 31.3 |
| 1945 | 48.0 | 15.1 | 32.9 |
| 1946 | 44.2 | 13.9 | 30.3 |
| 1947 | 49.2 | 12.5 | 36.7 |
| 1948 | 44.2 | 12.6 | 31.6 |
| 1949 | 44.7 | 13.5 | 31.2 |
| 1950 | 44.6 | 14.3 | 30.3 |
| 1951 | 41.2 | 15.0 | 26.2 |
| 1952 | 43.9 | 15.2 | 28.7 |
| 1953 | 54.5 | 15.1 | 39.4 |
| 1954 | 56.0 | 15.6 | 40.4 |
| 1955 | 57.2 | 14.7 | 42.5 |
| 1956 | 59.5 | 16.8 | 42.7 |
| 1957 | 58.7 | 17.5 | 41.2 |
| 1958 | 55.9 | 19.2 | 36.7 |
| 1959 | 56.6 | 19.7 | 36.9 |
| 1960 | 59.1 | 19.1 | 40.0 |
| 1961 | 61.0 | 20.5 | 40.5 |
| 1962 | 61.7 | 20.5 | 41.2 |
| 1963 | 65.4 | 21.0 | 44.4 |
| 1964 | 70.6 | 21.3 | 49.3 |
| 1965 | 70.4 | 22.8 | 47.6 |
| 1966 | 73.7 | 24.5 | 49.2 |
| 1967 | 75.3 | 25.1 | 50.2 |
| 1968 | 77.3 | 25.2 | 52.1 |
| 1969 | 77.8 | 26.3 | 51.5 |
| 1970 | 79.8 | 27.4 | 52.4 |
| 1971 | 79.2 | 27.4 | 51.8 |
| 1972 | 80.5 | 28.3 | 52.2 |
| 1973 | 76.0 | 27.1 | 48.9 |
| 1974 | 80.7 | 27.0 | 53.7 |
| 1975 | 83.2 | 26.4 | 56.8 |
| 1976 | 88.8 | 28.5 | 60.3 |
| 1977 | 86.3 | 29.0 | 57.3 |
| 1978 | 82.2 | 30.4 | 51.8 |
| 1979 | 73.5 | 32.8 | 40.7 |
| 1980 | 72.1 | 32.7 | 39.4 |
| 1981 | 72.8 | 33.7 | 39.1 |
| 1982 | 72.5 | 33.9 | 38.6 |
| 1983 | 74.1 | 34.0 | 40.1 |
| 1984 | 73.8 | 35.3 | 38.5 |
| 1985 | 74.6 | 36.4 | 38.2 |
| 1986 | 74.4 | 37.2 | 37.2 |
| 1987 | 69.5 | 39.4 | 30.1 |
| 1988 | 68.6 | 39.6 | 29.0 |
| 1989 | 65.1 | 40.5 | 24.6 |
| 1990 | 63.9 | 42.5 | 21.4 |
| 1991 | 62.9 | 44.2 | 18.7 |
| 1992 | 62.4 | 46.5 | 15.9 |
| 1993 | 61.0 | 48.1 | 12.9 |
| 1994 | 62.9 | 48.7 | 14.2 |
| 1995 | 63.5 | 48.2 | 15.3 |
| 1996 | 64.0 | 48.6 | 15.4 |
| 1997 | 62.6 | 50.0 | 12.6 |
| 1998 | 63.6 | 50.4 | 13.2 |
| 1999 | 64.3 | 53.6 | 10.7 |
| 2000 | 64.5 | 54.2 | 10.3 |
| 2001 | 63.1 | 54.0 | 9.1 |
| 2002 | 64.5 | 56.8 | 7.7 |
| 2003 | 61.9 | 57.6 | 4.3 |
| 2004 | 63.0 | 59.3 | 3.7 |
| 2005 | 62.5 | 60.5 | 2.0 |
| 2006 | 62.8 | 60.9 | 1.9 |
| 2007 | 62.1 | 59.9 | 2.2 |
| 2008 | 59.4 | 58.7 | 0.7 |
| 2009 | 58.1 | 56.1 | 2.0 |
| 2010 | 56.7 | 58.0 | -1.3 |
| 2011 | 54.4 | 58.4 | -4.0 |
| 2012 | 54.5 | 56.7 | -2.2 |
| 2013 | 53.6 | 57.7 | -4.1 |
| 2014 | 51.5 | 58.8 | -7.3 |
| 2015 | 51.4 | 62.6 | -11.2 |
| 2016 | 52.9 | 63.2 | -10.3 |
| 2017 | 54.3 | 64.1 | -9.8 |
Two lines plus a clipped area fill between them, colored by which is on top. The fill is the message; the crossing year is the annotation.
Net sales vs. budget by week (fill = variance, colored above/below), or inside vs. fuel gross margin dollars — the classic c-store "who's carrying the store" chart.
Core area charts can't clip by sign. Deneb: two area layers with a filter transform per sign, or one area mark with y/y2 and a condition on fill. Keep the arithmetic in DAX ([Variance to Budget]), not in the Vega spec.
| State | Population | Asian share |
|---|---|---|
| California | 39,538,223 | 15.4% |
| New Jersey | 9,288,994 | 10.2% |
| New York | 20,201,249 | 9.6% |
| Washington | 7,705,281 | 9.5% |
| Nevada | 3,104,614 | 8.8% |
| Massachusetts | 7,029,917 | 7.2% |
| Virginia | 8,631,393 | 7.1% |
| Maryland | 6,177,224 | 6.8% |
| Illinois | 12,812,508 | 5.9% |
| Texas | 29,145,505 | 5.4% |
| Minnesota | 5,706,494 | 5.2% |
| District of Columbia | 689,545 | 4.9% |
| Connecticut | 3,605,944 | 4.8% |
| Oregon | 4,237,256 | 4.6% |
| Georgia | 10,711,908 | 4.5% |
| Delaware | 989,948 | 4.3% |
| Pennsylvania | 13,002,700 | 3.9% |
| Arizona | 7,151,502 | 3.6% |
| Rhode Island | 1,097,379 | 3.5% |
| Colorado | 5,773,714 | 3.5% |
| Michigan | 10,077,331 | 3.3% |
| North Carolina | 10,439,388 | 3.3% |
| Florida | 21,538,187 | 3.0% |
| Wisconsin | 5,893,718 | 3.0% |
| Kansas | 2,937,880 | 2.9% |
| Nebraska | 1,961,504 | 2.7% |
| New Hampshire | 1,377,529 | 2.6% |
| Ohio | 11,799,448 | 2.5% |
| Indiana | 6,785,528 | 2.5% |
| Utah | 3,271,616 | 2.5% |
| Iowa | 3,190,369 | 2.4% |
| Oklahoma | 3,959,353 | 2.3% |
| Missouri | 6,154,913 | 2.2% |
| Tennessee | 6,910,840 | 2.0% |
| Louisiana | 4,657,757 | 1.9% |
| Vermont | 643,077 | 1.8% |
| New Mexico | 2,117,522 | 1.8% |
| South Carolina | 5,118,425 | 1.8% |
| Arkansas | 3,011,524 | 1.7% |
| North Dakota | 779,094 | 1.7% |
| Kentucky | 4,505,836 | 1.6% |
| Alabama | 5,024,279 | 1.5% |
| South Dakota | 886,667 | 1.5% |
| Idaho | 1,839,106 | 1.5% |
| Maine | 1,362,359 | 1.2% |
| Mississippi | 2,961,279 | 1.1% |
| Wyoming | 576,851 | 0.9% |
| West Virginia | 1,793,716 | 0.8% |
| Montana | 1,084,225 | 0.8% |
Load boundaries with sf, project to Albers equal-area (never Mercator for area comparisons), join the census table on GEOID, bin the rate (not the count) into five classes, and shade with one hue.
Comp-store growth or gallons-per-store by county/region; store locations as points; new openings as small multiples by year. Shade rates and per-store metrics, never raw totals — big regions win by size alone.
Shape map (filled, needs a TopoJSON for custom regions) or Azure Maps with Filled map layer; bubble layer for store points with size = √metric via a SQRT([Gallons]) measure. Enable map visuals in tenant settings first — it's off by default.
| Height | G | G/F | F | F/C | C |
|---|---|---|---|---|---|
| 65" | 0 | 0 | 0 | 0 | 0 |
| 66" | 0 | 0 | 0 | 0 | 0 |
| 67" | 0 | 0 | 0 | 0 | 0 |
| 68" | 0 | 0 | 0 | 0 | 0 |
| 69" | 2 | 0 | 0 | 0 | 0 |
| 70" | 0 | 0 | 0 | 0 | 0 |
| 71" | 4 | 0 | 0 | 0 | 0 |
| 72" | 13 | 0 | 0 | 0 | 0 |
| 73" | 17 | 0 | 0 | 0 | 0 |
| 74" | 22 | 0 | 0 | 0 | 0 |
| 75" | 36 | 0 | 0 | 0 | 0 |
| 76" | 35 | 1 | 0 | 0 | 0 |
| 77" | 24 | 12 | 0 | 0 | 0 |
| 78" | 19 | 19 | 6 | 1 | 0 |
| 79" | 3 | 24 | 19 | 1 | 0 |
| 80" | 0 | 10 | 39 | 3 | 0 |
| 81" | 0 | 4 | 51 | 15 | 1 |
| 82" | 0 | 0 | 19 | 24 | 8 |
| 83" | 0 | 0 | 7 | 22 | 24 |
| 84" | 0 | 0 | 1 | 8 | 24 |
| 85" | 0 | 0 | 0 | 0 | 8 |
| 86" | 0 | 0 | 0 | 0 | 1 |
| 87" | 0 | 0 | 0 | 0 | 1 |
| 88" | 0 | 0 | 0 | 0 | 0 |
| 89" | 0 | 0 | 0 | 0 | 0 |
| 90" | 0 | 0 | 0 | 0 | 0 |
Stack the dots, then bin them; bin width is a real choice that changes the picture (try 1, 3, 6). Compare groups with small multiples on a shared x-axis and a mean line, ordered by the thing you expect to shift.
Basket size distribution by store format; days-of-supply distribution by SKU; margin % distribution by category. A mean in a KPI card hides the two-humped distribution every time.
No core histogram. Bin the column (right-click field → New group → Bin) and use a column chart, or Deneb bin transform with a bin-width parameter. Box plots: the AppSource "Box and Whisker" visual or Deneb boxplot mark.
Built from the companion code and data for Visualize This, 2nd ed. (Nathan Yau, Wiley 2024), chapters 4–8. Chart forms follow Yau's; colors are a CVD-validated palette in fixed slot order rather than the book's per-chart hex codes; every chart carries a hover layer and a table twin. Retail translations assume a star schema at store × date × category grain.