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).

Thanks,

Elliott