ibcs-react
Components

TrendChart

A many-period time series - AC solid / FC hatched columns, PY & PL reference lines, variance panel.

Actuals as solid columns, forecast periods hatched, prior year and plan drawn as reference lines over them, and a variance panel underneath. A summary row is set off as a total - on its own terms: summaries stay out of the period scale, so a full-year total is drawn capped with a marked scale break and its value label instead of crushing the months into slivers.

When to use

Trend over time - 12-13 periods with actuals then forecast, against prior year and plan.

Example

ACPYPL13.7M14.3M15.1M13.7M14.2M14.8M14.9M13.6M14.2M14.6M14.3M14.5MJan 2023Feb 2023Mar 2023Apr 2023May 2023Jun 2023Jul 2023Aug 2023Sep 2023Oct 2023Nov 2023Dec 2023+300K+500K+900K-300K+300K+200K+800K-100K+600K+700K+800K+700K
Trend versus PY - data table
CurrentPYPLΔPYΔPY%
Jan 202313.7M13.4Mn/a+300K+2.2%
Feb 202314.3M13.8Mn/a+500K+3.6%
Mar 202315.1M14.2Mn/a+900K+6.3%
Apr 202313.7M14Mn/a-300K-2.1%
May 202314.2M13.9Mn/a+300K+2.2%
Jun 202314.8M14.6Mn/a+200K+1.4%
Jul 202314.9M14.1Mn/a+800K+5.7%
Aug 202313.6M13.7Mn/a-100K-0.7%
Sep 202314.2M13.6Mn/a+600K+4.4%
Oct 202314.6M13.9Mn/a+700K+5.0%
Nov 202314.3M13.5Mn/a+800K+5.9%
Dec 202314.5M13.8Mn/a+700K+5.1%
import { TrendChart } from "ibcs-react";

<TrendChart
  data={months} // { category, AC?, FC?, PY?, PL?, summary? }
  comparison="PY"
  referenceLines={["PY", "PL"]}
/>;

More examples

Relative variance vs plan

Compare the forecast tail against plan as a percent - the hatched FC periods carry through to the percent variance panel.

ACPYPL2.3M2.4M2.6M2.5M2.6M2.7M2.7M2.8M2.9M3M3.1M3.1M3.2MP1P2P3P4P5P6P7P8P9P10P11P12P13+2.2%+3.0%+2.8%-0.8%+2.7%+3.4%-0.7%+2.2%+2.8%+2.4%+1.7%+1.3%+1.6%
Trend versus PL - data table
CurrentPYPLΔPLΔPL%
P12.3M2.2M2.3M+50K+2.2%
P22.4M2.2M2.4M+70K+3.0%
P32.6M2.4M2.5M+70K+2.8%
P42.5M2.4M2.5M-20K-0.8%
P52.6M2.5M2.6M+70K+2.7%
P62.7M2.5M2.6M+90K+3.4%
P72.7M2.6M2.7M-20K-0.7%
P82.8M2.6M2.7M+60K+2.2%
P92.9M2.7M2.9M+80K+2.8%
P10 (FC)3M2.8M2.9M+70K+2.4%
P11 (FC)3.1M2.9M3M+50K+1.7%
P12 (FC)3.1M3M3.1M+40K+1.3%
P13 (FC)3.2M3M3.2M+50K+1.6%
<TrendChart data={months} comparison="PL" variance="pct" />

Reference lines follow IBCS notation: PY solid with dots, PL dashed. Drop one by narrowing referenceLines, e.g. referenceLines={["PY"]}.

A year plus its total

Mark the total with summary: true. It is set off by a divider, drawn in the emphasis colour - and kept OFF the period scale: the total is ~12× any month, so on a shared axis the months would collapse to slivers. Instead the summary column (and its variance bar) is capped with a marked scale break, its real value printed above; the PY line stops at December, because a total is not a point in the time series. A summary in the same range as the periods (a monthly average, say) shares the scale and gets no break.

ACPY2.1M2.2M2.2M2.3M2.3M2.4M2.5M2.5M2.6M2.6M2.7M2.8M29.2MJanFebMarAprMayJunJulAugSepOctNovDecFY+150K+160K+160K+170K+170K+180K+180K+190K+190K+200K+200K+210K+2.2M
Trend versus PY - data table
CurrentPYΔPYΔPY%
Jan2.1M2M+150K+7.7%
Feb2.2M2M+160K+8.0%
Mar2.2M2.1M+160K+7.8%
Apr2.3M2.1M+170K+8.1%
May2.3M2.2M+170K+7.8%
Jun2.4M2.2M+180K+8.1%
Jul2.5M2.3M+180K+7.9%
Aug2.5M2.3M+190K+8.2%
Sep2.6M2.4M+190K+7.9%
Oct2.6M2.4M+200K+8.2%
Nov (FC)2.7M2.5M+200K+8.0%
Dec (FC)2.8M2.6M+210K+8.2%
FY29.2M27M+2.2M+8.1%
<TrendChart
  data={[
    { category: "Jan", AC: 2.1e6, PY: 1.95e6 },
    // … through Dec (FC for the forecast tail) …
    { category: "FY", AC: 29.2e6, PY: 27.0e6, summary: true },
  ]}
  comparison="PY"
/>

Props

Prop

Type

ibcs-react is an independent open-source library and is not affiliated with, certified by, or endorsed by the IBCS Association or ISO. It follows the IBCS® notation rules (the basis of ISO 24896); IBCS® is a registered trademark of the IBCS Association.

On this page