Appending a Rendered Chart to Existing Excel Data

Question

I am trying to take a render output and appending it to an Excel document (if possible).

What I’m doing is I created a chart in the Interactive Chart tool and rendered it to an Excel file. Now I want to take these charts and append them to another Excel file's sheet that already has summary data.

cblazer · Accepted Answer

Hi -

So I don’t have a solution for the method as you describe it, but it is possible another way. The render tool doesn’t have any option to only overwrite a sheet, so it just makes a new file every time.

The solution is to create a full report that combines the summary table with the graphs and renders them at the SAME TIME to the desired excel file.

Sample workflow as follows, hope this helps!