Hi @Moritz 

in your last comment there are few words which change everything!!! You said: "Here's how the excel spreadsheet look like, which serves for the powerpoint chart:". That is a perfect example of how important is to provide detailed explanation of the problem 🙂

• We never knew you were talking about native PowePoint chart
• Excel table embedded in power point template has very limited capabilities and formulas and variable will not work in it. You can only get data from the table in it - dynamic labels also will not work in it.

Workaround - I know it is not great but:

• dont worry about creting labels for the legend in fact you can just leave them empty and disable chart legend
• make background of the chart transparent
• make legend labels seperately as power point labels and since your chart will be transparent
• you can put current and last year formula or variable directly as individual independent objects and use █ or ■ characters to represent bars and colour them as you need so they can mimic legend

cheers