I have set up a dynamic name range referencing a range of data which use Offset to reference ActiveForm data.
Dynamic range similar to below
Then I created a pie chart based on the name range.
In Excel, I change SUBNM selection and rebuild, the ActiveForm updates and so as the pie chart, perfect!
However, the pie chart does not update anymore once the workbook is uploaded to TM1 web. I did some research and found a related IBM reported error about chart with OFFSET datasource not rendered probably.
Does anyone know a workaround?
Thanks in advance.
Dan
Office 365
PA 2.0.6 Perspective