Qlik NPrinting Color Coding by Business Area to PowerPoint Native Chart
Hello,
I have a PowerPoint report that is generating a list of different product lines under different business segments. In the qlik sense app, I have color codes based on segment, so the bar charts display different colors based on those segments. For instance, green for shoes - red for shirts etc...
When I generate my native PPT charts via table nodes, I do not get my custom colors on the PPT charts. Is there a way to put the colors into the expression box or somewhere else (PPT maybe?) so they come through into the table object formula?
Thanks for your reply. I am actually working in Qlik Sense, so I cannot open a .QVW. Can you explain how to work in the edit data area of the native PowerPoint chart? Maybe attach some images? I am struggling with the nodes and how that would all work to automatically get the colors through to the native table.
Just an update, I was able to add 3 nodes on three columns next to my dimension column and color code each column to be the right color. Now I just need to figure out how the report would generate a zero or blank cell in the columns that are not the correct color for the particular product line in the excel.
