TM1 Forum

Dear all,

I make a graph in Excel and put it on TM1web, a problem is some chart formats do not follow that in Excel, specifically the graph axis option. However, some chart features, such as the chart size, do adjust according to Excel.
I already tried both Excel 2003 and 2007, not working. How to fix this?

Not all Excel chart options and properties are supported by Dundas charts which TM1 web uses.

Secondary axis and multiple chart types on a single chart in particular are not very well supported (work around for web reports is overlaying multiple charts over each other with transparent chart and plot area) but there are plenty of other Excel chart features that don't transpose well or at all to web reports. This is an area that isn't very well documented by IBM. Unfortunately it is more or less trial and error to figure out what works and what doesn't.