How to add formula to the chart in the excel?

Help
1

Hi ,
Each time when i run,I will get a new row added .There is a chart linked with these rows.Currently formula is =SERIES(‘ADR Premium’!$E$3,‘ADR Premium’!$G$4:$G$14,‘ADR Premium’!$H$4:$H$14,4)
How to make this formula dynamic ?
Not sure about write cell activity as it is a chart …

2

Hi.
You can try to use “Invoke VBA” activity for this task. You must write VBA ,add VBA script to you Excel file, and then , calling this VBA macros from UIPath.You can also pass parameters to the macros from UIpath.

3 Likes
3

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.