I have a chart in spreadsheet that I can pull the xml for. The problem is the values in the chart are not there when I pull the xml. The chart itself reference formulas in different cells and worksheets all within the same workbook. Is there a way to get this to work?
If the chart values reference static data it works just fine. I am not able to figure out how to pull it with the dynamic data still in the chart.
Any help would be appreciated! I am using SDK 2.0 and C#.
Thanks