Update graph in excel when new data are inserted

[Melee_Noob]

There are a few graphs such as the one attached that need to be updated when i insert new data into excel. Right now, when a new data row is added, the graph does not update accordingly. Appreciate some help on this, thanks:)

[Nithinkrishna]

Hey @Melee_Noob

I guess if you have a proper link between graph and data it should automatically refresh.

Thanks
#nK

[Palaniyappan (Palaniyappan P)]

Hi

Check this thread on how we can refresh the excel file and its data like chart using UiPath

Automate excel data refresh

The “Main” is the name of the Sub or Function from the .vb file. In my example, I put there RefreshAll, because that’s how I called my Sub: [image] As to the file name, it should be a full one, including the extension. Also, make sure that you are only running this 1-line script from above. Your previous script is literally first getting the list of files, then opening each one and then doing the RefreshAll part. This is now all done in UiPath, so you only need to execute the RefreshAll part. …

Cheers @Melee_Noob

[Melee_Noob]

hi, how do get the proper link?

[Nithinkrishna]

Hey @Melee_Noob

Something like this

How to build a chart on a table in Excel: step by step instruction

Thanks
#nK

[Melee_Noob]

hi, but how do i do it using uipath?