Question

ChartPlugin uses the same syntax to name the cells in a table as SpreadSheetPlugin. In SpreadSheetPlugin one can determine the number of rows using $ROW(-1), but this only works in the last row as $ROW() refers to the current row.

Now, as %CHART% is not part of a table but used outside the table, is there a way to determine the number of rows and columns in the source table, so that one can write dynamic ranges and does not have to edit the %CHART statement every time a row or column is added to the table?

2. A 'stacking' area datatype would be nice too, in which the shown values for two columns are stacked on top of each other thus that for

In Set1 the area for Var1 is drawn from the x-axis up to x=2 and for Var2 from x=2 to x=5 (stacked on top of Var1) Similarly, in Set 2 Var1 would show an area from x=0 to x=4 and Var2 from x=4 to x=9.

The same with bars instead of areas woudl be nice too

• TWiki version: 01 Dec 2001
• Perl version: 5.6.1
• Web server & version: apache 1.3
• Server OS:
• Web browser & version:
• Client OS:

-- MathiasKoerber - 09 Jan 2003

Answer

For the ChartPlugin you should be able to specify a bigger range then the table has, provided that you have no footer rows. E.g. specify 99 rows if you actually have only 2-10 rows.

%CALC%{...} can be used after a table, $ROW() etc are valid after a table until before the next table. That is, you can use %CALC%{...} in your charts, provided that the chart is below the table in question but before the next table.

Stacking / bar charts etc would be possible to implement. It's open soucre, anyone can jump in and code

-- PeterThoeny - 14 Jan 2003