Bar Chart Implementaion in Uipath

Hi Team

Is there any way of creating a bar chart for excel in Uipath

Thanks
Ashwin S

@AshwinS2 I think by using Execute macros we can implement

hi @indra

Other than macro is there any way ?? :slight_smile:

Thanks
Ashwin S

@AshwinS2 I am not sure lets see others reply

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

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

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

Yes . It is normal behaviour of pie chart.

Regards

Balareva