Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Suggest an Idea

Announcements
This page is no longer in use. To suggest an idea, please visit Browse and Suggest.

Dynamic naming series on PowerPoint Graph

pattyccia
Contributor III
Contributor III

Dynamic naming series on PowerPoint Graph

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) ... :

pattyccia_0-1605796914108.png

This is the result :

pattyccia_1-1605796948802.png

I would like visualize series name on graph with the variable value.


Thanks,

Patrizia

Tags (1)
3 Comments
devan9876
Creator
Creator

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.

Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

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

Andrew_Kruger
Employee
Employee

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

Status changed to: Closed - Declined