Waffle chart
Waffle chart fills a grid of tiles in proportion to each category, so a share can be read almost by counting. Tiles approximate each share.
Show survey answers as tiles
A 10 by 10 grid holds a survey of 100 people: 70 tiles for Yes and 30 for No, so each tile happens to be one person.
Waffle chart interactive example
Loading interactive example…
The live example needs a desktop screen. The result it produces is shown here, and the explanation and settings below work on any screen.
| Answer | People |
|---|---|
| true | 70 |
| false | 30 |
- Open the Design tab and expand Shape and layout to change the number of rows and columns.
- In the Data tab, change Sort by to change the order in which the tiles fill.
- Open the dropdown at the top of Properties. It shows
Waffle chart. ChoosePie chartto compare the same shares as slices.
When to use
Use Waffle chart to show a share in a way most readers can take in at once, almost by counting tiles. Tiles only approximate most shares, so use Pie chart with labels or a table when the exact percentage matters.
Inputs
- Table
Accepts: Tables.
Accepts one connection on this port.
Settings
- Group by
Column for the parts. Auto picks a readable one.
- Group dates by
How dates in this field are grouped, such as by day, month or year.
Default:
DayOptions: Exact, Second, Minute, Hour, Day, Week, Month, Quarter, Year, Month of year, Day of week, Hour of day.
- Grouping
Groups each number on its own, or into equal-width ranges.
Default:
Individual valuesOptions: Individual values, Fixed-width ranges.
- Part value
Column calculated into the size of each part. Auto picks one with varied values.
- Operation
How the value column is calculated for each category. Columns that aren't numeric are counted.
Default:
SumOptions: Sum, Average, Median, Minimum, Maximum, 25th percentile, 75th percentile, 90th percentile, 95th percentile, Percentile, First by time, Last by time, Count values, Count distinct, Count rows, Count true, Percentage true.
- Sort by
Sorts parts by their value.
Default:
DefaultOptions: Default, Ascending, Descending, Group ascending, Group descending.
24 more settings
- Period size
Number of units in each period. Hours, minutes and seconds count fixed intervals from 1970-01-01 in the chart's time zone. Calendar periods follow local boundaries.
Default:
1- Source timezone
IANA time zone for timestamps without an offset, such as Europe/Copenhagen. Ambiguous local times need an explicit offset.
Default:
UTC- Chart timezone
IANA time zone used for grouping and display. Vista filters keep their own time zone.
Default:
UTC- Week starts
Day the week starts on.
Default:
MondayOptions: Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday.
- Fiscal year starts
Month the fiscal year starts in. Sets quarter and year boundaries.
Default:
JanuaryOptions: January, February, March, April, May, June, July, August, September, October, November, December.
- showTooltip
Shows or hides values when you hover over a mark.
Default:
true- Tooltip
Use the automatic summary, or write your own text with values.
Default:
AutomaticOptions: Automatic, Custom.
- Values
Values you can insert into the text. Each row calculates a value from a source field or, in charts, shows a chart value, and can have its own number or date format.
- Date labels
How dates are written in the chart labels.
Default:
AutoOptions: Auto, Iso, Date, Datetime, Custom.
- Tooltip dates
How dates are written in tooltips.
Default:
IsoOptions: Auto, Iso, Date, Datetime, Custom.
- Tooltip decimal places
-1 uses the measure's format.
Default:
-1- Thousands separators
Groups digits with thousands separators in tooltip numbers.
Default:
true- Title
Title shown inside the chart. Leave empty to hide it.
- Title color
Color of the title.
- Title size
Size of the title, in pixels.
Default:
24- Title alignment (plot)
Alignment of the title.
Default:
LeftOptions: Left, Center, Right.
- Grid
Standard 10×10 grid or custom dimensions.
Default:
Standard 10×10Options: Standard 10×10, Custom.
- Fill sweep
Fills cells row by row or column by column.
Default:
RowsOptions: Rows, Columns.
- Reverse fill
Fills from the opposite edge. Tiles show each category's share roughly, and Reverse changes the direction within each row or column.
Default:
false- Tile gap
Space between cells, in pixels.
Default:
1- Background
Card background color. Auto follows the theme.
- Plot padding
Space between the card edge and the chart, in pixels.
Default:
0- Corner radius (px)
Corner radius in whole logical pixels.
Default:
0- Border width (px)
Border width in whole logical pixels.
Default:
0
Waffle chart FAQs
- Why doesn't the waffle chart match the exact percentages?
- Tiles come in whole numbers, so each group's tile count approximates its share. A 10 by 10 grid makes one tile about 1%.
Chart your data. Build it in Vista.
Vista opens in your browser, with no account.