Hello,
we are currently trying to build a workbook on BI 7.0 that contains several tables and charts.
We have an issue with the charts.
We have tried to build the charts this way:
1- Insert chart (Xls functionality)
2- Selection of the chart type and press "finish"
3- In the analysis grid properties, we have selected the chart in the tab "associated charts"
==> the output does not work as the chart selects the row headers to build the graph (as well as result rows). The system can not understand the text of the headers as he expects figures. So the output does not display anything.
Second issue: the result rows and columns are included in the selected lines, and we don't need those as detailed figures already have the information.
We have tried to resize the "data area" of the chart without success. If the chart is associated with the table, every time the query is refreshed the selected area is reseted.
We have also tried not to select the "associated chart" option, but it does not work either as the table size changes depending on the number of characterisics diplayed in the query (in the columns as well as in the rows).
Does anyone knows how to do this?
Thanks in advance!