Transform your data into compelling visual representations, saving time and effort while delivering impactful insights.

Automated Charting and Graphing

dbc9e3a0-347a-40ba-add1-07742175fb07.jpg

RPA Solution Architect Maker & Senior RPA Consultant

374200e6-d2ff-4b87-b6f1-c2adecb5604c.nupkg

This custom activity automates the creation of charts inside an Excel sheet.

  

**Properties:**

  

1\. **Cell Range** - Specify the data range for the Excel sheet.

2\. **Chart Title** - Title for the chart.

3\. **Chart Type** - Supports 26 chart types.

4\. **File Path** - Excel file full path.

5. **Image Copy** – Specify the path where the chart has to be saved as an image.

6\. **AutoText** \- Automatically generates appropriate text based on content.

7\. **DataLabelsType** - \[ShowNone, ShowValue,ShowPercent,ShowLabel, ShowLabelAndPercent, ShowBubbleSizes\].

8\. **Had Lead lines** - if the series has leader lines.

9\. **Legend Key** - Show the legend key next to the point.

10\. **Separator** \- The separator for the data label.

11\. **Show Bubble Size** \- The bubble size for the data label.

12\. **Show Category Name** - The category name for the data label.

13\. **Show Legend** - True to show the legend to the chart.

14\. **Show Percentage** \- The percentage for the data label.

15\. **Show Series Name** \- The series name for the data label.

16\. **Show Value** \- The value for the data label.

17\. **Sheet Name** - Excel book’s sheet name where the data exists.

18\. **Size** \- Height, left, top and width are for the position and size of the image.

By using this activity you can create Pie, Column, Line and Bar graphs.

ecc0a3ca-d6be-47a1-9508-7075de04eb06.png

54c35be7-3591-41b5-8afb-79cf24dae550.png

0271238f-2c6c-494f-93bc-80a7af56cb91.png

MIT License Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the 'Software'), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions: The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED 'AS IS', WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.

Visual Basic

cc94fb41-719c-4e13-86df-51cfd380f41c.docx

7721b0dc-7dd9-485b-b849-e2e94c0d8b9b.docx

cef8ffcb-c8f0-477e-816e-039dc9763bd3.zip

93f6c29e-ca93-4c39-aa21-9faeb2a75138.nupkg

A single activity can able create multiple charts like (Pie,Column,Line and Bar graph)

Using this activity can create the Pie,Column,Line and Bar graph.

Version	Release Date	Download Link
2.0.1	October 24, 2018
1.0.0 - Custom Activities called Pie, Column, Line and Bar graphs. 2.0.0 - Combined all activities into a single activity. 2.0.1 - Provision for Modified Password.
2.0.0	September 28, 2018
1.0.0- Custom Activities called Pie,Column,Line and Bar graph. 2.0.0- Combined all activities into a single activity

Graph Activities for Microsoft Excel Charts