idea Dynamic naming series on PowerPoint Graph in Suggest an Idea

Dynamic naming series on PowerPoint Graph

pattyccia — Thu, 19 Nov 2020 14:44:13 GMT

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.

Thanks,

Patrizia

Re: Dynamic naming series on PowerPoint Graph

devan9876 — Thu, 19 Nov 2020 19:25:10 GMT

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.

That would work too.

Re: Dynamic naming series on PowerPoint Graph

Lech_Miszkiewicz — Thu, 19 Nov 2020 23:46:02 GMT

It is very much needed functionality and I was often left without ability to get something done in PPT due to this lacking functionality.

Re: Dynamic naming series on PowerPoint Graph - Status changed to: Closed - Declined

Andrew_Kruger — Mon, 19 Dec 2022 14:49:39 GMT

Thank you for the post - no planned update for this area.