Hi Team
Is there any way of creating a bar chart for excel in Uipath
Thanks
Ashwin S
Hi Team
Is there any way of creating a bar chart for excel in Uipath
Thanks
Ashwin S
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
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
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
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
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.
Thank you
Balamurugan.S
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