Excel Chart - (Chart Combo not providing results expected)

[ton_roelandse]

Excel table with 4 columns; from these 4 columns a Chart of type Combo (three lines, and one clustered column) is updated. Data range is dynamic based on data source. Use an excel template file that has the chart data ranges, and other formatting for this.

I use the Update Chart Activity (UIPath.Excel.Activities.Business.UpdateChartX) to update the Data Range.

What works : the Line series display properly with the new Range, but the clustered column has been reset to Line, and that destroys the intent of the graph.

Q1:) is this a known issue? are there issues with supporting an Excel Combo Chart in UIPath?
Q2:) is there a workaround?

Anyone?

[Raluca_Laic]

Hi @ton_roelandse ,

How was the chart created? Was that directly in Excel or through Studio?

Thanks,
Raluca

[ton_roelandse]

Hi Raluca - Chart was created via Excel - and range updated through the Update Chart Activity.

We are doing a little more research on this as well and will report back what we found - we want to rule out any Excel native issues.

[Raluca_Laic]

Hi @ton_roelandse ,

Would you be able to share with us a sample workflow repro’ing this so we can further investigate this?

Thanks,
Raluca