topic Dynamic naming series on PowerPoint Graph in Qlik NPrinting

Dynamic naming series on PowerPoint Graph

pattyccia — Wed, 14 Oct 2020 10:56:01 GMT

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?

Re: Dynamic naming series on PowerPoint Graph

Ruggero_Piccoli — Thu, 15 Oct 2020 14:16:43 GMT

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

Re: Dynamic naming series on PowerPoint Graph

pattyccia — Fri, 20 Nov 2020 07:53:31 GMT

Thanks Ruggero, I posted it as suggested improvement !