Dynamic naming series on PowerPoint Graph

[pattyccia]

Hi all,

I have to create a column chart in Power Point like this , where as Categories I have "area" (1,2,3) and as Series I have the last 3 years (e.g. 2020, 2019,2018)

This chart bases on follow data, where as label I put a Qlik Sense variable ( <vYear> = year(now())  , <vLastYear> = year(now())-1  and so on) ... :

I would like visualize series name on graph with the variable value but it doesn't work.

Someone have a solution pls?

[Ruggero_Piccoli]

Hi,

I did some tests and I confirm that variables in the Excel worksheet related to a native PowerPoint chart are not expanded with their values. You could add this as a suggested improvement in https://community.qlik.com/t5/Ideas/idb-p/qlik-ideas

Best Regards,

Ruggero 

[pattyccia]

Thanks Ruggero, I posted it as suggested improvement !