Need ability to specify constant
values instead of being forced to use table data.
This change affects not just
, but also any plugin parameter that allows for a spreadsheet range to be specified (
). Now a constant can be specified in addition to spreadsheet ranges.
For example specifying:
would draw 2 lines. The first is from R1:C1..R10:C1 and the second would be a line with the constant value =
with 10 data points (to match the number of data points specified in the first line). This would allow you to highlight the value 0 if some of your data is < 0 and other data is > 0.
Or say that you want to use a data legend that is different from any data that might appear in a table cell, so you could do something like:
legend="R1:C1..R1..C4,--avg--" which would create 4 data legends from the table and a 5th data legend as the constant =--avg--
This also allows for creating a chart that doesn't get any data from a table. For example specifying
data="1, 2, 3, 4, 5"
would create a line with 5 points on it with the specified values. This feature allows for easily creating