Can we create bar graphs and charts from excel data in UiPath?

[Palaniyappan (Forum Leader)]

No worries
We don’t need to write vba
We can get that from excel itself
We got an option called Record Macro

@Palaniyappan

Hope these steps could help you resolve this
–here in uipath we got an option called INVOKE VBA , activity
–once the macro is recorded and obtained as a vb script , copy that and paste in a text file (.txt)

Cheers @new_user

[new_user]

I’ll check it now. Thank you!

[Palaniyappan (Forum Leader)]

Great
Cheers @new_user

[lulu75 (Lucie Yeung)]

Hi, I just want to create a column chart from my Excel data. But it doesnt work. Do I have forgotten something to fill ? Thank you. Here is a picture of my Excell datas and UI Path column chart infos. Thank you for your help !!!

[balupad14 (Balamurugan)]

Hi @lulu75,

Can you attach the sample excel …

Regards
Balamurugan.S

[lulu75 (Lucie Yeung)]

Yes ! here is the excel file that I want to transform in a column chart. Thank you very much for your help ! Sample.xlsx (8.7 KB)

[balupad14 (Balamurugan)]

Hi @lulu75,

This is the output… Use the latest version which i have attached it in the below.

UiPathGo - BalaReva Excel Activities

Hello Friends, I have successfully uploaded the BalaReva XL Activities in UiPath Go. This package contains 36 custom activities. It is related to the Workbook, worksheet and sheet data. It helps and simplifies more processes into the excel file. All components can be configured very user friendly. This package is having the below activities. Pie Chart - Using these activities you can able to generate the Pie Chart Column Chart - Using these activities you can able to generate the Column …

Regards
Balamurugan.S

[lulu75 (Lucie Yeung)]

Yes, I can do it manually too. But how did you do it on UI Path ? What have you written inside the Activity fields ? I already use Balareva for Excel, that’s why I’ve asked for help cuz it doesnt work : I don’t know how to do it… Can you please send me a picture of the fields for Activity ColumnChart, so that I see what I missed. Also, there is only ColumnChart Activity to get in my Sequence ? Or does it need something else ?

[balupad14 (Balamurugan)]

Hi @lulu75,

Download the package from this link.

https://forum.uipath.com/uploads/short-url/pW0lzbZkyg9sEl3aWPDE6ayPmSu.nupkg

Configure it as mentioned in the below video.

How to configure the local Package in Uipath

Hi All, Here I have attached a video that how to configure the local package in UiPath. It will be helpful to the beginners. [Configure Package in UiPath] Note : Please share you opinions here about this. Regards Balamurugan.S

and install the package…

Regards
Balamurugan.S

[lulu75 (Lucie Yeung)]

Yes thank you ! it is now the last version of BalaReva. So I put the Activity “Colum chart” inside my Excel Application scope". Then here are the details so that the column chart works, but I have a message error that tells “The index is outside the limits of the table”… Which cell range did you write ? Can you show me what did you write inside the Activity Column charts specifications ? That’s crazy it doesnt work… thank you. OR maybe there is something more to do?! Thank you so much

[balupad14 (Balamurugan)]

Hi @lulu75,

The Range should be begin and end like “A1:J10” . Change the Cell Range. It will work.

Thank you
Balamurugan.S

[lulu75 (Lucie Yeung)]

Thank you, it is done. But UI Path tells me “The object reference is not defined to an instance of an object.”

[balupad14 (Balamurugan)]

Are you using inside excel application scope ? Better can you send me the xmal and excel by message…

Regards
Balamurugan.S

[lulu75 (Lucie Yeung)]

Well, I know what was the problem : I use Column chart activity from BalaReva. But only “ColumnClustered” charType works. When I want to select 3D columns as CharType, it doesn’t work…
How weird because I only want to change the charType…

[balupad14 (Balamurugan)]

Hi @lulu75,

Let me check and ping you!!

[balupad14 (Balamurugan)]

Hi @lulu75,

Here is the output …

I am doing lot of changes in the graph. I have attached the pre release one. I have attached the actual one which is in here.

Can we create bar graphs and charts from excel data in UiPath?

Hi @lulu75, Download the package from this link. https://forum.uipath.com/uploads/short-url/pW0lzbZkyg9sEl3aWPDE6ayPmSu.nupkg Configure it as mentioned in the below video. and install the package… Regards Balamurugan.S

Regards
Balamurugan.S

[yogesh.sharma]

Thanks @Palaniyappan for your such helpful answers. I have created the chart using Invoke VBA. Now I want the chart to be displayed at a particular location in the sheet i.e H2 onwards.How can I do that. Thanks in advance for your time.

[sri24 (sri)]

Hi,
we can create excel charts using “Insert Excel chart” of StudioX in the UiPath Studio.

Then , inside the use excel of studiox,

My sheetname is “nasik”, so excel.sheet.item(“nasik”).

excel sheet output

Thanks

[ALig (Anthony)]

This was so helpful. Thank you!

[ydash999 (Yashobanta Dash)]

Balareva activities are great and useful! thank you very much to create sir!