Mermaid source for a chart of the table's data: the first column's
texts label the points, and every other column holding a number is a
series, named by its header. A pie takes the first such column. A bar
chart draws the series after the first as lines, as Mermaid would lay
their bars over the first's and hide them. Rows with no number, and a
total row (Word's option, or one whose formulas add up the rows above),
are left out. Names too long to sit side by side along the bottom turn a
bar chart on its side, where each has a line of its own, and are
shortened along the bottom of a line chart. Null when the table has no
numbers to draw.
Mermaid source for a chart of the table's data: the first column's texts label the points, and every other column holding a number is a series, named by its header. A pie takes the first such column. A bar chart draws the series after the first as lines, as Mermaid would lay their bars over the first's and hide them. Rows with no number, and a total row (Word's option, or one whose formulas add up the rows above), are left out. Names too long to sit side by side along the bottom turn a bar chart on its side, where each has a line of its own, and are shortened along the bottom of a line chart. Null when the table has no numbers to draw.