I'm developing a dashboard in Xcelsius 2008 using Live Office to update the data every 5 minutes by running a Web Intelligence report. I got a graph which will display data and the range of the data will change depending on how many records are returned by the report.
So in my graph I select B2 - B20 to be used as a source for my series and A2-A20 as source for the labels. Simple.... I also selected Ignore Blank Cells in Series to get the graph to stop if there is no more data. This works like a charm, but when I update the dashboard and there are more/less data in the report the look of the report is totally messed up.
If the report returns 5 records when I develop the dashboard, so I got data in row 2 - 7 only when I save the swf. But when I open the dashboard and refresh the data I know there is one more row added so there should now be data in row 2-8 and the graph should be displaying 2-8 instead of 2-7. But to my surprise it is still only showing 2-7! Why?
After a long search I discovered that by using a label to display the value in A8 and after refreshing the data and one more record was returned the label displayed A9 instead of A8, so it looks like there are new rows inserted into the Excel model instead of just replacing the empty cells. This could explain why the graph doesn't display the new rows, but this is just speculation.
I got Xcelsius 2008 SP1 with the latest fixpack installed.
Is this a bug or is there something I'm doing wrong???