How to create Dashboard in excel?

[Balqees_Almamari]

I have data in excel and i want UiPath to create Dashboard and can i update excel data and automatically updated in Dashboard

[Anil_G (Anil Gorthi)]

@Balqees_Almamari

A better way instead of creating dashboard everytime

Create a template with all the dashboards you need and then make a copy of template uisng rpa and fill the data using rpa ans refresh the dashboards

Cheers

[nishi_jain]

Hi @Balqees_Almamari

Try this approach would be to create the dashboard once in Excel using Pivot Tables, Pivot Charts, and formulas. Then, whenever UiPath updates the source data, use Excel Process Scope + Refresh All Data Connections/Pivot Tables (or VBA invoked from UiPath) to refresh the dashboard automatically. This avoids recreating the dashboard every run and ensures the latest data is reflected in the existing dashboard.

If Solution works for you please mark as solution

Thanks

[kkapula4 (kkapula)]

Create the dashboard in Excel (Pivot Tables, Charts, Power Query, etc.) and use UiPath only to update the source data. Once the data is refreshed, the dashboard can be updated automatically by refreshing the workbook. If you need a more interactive solution, you can also connect the Excel data to Power BI and use UiPath to refresh the dataset.

[Krishna_Raj]

@Balqees_Almamari check this reference

Build a dashboard in excel with UI PATH?

Hello, I am trying to build a dashboard in Excel using various other files: I need to update each of the files Copy the tabs that interest me into a new Excel file Aggregate the data into pivot tables, etc. Then I want to create a dashboard (for a sales team) using this data (It would be more convenient on Power BI, but I don’t have access to it at the moment) Several questions: Do you think this is doable with UI Path? Which activity do you use to place a chart at a specific location on a…