Please Share Your .Xmal File ?
It is now in my earlier answer. Uploading again here.MakeChart.xaml (14.9 KB)
Can U Please Upload Code For Barchart ?
In the same code you can use send hot key as Alt+N+B+enter
Want VB Code For This ?
Use the below code and mention the range
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
'Determine the chart type
cht.Chart.ChartType = xlXYScatterLines
I used simply sequence.
I wish to write one day a proces with invoked code. @vvaidya this is cool!
16. RPA Challenge.zip (493.4 KB)
I am trying to test your activity and I get the error below:
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?
Can you please try to upload now?
- selecting the range,
- selecting a pie chart to be created,
- saving the file.
I have create a custom activity to generate the Pie chart for the excel file data.
I would be happy to get more suggestions .
I have developed a package for your challenge that I have attached it above with your example. Is this solution that you expected…
Go to excel workbook and do the following:
- Open a blank workbook in Excel .
- Go to File > Options > Trust Center.
- Click on Trust Center Settings…
- 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
@badita please mark this discussion as completed
Dear KirtiRanjan Sahoo,
The easiest way to create a pie chart from Excel data is given below:
Enable Trust access to the VBA project object model
In your Main Workflow, invoke VBA code for making a Pie Chart.
- VBA code for generating a simple Pie Chart is given
For reference, please find the workflow as attached.
PieChartFromExcel.zip (33.5 KB)
Excellent Statement! I’ve been almost trying to explain this to others around me about the difference between RPA and traditional coding and automation.