Bar Chart Implementaion in Uipath

Hello @AshwinS2,

I found below links to make bar chart/graph in excel.

I did not make any example. if you wish me to create any example. I’ll be happy to assist you.

Thanks,
Pankaj

Hi @Pankaj.Patil

In uipayh they haven’t implement pivot bar charts for Excel in uipayh we Need like custom activity or something to do

Thanks
Ashwin.S

Hello @AshwinS2,

We’ll have to do recording in uipath.

Thanks,
Pankaj

Hi @Pankaj.Patil

You mean to say open the excel and do the manipulations :smile:

Thanks
Ashwin S

Yes, you’re right Ashwin

Thanks,
Pankaj

Hi @AshwinS2,

I have developed a Custom activities for the excel graph. I will very helpful to you

Regards
Balamurugan.S

Hello @balupad14

I have installed the mentioned activity but unable to view it. The error is
“Could not find member ‘LedgendKey’ in type ‘BalaReva.Excel.Charts.ShowOptions’. Row: 59, Column: 94” and
“Could not find member ‘ShowLedgend’ in type ‘BalaReva.Excel.Charts.ShowOptions’. Row: 59, Column: 177”

Can you help me to resolve this error? I am using version 2018.4.1

I tried to use the activity by creating a workflow but the graph is not generated. Can you tell me the important parameters to create the graph.

Hi @Atul_Rai,
The above one sample was developed in Version 2018.2. Here I have attached the sample for the latest version.

BarChart.zip (31 KB)

Regards
BalaReva

Thanks @balupad14

can you help me with pie chart?

Hi @Atul_Rai,

I will attach the sample very soon.

Regards
BalaReva

1 Like

Sure. I want to create a pie chart for year and file size.
example.
2015 5gb
2016 85gb
2017 8gb

and so on.

Regards
Atul

1 Like

Hi @balupad14

I have tried to create the pie chart and getting a problem. I have data in given format

Total Size Year
87.02 2016
11.04 2017
15 2018
The created pie chart is :
![image 334x334](upload://t82wPm2yoTpi2NctWFA5PHyssQj.png)

Instead of Legend entries as 1,2 and 3 I want to show the year like 2016,2017,2018. I have tried a lot but unable to do so. Can you please help me with this part.

Hi @Atul_Rai,

Yes you are right. Have to give a provision to set the category Axis Labels as in the below image. I will do the change in the activity and update it.

Thank you for your feedback.

image

Thank you
Balamurugan.S

1 Like

Thanks @balupad14
I hope you will add it soon. It is the last step of my current project.

Hi @balupad14
I have found one more thing. For a single row data like

Total Size Year
87.02 2016
The created pie chart is
![image 334x334](upload://pctyJlYzgk4GXp5X0gaPnxpM8wK.png)

is it the expected behaviour? I think it is not the correct chart.

Yes . It is normal behaviour of pie chart.

Regards

Balareva

Thanks @balupad14 for the confirmation.:slightly_smiling_face:

Hi @Atul_Rai,

I have added new property called “Legend Range”. Here you can specify the legend range.

Important things. Now we are not able to update the package in the UiPath Gallery. The upload package option has been blocked. Because UiPath is moving everything is to UiPath Go,

Here I have attached the package. you can use it at local.

Package:
PieChart004.1.0.0.zip (38.6 KB)

Sample Project:
Piechart.zip (9.2 KB)

Output:

image

Regards
BalaReva

1 Like

Thanks @balupad14
I really appreciate your work.

1 Like

Hi.
I am creating the bar graph. But cell range is not fixed. How I can set cell range dynamicall