Variance grid

An interactive table whose rows are the data's own structure (accounts, units, regions - one level or nested), with the ACTUAL, the BUDGET, PLAN or TARGET the data names, and the absolute and percentage variance drawn as bars and pins in aligned columns; subtotals per group, a footer total, sort, expand and collapse, a pager and a column picker.

An illustration of a Variance grid

An illustration of the type, not a chart made from data.

The data it needs

One or more category columns plus two measures where one names itself the reference - Revenue and Revenue Budget, Cost and Cost Plan, Attained and Quota; a P&L, a budget review, plan attainment by unit; many rows or nested groups that a chart would crowd.

Smallest size it draws at: 320 by 200 pixels.

Try it

Try it with Department Budget vs Actual

Start with your own data in Power BI or Excel, or build it into your own app through the MCP server. Each one lists the types that fit your data before it builds anything.

This application may no longer respond until reloaded. Reload 🗙