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?
Graph by Excel on TM1Web
-
Goatship
- Posts: 33
- Joined: Tue May 25, 2010 4:15 am
- OLAP Product: TM1
- Version: 9.5
- Excel Version: 2007
Graph by Excel on TM1Web
I'm new to TM1.
-
lotsaram
- MVP
- Posts: 3701
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: Graph by Excel on TM1Web
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.
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.