topic Re: Adding data labels in stacked chart Excel Nprinting in Qlik NPrinting

Adding data labels in stacked chart Excel Nprinting

PervezIbrahim — Fri, 15 May 2020 11:45:51 GMT

Hi,

I have created a stacked bar chart in excel NPrinting. The problem is, it is only showing Data labels for the first stack:

In Normal excel charts, we can add data labels by clicking on the stacked bar but in NPrinting, we don't see stacks when we design the template. following is the view from template editor. we only see stacks once we take an NPrinting export.

Please help!!!

Re: Adding data labels in stacked chart Excel Nprinting

Ruggero_Piccoli — Fri, 15 May 2020 13:40:51 GMT

Hi,

Please try to upgrade to a more recent version. I tested with latest (April 2020) and I had an Excel native stacked bar chart with data labels at first run:

Best Regards,

Ruggero

Re: Adding data labels in stacked chart Excel Nprinting

Lech_Miszkiewicz — Sat, 16 May 2020 06:41:41 GMT

Hi @PervezIbrahim

When adding your labels you probably clicked on chart and already selected only first series row. If you do that your labels will appear only on one stack (this is standard for excel)

The solution is to just select chart and add labels from toolbar menu.

Re: Adding data labels in stacked chart Excel Nprinting

PervezIbrahim — Mon, 18 May 2020 17:18:03 GMT

Hi Lech,

Thanks for you response!

I tried selecting the chart and adding the labels as you mentioned but no luck.

A piece of information that i forgot to mention was that this chart is based on a pivot table, if at all it changes anything.

Re: Adding data labels in stacked chart Excel Nprinting

PervezIbrahim — Mon, 18 May 2020 17:21:25 GMT

Hi Roggero,

Thanks for your response.

i'll surely try upgrading but that involves a long process of approvals it has to go through, in our organisation. By then, i was searching for a work around here itself.

A piece of information that i forgot to mention was that this chart is based on a pivot table, if at all it changes anything.

Re: Adding data labels in stacked chart Excel Nprinting

Lech_Miszkiewicz — Mon, 18 May 2020 22:28:48 GMT

using pivot table--> yes-that piece of information changes everything!

I would need to do my testing again to see, but again it will depend on how you have built your pivot table. So sharing that information (the layout of your pivot table, before data being populated -template, and after data is populated - pivot table with actual records) would be necessary for me to start investigation. You can change data so you don't share real info.

You may want also describe which of the dimensions changes number of distinct values in it.

Re: Adding data labels in stacked chart Excel Nprinting

Ruggero_Piccoli — Tue, 19 May 2020 09:07:48 GMT

Hi,

I'm able to reproduce your issue with a pivot stacked bar chart. Please open a support ticket about the issue with a link to this conversation so the support will know that I already tested the issue and they will send the information to the development team for deeper tests.

Best Regards,

Ruggero

Re: Adding data labels in stacked chart Excel Nprinting

PervezIbrahim — Thu, 21 May 2020 14:27:23 GMT

Thanks Rugero!

Re: Adding data labels in stacked chart Excel Nprinting

Frank_S — Mon, 22 Jun 2020 14:16:22 GMT

Please note that this issue is currently under investigation but we expect it to be resolved in a near future release of NPrinting. Please return here for updates or check future Qlik NPrinting product release notes for news on resolution of this issue.