Possible to use Formulas for PowerPoint Graphs ?

[C_Johan_V_Ekman]

Hi, 

I have created simple "normal" formulas that works fine when the tag is placed "openly" on the powerpoint (Like a "KPI").
Exmaple value 120. Displayed on preview fine as a KPI. 

However, when trying to use the tag inside a bar chart (Edit data on chart -> Opens excel -> Add tag where value of bar should be) to generate a bar it lays "dormant" / "inactivated" when previeing the powerpoint. On the previewed PPT I open the bar chart by editing data to find that the tag is there but have not generated the value of 120. Just the tag in text. 

Is it not possible to use formula "tags" in edit data (excels) in powerpoint graphs?
Using table tags and cell tags works fine but those are of course reliable on created objects in QLikview / Sense. Would like to not be dependant on created objects in apps in this case hence using formulas. 

Possible - no yes why? 😃 

[Lech_Miszkiewicz]

Hi @pwagner 

you have to follow the process...

in your screenshot your excel has 2 sheets. Obviously you (or someone else) have modified it.

When inserting PPT chart excel opens up always with Sheet1 and special placeholder in which you should insert table column tags. That excel looks by default like this: 

and whole process .GIF

If you have done modification to this excel file then it is likely the cause of your issue.

cheers

[pwagner]

Thank you @Lech_Miszkiewicz 

Understood.

We found another solution for this request. 

Regards, Patrick