Writing Horizontal Layout of Table and Chart to Excel

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!

Excel Horizontal Layout Table and Chart.yxmd

Excel_Output.jpg

Reporting

Accepted answers

Yoshiro_Fujimori

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.

All comments

Yoshiro_Fujimori

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.

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

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

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703