align table and chart in excel template

[ronaldwang]

If I put a chart next to a table in the excel template and in the table I use “expand” option for the columns. Then when data is populated in the table, the position of the chart and table will no longer align, as the number of rows to be expanded in the table can vary, what can be done to the chart side to make sure the two objects’ position could still align? I have tried insert the columns behind the chart but still don't work.

[sriabt]

Thanks this is helping 80% but still the left side table formats are showing upto the right side chart size. For example the left side table value ends upto ROW 6 but the right side chart is showing up to row 15..then the left side table format is showing from Row 7 to Row 15 as extra. Please help to fix this issue.

[Ruggero_Piccoli]

Hi,

As general rule, please avoid to comment 3 years and half old conversations because the software could be changed on a so long time. Instead start a new conversation, add all the details needed to reproduce your issue (including screenshots, steps, etc) and the label with the correct version you are using. 

In this specific case, the way of working of Qlik NPrinting about how Excel reports are generated is not change so I have very few details but I suspect the old answer is still valid. 

Best Regards,

Ruggero

[Frank_S]

Further as a new poster her and as potentially a new user of NPrinting, we recommend checking the available NPrinting training pages tutorials and videos available for your convenience.

https://community.qlik.com/t5/Knowledge-Base/Qlik-NPrinting-Training-and-Information-Resources-Step-...