Problem to create some Dynamic charts

[jjlof1 (JJ)]

Hello community,

I have a problem; I’m trying to create a Flow that allows me to generate an Excel file using a document named “ReportTemplate” located in a folder named “Template”. This file should display some charts created from a database called “Report”. However, when the document named “ReportF” is generated to display the charts, they are not visible. It seems that the fields from the pivot table are not within their respective área, even though they are correctly positioned in the “ReportTemplate” file

Could someone please tell me what I’m doing wrong?

My workflow is attached here.
DataAnalysis1.zip (46,6 KB)

[nisarga]

@jjlof1
I have made some changes in code , check whether you are looking for the same output

I have attached xaml for your reference
DataAnalysis.zip (83.5 KB)

Regards,

[jjlof1 (JJ)]

Thank you for providing cleaner code compared to the code I have done, @nisarga.

I have a question; the solution you provided doesn’t show the chart for me. I have to manually select the checkboxes.

What can I do to make the chart appear without having to manually select the checkboxes? The checkboxes are pre-selected in the “ReportTemplate” file located in the Template folder.

[nisarga]

@jjlof1
can you just share me the template chart like the above picture you have shared
so that i can modify according to your requirement

regards,

[jjlof1 (JJ)]

Sure!

ReportWithCharts.xlsx (44,8 KB)

[nisarga]

@jjlof1
Sorry for the delay,
here is the modified code and template

ModifiedDataAnalysis.zip (86.8 KB)

hope it helps you,let me know if it is not working

Regards,

[jjlof1 (JJ)]

Thanks for the help @nisarga,
You are a hero!