Page 1 of 1

Dynamic Chart Title

Posted: Mon May 16, 2016 4:27 am
by macsir
Looks like it is not supported in TM1 web although I can refresh it in Excel. Just want to confirm it?

Re: Dynamic Chart Title

Posted: Mon May 16, 2016 10:03 am
by Wim Gielis
Hello,

I did a simple test and can confirm that it does not work, Excel 2013 and TM1 10.2.2.4.

Re: Dynamic Chart Title

Posted: Mon May 16, 2016 3:54 pm
by garry cook
Annoyingly not in 10.2.2.2 - 10.2.2.4 - had dynamic lookups for Product Group names mapped from string cube hierarchy points and had to go with the low tech option of putting the title in an Excel cell fitted to the graph floating above the graph.

Doesn't look great but did the job - dynamic name changing of the Graph header but not held inside the actual border of the chart.

Re: Dynamic Chart Title

Posted: Mon May 16, 2016 7:29 pm
by lotsaram
garry cook wrote:Annoyingly not in 10.2.2.2 - 10.2.2.4 - had dynamic lookups for Product Group names mapped from string cube hierarchy points and had to go with the low tech option of putting the title in an Excel cell fitted to the graph floating above the graph.

Doesn't look great but did the job - dynamic name changing of the Graph header but not held inside the actual border of the chart.
This is the workaround I have always used - put whatever text is required for the chart in a formula driven cell and place the cell directly above the chart or behind the chart and make the chart background transparent. It has always worked for me; with some additional effort but I wouldn't say any detrimental visual impact.

Re: Dynamic Chart Title

Posted: Tue May 17, 2016 3:36 am
by macsir
Thanks, guys. I also did that.