1. 

   sf_baker, Member

   I would like to put multiple charts on multiple worksheets in an Excel .xlsx file.

   A couple of issues I've run into...

   1. There is a lot of whitespace between charts on a single worksheet. 32 rows in total. Is there a way to define the location of the chart on the worksheet?

   2. I can't get the second worksheet to be formatted in landscape mode. I can put the first worksheet in landscape mode, but the second worksheet seems to only be capable of portrait mode.
2. 

   myDBR Team, Key Master

   With newest build the extra rows are no longer inserted when exporting to multiple sheets. Also the landscape mode now works on every sheet.

   There is a new export-option position which one can use to set the object position in Excel.
   Usage:
   

   select 'dbr.export.options', 'position', 'C6';

   --
   myDBR Team
3. 

   sf_baker, Member

   The position option works well. Thanks!

Reply

You must log in to post.