feature: Chart.update_cached_values() (from linked Excel workbook)

[zcattacz]

even with linked graph, one has to select every single chart and click update once per chart. this is tedious work for weekly presentation with lot of charts. It would be great if its possible to be done in a programatical way. update ppt with data directly from obdc database.

[scanny]

@zcattacz I'll need more to go on. Are you sure you got the right repo? I'm not sure what kind of linked graphs you're talking about.

[zcattacz]

Sorry. allow me to explain, I mean the charts pasted from excel. or created by clicking Chart button from Insert tab. Normal paste will create a embedded dataset in pptx (not sure about is actual structure in xml) which is used to plot the chart.
Right clicking these charts and select edit data will bring up a Excel instance where user can edit the data for the chart. The difference between a linked and normally pasted chart is that linked chart's edit data action will open the linked excel source file, normal chart will open a temporary one. After saving the charts will be replotted with updated data.
For linked charts simply editing the source excel file before opening the pptx will not get these pptx charts updated, one has to select each chart and click the update button once per chart. (where "linked" really doesn't help much. the pptx has a snapshot of these data embedded in either case, I believe.)
It would be really great if there is a programable way to update these data snapshots pptx embeded for inserted charts.
Hope this help make the topic clear.

[scanny]

Ah, got it now, thanks, that makes sense :)