What is the best way to create graphs on Excel?

[cybzom (Kiran Saminathan)]

I want to create bar graphs and pie chart in Excel but I’m not sure what is the best method to/achieve this besides using 3rd party custom activities.

All that strikes my mind at the moment is templates, and Ui Automation but, is there a better way? Plz let me know

@ppr @NIVED_NAMBIAR @loginerror @Pablito @seanrockvz13 @Parth_Doshi @AndersJensen

Your inputs on this would be appreciated

[Yoichi]

Hi,

The following topic might help you.

Excel Pivot and Graph configuration Automation

Hi, The latest preview Excel package : UiPath.Excel.Activities Packagev2.10.0-preview includes some new activities for chart (and pivot table) as the following image. Can you try them? [img20210202-6] Although it’s for StudioX, we can also use them in Studio. Please make sure to check Show StudioX at filter settings in Activities panel. Regards,

Regards,

[NIVED_NAMBIAR (NIVED N)]

If u are not allowed to use third Party pacakges

U can trying invoking code which generate graphs using excel data in c# or vb.net using invoke code activitiy

Try that

Regards

Nived N

Happy Automation

[seanrockvz13 (Sean Jerome Llanto)]

@cybzom

pie chart in Excel but I’m not sure what is the best method to/achieve this besides using 3rd party custom activities.

Hi @cybzom, do you have the graphs/charts readily available? If so, the easiest way is to have a sheet with the graphs ready. What we normally do would be to change the data from the graph instead. This is assuming the graph that you have would be fixed and inly the data would be changing.