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
The following topic might help you.
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?
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.
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
@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.