16. RPA Challenge - Create PieChart From Excel File

Random and other categories RPA Challenge
24

Hi Avanish,
Please Share Your .Xmal File ?

25

It is now in my earlier answer. Uploading again here.MakeChart.xaml (14.9 KB)

~RPA Ninja

1 Like
26

Can U Please Upload Code For Barchart ?

27

hi @kirtiSagar

In the same code you can use send hot key as Alt+N+B+enter

Thanks
Ashwin S

28

Want VB Code For This ?

29

hi @kirtiSagar

Use the below code and mention the range
Sub BarchartMethod()

Dim rng As Range
Dim cht As Object

'Your data range for the chart
Set rng = ActiveSheet.Range(“A24:M27”)

'Create a chart
Set cht = ActiveSheet.Shapes.AddChart2

'Give chart some data
cht.Chart.SetSourceData Source:=rng

'Determine the chart type
cht.Chart.ChartType = xlXYScatterLines

End Sub
Thanks
Ashwin S

1 Like
30

Hi Folks,

I used simply sequence.
I wish to write one day a proces with invoked code. @vvaidya this is cool!

Gosia
16. RPA Challenge.zip (493.4 KB)

31

Hi Rammohan,

I am trying to test your activity and I get the error below:

Screenshot_264
Screenshot_264681×537 22.5 KB

What am I doing wrong? It seems to be a problem with Excel. I have Office 2016 installed. Do you think it has something to do with Office version?

Thanks,
Viorela

32

Hi Avanish,

Can you please try to upload now?

33

Hi Kirti and Ovi,
Please find the solution and let me know for any difficulty in it.
test_Graph.xaml (17.7 KB)
Book1.xlsx (8.5 KB)
final_data.xlsx (9.0 KB)

2 Likes
34

Hi @kirtiSagar,
sorry for this late response, but as they say, better late than never :wink: Here is a simple solution in three activitiesPie Chart.xaml (7 KB)
:

  1. selecting the range,
  2. selecting a pie chart to be created,
  3. saving the file.
35
36

Hi @ovi and @badita

I have create a custom activity to generate the Pie chart for the excel file data.

I would be happy to get more suggestions .

Regards
Balamurugan

1 Like
37

Hi @kirtiSagar

I have developed a package for your challenge that I have attached it above with your example. Is this solution that you expected…

Thank
Balamurugan

38

Bump :slight_smile: :smile:

1 Like
39

Very simple:
Go to excel workbook and do the following:

  1. Open a blank workbook in Excel .
  2. Go to File > Options > Trust Center.
  3. Click on Trust Center Settings…
  4. Under Macro Settings, make sure Trust access to the VBA project object model is checked.

Download the following zip : Easyupload.io - Upload files for free and transfer big files easily. ( new users can not upload files therefore I uploaded this file for you ) .

Place excel file and vba script under : C\Excel
Create new sequence as you see in picture attached ( inside the zip)

Click play and N-Joy

Don’t need any new packages .
@admins please mark this challenge as completed :slight_smile:

40

@badita please mark this discussion as completed :slight_smile:

41

Dear KirtiRanjan Sahoo,

The easiest way to create a pie chart from Excel data is given below:

Steps:

  1. Enable Trust access to the VBA project object model

    image
    image995×475 20.6 KB

  2. In your Main Workflow, invoke VBA code for making a Pie Chart.

image
image677×529 7.19 KB

  1. VBA code for generating a simple Pie Chart is given

image
image1920×1080 185 KB

Before/After:

image
image1630×440 37 KB

For reference, please find the workflow as attached.

PieChartFromExcel.zip (33.5 KB)

2 Likes
42

Excellent Statement! I’ve been almost trying to explain this to others around me about the difference between RPA and traditional coding and automation.

:slight_smile:

43

Felt the need to post a video of my solution following my last post to this thread. This solution tries to demonstrate how RPA processes distinguish themselves from traditional backend counterparts by focusing on imitating user actions first.

When I present code-heavy solutions during my Demos, one question I have been asked is why would we need to use RPA if I have to write code? What’s the difference?

In addition, such a solution becomes less easier to relate to front-line business users.

But it is true that not all problems can be solved by user actions alone. Some things will require code-behind solutions. But my lesson learnt is that we have to focus on designing better Human-Bot interfaces by focusing on human impersonation first and then going the way of code next.

My Demo Video from the RPA Vanguard Channel. Due credit has been give in the description to @kirtiSagar in the description for posting the original challenge question. :+1: