BI Publisher : Excel template chart does not update dynamically
Problem Description
---------------------------------------------------
loss of functionality : cant update the excel template chart dynamically (XDO values applied)
Explanation: Designed a table in excel template (by adding XDO values) and designed chart for the corresponding table. when ever preview the report or executing the report, the table is getting update with data, but the bar chart is not updating. It shows only the first row of the table,does not includes the remaining generated rows.
Even we tried offset function and also insert-> table option too. In insert -> table option once the report run the output is falling outside of the named range. But none of the methods are working.