Bar Chart Implementaion in Uipath

[AshwinS2 (Ashwin S)]

Hi Team

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

Thanks
Ashwin S

[indra]

@AshwinS2 I think by using Execute macros we can implement

[AshwinS2 (Ashwin S)]

hi @indra

Other than macro is there any way ??

Thanks
Ashwin S

[indra]

@AshwinS2 I am not sure lets see others reply

[Pankaj.Patil (Robot Master)]

Hello @AshwinS2,

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

How to Make a Bar Graph in Excel (Clustered & Stacked Charts)

How to Make a Bar Graph in Excel: 9 Steps (with Pictures)

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

Thanks,
Pankaj

[AshwinS2 (Ashwin S)]

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

[Pankaj.Patil (Robot Master)]

Hello @AshwinS2,

We’ll have to do recording in uipath.

Thanks,
Pankaj

[AshwinS2 (Ashwin S)]

Hi @Pankaj.Patil

You mean to say open the excel and do the manipulations

Thanks
Ashwin S

[Pankaj.Patil (Robot Master)]

@AshwinS2

You mean to say open the excel and do the manipulations

Yes, you’re right Ashwin

Thanks,
Pankaj

[balupad14 (Balamurugan)]

Hi @AshwinS2,

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

BalaReva.Excel.Activities

Hi Friends, I have created a new custom component to generate the pie chart for the excel data. Below I have attached sample with output. Name Space : [image] Properties : [image] Sample File :ExcelChartSample.zip (77.1 KB) The out put is. Bar Chart [image] Column Chart [image] Line Chart [image] Bar Chart [image] Let me if you have any errors. I would be happy to get more suggestions . Note : To Know that how to add the Gallery Package into Studio. Please check it below. …

Regards
Balamurugan.S

[Atul_Rai]

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.

[balupad14 (Balamurugan)]

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

[Atul_Rai]

Thanks @balupad14

can you help me with pie chart?

[balupad14 (Balamurugan)]

Hi @Atul_Rai,

I will attach the sample very soon.

Regards
BalaReva

[Atul_Rai]

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

[Atul_Rai]

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 :


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.

[balupad14 (Balamurugan)]

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.

Thank you
Balamurugan.S

[Atul_Rai]

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

[Atul_Rai]

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


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

[balupad14 (Balamurugan)]

Yes . It is normal behaviour of pie chart.

Regards

Balareva