Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
haasmwdm
Contributor III
Contributor III

Output only the Excel chart

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.

 

haasmwdm_0-1652951623878.png

Thanks!

haasm

Labels (2)
1 Solution

Accepted Solutions
Ruggero_Piccoli
Support
Support

Hi,

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

Best Regards,

Ruggero



Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.

View solution in original post

4 Replies
Ruggero_Piccoli
Support
Support

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



Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.
haasmwdm
Contributor III
Contributor III
Author

If i try to move chart over the table

In the designer it looks lioke this:

haasmwdm_1-1652963633163.png

But output looks like this:

it always moves the chart under the table

haasmwdm_0-1652963584699.png

 

Ruggero_Piccoli
Support
Support

Hi,

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

Best Regards,

Ruggero



Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.
haasmwdm
Contributor III
Contributor III
Author

Perfect 🙂

it works.

Thank you very much!