Excel report -hide the line behind the image of bar chart - nprinting

[ashmitp869]

Hi All,

Can I hide the lines in excel where creating excel report and bring bar chart as image .

[Lech_Miszkiewicz · Accepted solution]

Hi Thise lines are simply cell borders  in Excel, I guess you have created them .

Switch borders of in Excel (cell format) in the area where chart is produced.

Note: 1

It is hard to test now as NPrinting 16.9 is not supported for few years, but you may also try to get the exact size (in px) of your chart from QlikView chart properties and in excel prepare the exact sime size placeholder for NPrinting tag. I guess those lines you see there are simply because you have created on row of cells which supposed to be a frame for your image however they are not large enough an NPrinting multiplies them...

Note: 2

For such simple chart I would use native excel charts since they look much nicer, you have more controll over it in excel and will also solve your problem and in fact will perform better (in case you have cycle or page used to create it)

All tutorials are available here on community:

https://community.qlik.com/t5/Qlik-NPrinting-Documents/QlikView-NPrinting-16-Tutorials-by-Subject/ta...

excel charts tutorial is in submenu:

https://community.qlik.com/t5/Qlik-NPrinting-Documents/How-to-Create-MS-Excel-Charts-from-Qlikview-D...

cheers 

[Ruggero_Piccoli]

Hi,

I strongly suggest you to plan the migration to a supported version of Qlik NPrinting https://help.qlik.com/en-US/nprinting/May2021/Content/NPrinting/Migrate/Migrating.htm

Best Regards,

Ruggero