Dynamic Chart Title

Post Reply
User avatar
macsir
MVP
Posts: 785
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1
Version: PAL 2.0.9
Excel Version: Office 365
Contact:

Dynamic Chart Title

Post by macsir »

Looks like it is not supported in TM1 web although I can refresh it in Excel. Just want to confirm it?
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/
Wim Gielis
MVP
Posts: 3230
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.1.5
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Dynamic Chart Title

Post 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.
Best regards,

Wim Gielis

IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
User avatar
garry cook
Community Contributor
Posts: 209
Joined: Thu May 22, 2008 7:45 am
OLAP Product: TM1
Version: Various
Excel Version: Various

Re: Dynamic Chart Title

Post 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.
lotsaram
MVP
Posts: 3702
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: Dynamic Chart Title

Post 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.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
User avatar
macsir
MVP
Posts: 785
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1
Version: PAL 2.0.9
Excel Version: Office 365
Contact:

Re: Dynamic Chart Title

Post by macsir »

Thanks, guys. I also did that.
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/
Post Reply