TM1 Forum

We are in the process of upgrading TM1, and ,one of the benefits to us is Active Forms. However it appears that you cannot create a Chart/Linked spreadsheet from Active forms as the range disappears when you expand or collapse the cells when the spreadsheet is Opened. Does anyone have a workaround for this issue?

Is this possible in 9.5.2? Or we still can not link chart to active form data.

Thanks
suhamore

No.
Either create a fixed report containing DBRW formulas, and base the charts on them.
Either use TM1 views on TM1 Web where you can have the view and a chart on the same screen.

Wim Gielis wrote:No.
Either create a fixed report containing DBRW formulas, and base the charts on them.
Either use TM1 views on TM1 Web where you can have the view and a chart on the same screen.

I never noticed the original thread from 2010 but yes of course it is possible in Excel and I would have thought that Wim as an Excel MVP would have pointed that out.

Just that it is a little more complicated than a regular chart insert as you either have to define a data table and make that the source of the chart area or create the ranges for the data series via named formulas using offset. Both these techniques may not work in TM1 Web but no problems in Excel.

Some examples are attached.

lotsaram wrote:I never noticed the original thread from 2010 but yes of course it is possible in Excel and I would have thought that Wim as an Excel MVP would have pointed that out.

Just that it is a little more complicated than a regular chart insert as you either have to define a data table and make that the source of the chart area or create the ranges for the data series via named formulas using offset. Both these techniques may not work in TM1 Web but no problems in Excel.

Some examples are attached.

Oh darn, I was wrong on that one because I did not test and experiment.
I DO know dynamic ranges and charts , but honestly I never used them with Active forms.
This is some neat stuff, although not all examples will be as useful as they seem. For example "offset rows": an AF is dynamic in the rows, so 10 hardcoded named ranges will not be an elegant solution.
But on the positive side: the tests I just did seem to indicate that it works on TM1 Web (TM1 10.1, not tested in earlier versions if that matters).
When the chart is "next" to the active form, it's important to set the chart property of "Don't move or size with cells".

Wim Gielis wrote:But on the positive side: the tests I just did seem to indicate that it works on TM1 Web (TM1 10.1, not tested in earlier versions if that matters).

I'm using 9.5.2 and Excel 2007. I have a chart on a separate sheet to the active form and using offset and named ranges it works fine in both excel and TM1 web. I also use an INDEX and a vlookup so that the user can choose the project (source data is the project column of the active form) to display on the graph or all projects.

Interestingly the graph that I use is a dual axis graph which is not supposed to be supported in TM1 web, but it works fine.