topic Qlik Nprinting Powerpoint bar chart in Qlik NPrinting

Qlik Nprinting Powerpoint bar chart

israrkhan — Tue, 19 Jun 2018 06:14:32 GMT

Dears,

Good Day...!

I have created a report in Qlik Nprinting (version November 2017).

i am creating a PowerPoint Report.

The problem is, i have a simple bar chart where Year is the dimension and Sum(Sales) is the expression.

I am bringing this data in to NPrinting as table, and then i am creating power point chart.

How can i assign a specific color to each year, let say current year Blue, and previous year Red color.

Many Thanks

Israr

Re: Qlik Nprinting Powerpoint bar chart

Eva_B — Tue, 04 Jun 2019 21:47:04 GMT

Hello Israr,

I wanted to respond to your post as I saw it has not received any activity.

Are you using Qlik NPrinting with Qlik Sense or QlikView? Have you set the appropriate colors to your bar chart in that application?

Qlik NPrinting Designer embeds the Office PowerPoint application to create the report so we do not have the ability to change how PowerPoint behaves, however, if you ensure the "Keep Source Formats" option is checked it should then keep the template colors. Another option is to use the "Change Colors" button from the "Chart Styles" group.

Otherwise, whichever tool you design the report in, PowerPoint, Excel, Pixel Perfect, etc., it will either keep source formatting when checked, or use the report design formatting if unchecked.

Please let me know if this thread helped with your question. If so, please mark as "Solution."

Regards,

Eva

Re: Qlik Nprinting Powerpoint bar chart

Lech_Miszkiewicz — Wed, 05 Jun 2019 00:27:40 GMT

Hi @Eva_B

Can you elaborate on your comment below: "... if you ensure the "Keep Source Formats" option is checked it should then keep the template colors" ?

I have no idea what do you mean😕 To create PPT chart we need to bring in data as a table, but then you will not retain colours on chart bars. It will be extremely difficult to achieve custom colours on native PPT bar chart. I managed to do this with a lot of workarounds in Excel but in PPT my method will not work. I tried many different options and none of them worked.

So I am very interested in your comment as maybe there is something i have never heard of.

thanks

Lech

Re: Qlik Nprinting Powerpoint bar chart

Eva_B — Thu, 06 Jun 2019 16:27:20 GMT

Hi Lech,

Please see the following Knowledge Article where I was referring to the "Keep Source Formats"

https://support.qlik.com/articles/000007863

1. Deactivating Keep Source Formats without setting a format code in the Format field:

Excel: the Excel format is applied to the cell containing the field tag
Word and PowerPoint: the relative format is applied to the entity at the point of field tag embedding
HTML: the inline style set for the field tag container (div, span, p, th, td, li, etc.) is applied

2. Deactivating Keep Source Formats and entering a format code in the Format field:

Excel: the code in the Format field defines the numerical or time/date format, while graphic style is controlled by the Excel format tools applied to the cell containing the field tag (color, font, size, style, justification, etc.)
Word and PowerPoint: both the relative format and the format field are applied to the entity or container at the point of field tag embedding
HTML: both the inline style set and the format field are applied for the field tag container

Regards,

Eva

Re: Qlik Nprinting Powerpoint bar chart

Lech_Miszkiewicz — Thu, 06 Jun 2019 23:11:19 GMT

Hi @Eva_B

Well those articles have nothing to do with colours of bars in native charts. I do not see any corelation to the question of this thread