Graphs overlapping tables in Excel export

Will Pilsbury

• October 06, 2020 15:50

Hello,

When exporting a report to Excel, the graphs and tables often overlap each other, especially if the datatable is quite large. To get around this I have been adding blank rows in between the elements, but this doesn't always work and is tricky to get the desired result. Is there another way to ensure graphs and tables don't overlap in Excel downloads?

Thanks,

Will

-1

• Official comment

  

  Natan Cohen

  • October 15, 2020 23:09

  Hey Will,

  I feel your pain.  Excel exports can be tricky to get just right.  I've had the best results with Excel Templates.  If you're not familiar with this feature, you can read more about it here -

  https://documentation.logianalytics.com/logiinfov12/content/excel-template.htm?Highlight=excel%20template

  You have full control over what gets written to each cell range (called a pattern block) and even which worksheet.  So I would propose a defined pattern block for the data table, followed by a defined pattern block for each chart.  You would then create a button on your web report and use an Action.Template to call the Excel export.  Hope this helps!

  Thanks,
  Natan
  Logi Support
• 

  Steve Jarvis

  • March 18, 2021 17:12

  Hi Will,

  I frequently use templates, some quite complex, to produce reports. The best approach I find to start the process is to create separate tab/tabs for data and another for the chart/charts using pattern blocks. That way the charts can be positioned exactly where you want to see them.

  When creating the template I use a spreadsheet that contains both data and chart to make sure all formatting is correct. I then edit this to create the template.

  I hope this helps,

  Steve

  0

Please sign in to leave a comment.