Writing Horizontal Layout of Table and Chart to Excel

[GirouxM]

Hi -

I have built a workflow (simplified version attached) that displays a Chart next to a Table (using Horizontal Layout) and outputs in Excel... however, in Excel the chart is 100% in a single row instead of being spread out over multiple rows. How can I force the chart to keep its size and occupy multiple rows ?  Outputting to a Browse tool (also in attached workflow) it looks fine.

The attached workflow also includes a Vertical Layout (of Table and Chart) and the chart does occupy multiple columns.  How do I get this to work for Horizontal Layout (occupying multiple rows)?

(I've also attached an image of the Excel Output and what I am looking for incase you can't run the workflow yourself)

Thank you!

[Yoshiro_Fujimori · Accepted solution]

Hi @GirouxM 

I tried your workflow and could not find a way to put the chart outside of a single row.

Is "Excel" format a mandatory requirement?

If not, with .pdf or .docx format you would get the desired output.

Output image in Word

Output image in PDF

Sorry if this is not what you want.

[GirouxM]

Thank you Yoshiro. Unfortunately Excel is the preferred output by the client. Thank you for investigating. 

[GirouxM]

i'll propose word or pdf to the client though.