Cognos Analytics

 View Only

Excel export graph linked to data in list

  • 1.  Excel export graph linked to data in list

    Posted Tue October 18, 2022 09:43 AM
    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?

    S V