topic Bar chart from Excel report to Pdf in Qlik NPrinting

Bar chart from Excel report to Pdf

BootCam — Fri, 15 Nov 2024 21:27:54 GMT

Hi,

I have six bar chart created by cycling (using levels) through a dimension in excel format but while outputting the charts in pdf report, the charts are looking really small and and aligning one after another. But i would like to put the chart in 2 charts per row and all six charts in one pdf page.

Is this possible?

I went through posts in the community but couldnt find possible a solution yet.

Thanks.

Re: Bar chart from Excel report to Pdf

Lech_Miszkiewicz — Tue, 25 Jul 2023 14:20:45 GMT

Hi @BootCam

Screenshot of your template would help... but...

I dont think you can do excel charts by utilizing levels - that was never supported
yes - it is possible to create charts side by side, but not within the level

There is more info required to give you correct answer, we need:

mockup of how your charts need to look like
screenshot of data source so we can understand how to get data sourced for your charts
1. this may require us to load data in format so it prepares separate set of data for each chart

cheers

Lech

Re: Bar chart from Excel report to Pdf

Lech_Miszkiewicz — Tue, 25 Jul 2023 14:24:25 GMT

Also - are charts native excel charts or are you creating them as images (which would be supported).

If those charts are images then you need to utilize image size properties to size them up to your liking:

Working with Qlik Sense objects:

https://help.qlik.com/en-US/nprinting/May2023/Content/NPrinting/ReportsDevelopment/Qlik-objects-supported-NP.htm

cheers

Re: Bar chart from Excel report to Pdf

BootCam — Tue, 25 Jul 2023 16:01:39 GMT

Hi Lech,

Thank you for your replies. Please allow me sometime to organize and send you a proper reply.

Will get back to you soon.

Thanks.