@AshwinS2 I am not sure lets see others reply
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.
In uipayh they haven’t implement pivot bar charts for Excel in uipayh we Need like custom activity or something to do
We’ll have to do recording in uipath.
You mean to say open the excel and do the manipulations
Yes, you’re right Ashwin
I have developed a Custom activities for the excel graph. I will very helpful to you
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.
The above one sample was developed in Version 2018.2. Here I have attached the sample for the latest version.
BarChart.zip (31 KB)
can you help me with pie chart?
I will attach the sample very soon.
Sure. I want to create a pie chart for year and file size.
and so on.
I have tried to create the pie chart and getting a problem. I have data in given format
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.
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.
I hope you will add it soon. It is the last step of my current project.
I have found one more thing. For a single row data like
The created pie chart is
is it the expected behaviour? I think it is not the correct chart.
Yes . It is normal behaviour of pie chart.
Thanks @balupad14 for the confirmation.
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.
PieChart004.1.0.0.zip (38.6 KB)
Piechart.zip (9.2 KB)
I really appreciate your work.