I'm currently working on a report that should export an excel with multiple tabs. On each tab I want a list (or table) with some data, and a graph that visualizes this data. I want the people using the exports to be able to make changes to the data and the graph if needed.
What I ultimately want is that if some change is made to the list/table of data (within excel), this change is automatically made to the graph as well.
I can see that currently the graph gets its data from an xml file, but what I want is the graph to get its data from the list that is in the same tab.
Is there any way to do this?
Thanks!
------------------------------
S V
------------------------------
#CognosAnalyticswithWatson