Now, variables in the Excel worksheet related to a native PowerPoint chart, are not expanded with their values.
Example: Suppose we want to create a column chart in Power Point , where as Categories I have "area" (1,2,3) and as Series I have the last 3 years (e.g. 2020, 2019,2018).
As Series label I would like to use a Qlik Sense variable ( <vYear> = year(now()) , <vLastYear> = year(now())-1 and so on) ... :
This is the result :
I would like visualize series name on graph with the variable value.
In addition to that I wish we had the ability to conditionally color the bars/marks on the PowerPoint charts. It would make them a lot more dynamic. Same with PowerPoint shape objects, it would be awesome to set background/text color.
Or just allow us to set a custom vba macro to auto run BEFORE Nprinting saves/sends the report.