Generally when I produce a chart in SFE i reference the actual values (e.g. =barchart(a1:a10)) that will produce the chart.
Is it possible to use a formula to return an array, that will then be used to produce the chart (e.g. =barchart(sumproduct(b1:b10="Thing1",a1:a10))?
I've always gotten an error when I try to insert a formula like the one in red above....but I don't know whether that is because SFE doesn't support using a formula like that....or it doesn't work because I haven't written the formula right (or i don't know the right syntax to use for SFE).