topic Output only the Excel chart in Qlik NPrinting

Output only the Excel chart

haasmwdm — Thu, 19 May 2022 09:19:19 GMT

Hello all,

is it possible to output only the Excel chart in a report? So without the associated database (table)?

In my case only the chart is important and the table takes too much space. I would then like to create the diagram as a PDF and print it.

Thanks!

haasm

Ruggero_Piccoli — Thu, 19 May 2022 12:25:20 GMT

Hi,

The native Excel chart uses the data from the table, so you cannot delete it.

You could:

move the chart over the table to hide it
move the table to an hidden Excel worksheet (right click over the workbook name and click on Hide)

Best Regards,

Ruggero

haasmwdm — Thu, 19 May 2022 12:35:43 GMT

If i try to move chart over the table

In the designer it looks lioke this:

But output looks like this:

it always moves the chart under the table

Ruggero_Piccoli — Thu, 19 May 2022 12:46:54 GMT

Hi,

So you have to move the table on an hidden worksheet.

Best Regards,

Ruggero

haasmwdm — Thu, 19 May 2022 13:24:34 GMT

Perfect 🙂

it works.

Thank you very much!