Management reports where the formatting carries meaning

This recreates all seventeen templates — thirteen charts and four tables — twice over, from one shared data layer: as native Excel chart objects with live formulas behind every bar, and as self-contained SVG rendered in pure Python with no dependencies at all. Both engines read the same numbers, so the two cannot disagree about what a total is.

Every word a chart shows comes from a cell. Entity, measure, unit, period, reference scenario and the message sentence are six typed inputs, and the text boxes are linked to them — change the cell, the chart re-titles itself.

The hard part turned out to be the axis. Scaling an axis to fit the data means every sheet ends up on its own scale; the fix here is the opposite move — scale the data to a fixed axis, using a hidden span cell per unit group and axis bounds divided by the same span. A test pastes figures a hundred times larger into every sheet and asserts that nothing plots outside its own axis.

One hundred and twenty-seven tie-out checks run before either renderer draws anything. A chart that does not add up does not get made.

As with the panel charts, the workbooks are reference files with placeholder data — replace the inputs with your own and everything re-derives. The two generated guides walk the same builds by hand in Excel, right down to the hex colours, gap widths and axis bounds, read back out of the workbook after it was written. Each file is a learning tool whether or not you ever run the skill.

The images on this page were produced by that SVG renderer, from placeholder figures written for this site rather than from the reference data — which is the claim above, demonstrated.

It is free to use and free to modify — MIT licensed, with no attribution required. That licence covers this project's code and workbooks; it does not and cannot grant anything in respect of the IBCS® standard or the Institute's own materials.