Đã Hủy

VBA code modification for Excel macro

Freelancer "Autocreatecharts" Macro code editing objectives:

The autocreatecharts macro in the workbook currently creates a doughnut chart for every row of data. I need this modified to meet the requirements below. An example of the desired chart design are on the "example charts" sheet and need to apply to each row of data on "Sheet1" and "Sheet3" for the first chart, followed by a second chart in bar format for data on "Sheet4".

1) The above macro in the workbook should create two charts. The first generated for "Sheet1" data needs to have a rounded rectangle shape added, positioned above the doughnut chart plot area (not overlapping as it currently does), and below the chart title and additional text Boxes. (please notate code to point to positioning parameters for later customization)

1a) Chart area sizes for both charts need to fill the size of a powerpoint slide so that each chard takes up a slide I will be using a separate macro to export all charts generated to a powerpoint slide. (please notate code to point to size parameters for later customization)

1b) Chart picture shape must fill with picture using a cell value from "Sheet3" "Pic" column on corresponding row. This will be intended to be different for each chart based on "Pic" cell contents.

1c) A second shape area shows at the top right of the first user chart generated. It is a black filled round rectangle with a fixed picture inserted over it (this pic will be same for all main charts). This can also be a picture fill depending on how you determine it is best for coding. There are three text boxes that copy the cell data and formatting for the corresponding chart data from "Sheet1". See example.

2) Additional text boxes on each user's main chart (other than Title) should be added to the top left chart area above the picture shape just below the title and must display the Company name, Employee ID column label, Employee ID, Job Description, and location from the corresponding row in "Sheet3".

3) An extra bar chart needs to be generated directly after the main chart above from "sheet4". So, there should be two charts for each name.

3a) The bar chart needs to have no legend title/area, no title, and no gridlines - just the axis data labels.

3b) This bar chart also needs to fill the size of a powerpoint slide. (please notate code to show size parameters for later customization)

Font Size overall (Calibri Type): Larger fonts are 20 pt., smaller fonts are 16pt., and legend lables/axis labels show as 10pt. As shown, most fonts are in white (except the "stats" area which should match cell data and format. (please notate code to show parameters for later customization). Chart areas need to be transparent. The border should be a light line as shown in the example.

Please do not hesitate to contact me for clarification and questions.

Kỹ năng: Nhập liệu, Xử lí dữ liệu, Excel, Visual Basic, Visual Basic cho Ứng dụng

Xem thêm: how to run vba code in excel automatically, vba code examples, useful vba codes for excel, excel vba add code to worksheet programmatically, how to view code in excel, insert module excel 2013, excel vba module vs sheet, run vba code in excel, best excel macro freelancer bangalore, vba code addition excel, vba code complete excel pdf, vba code backtesting excel, data work job freelancer best job, convert vba code add excel, vba code convert excel html

Về Bên Thuê:
( 0 nhận xét ) India

Mã Dự Án: #15818862

9 freelancer đang chào giá trung bình ₹8589 cho công việc này

₹10000 INR trong 2 ngày
(262 Đánh Giá)
7.7
schoudhary1553

Greetings sir, i can help you and your 100% satisfaction is assured if you allow me to serve. I can do this task as per your requirement Relevant Skills and Experience I have more than 5 years of experience with exce Thêm

₹10000 INR trong 3 ngày
(218 Đánh Giá)
7.3
abhinovpankaj

I have been working as freelancer since last ~ 5 years,prior to this was working with a MNC as an Sr. Software Professional. Relevant Skills and Experience -- VBA and Excel,Word,Office Applications -- Expert on C# Thêm

₹9444 INR trong 4 ngày
(51 Đánh Giá)
5.5
₹7777 INR trong 3 ngày
(0 Đánh Giá)
0.0
clamina

I'll modify your macro to do what you've required, if you're interested in my offer we will discuss the details. Relevant Skills and Experience I'm a consultant, I work every day with excel, macro or graphs Proposed Thêm

₹5555 INR trong 3 ngày
(0 Đánh Giá)
0.0
classicsoftsl

I am an excel expert in macros and VBA. I can do your project in time and as per specifcations Relevant Skills and Experience I have automated lot of process of International Banks in India like Barclays, Bank of Amer Thêm

₹12222 INR trong 5 ngày
(0 Đánh Giá)
0.0
dinhfreedom

--Very Nice Job. Professional VBA & VB & C++ expert. Best result in time----- Relevant Skills and Experience [url removed, login to view] I am very interesting for your project because I have rich experiences and also have been working Thêm

₹12777 INR trong 1 ngày
(0 Đánh Giá)
0.0
Proshanto71

Dear sir, I am a student. I am interested for your job.

₹1750 INR trong 3 ngày
(0 Đánh Giá)
0.0
ranggon92

I am interested to do the work. Relevant Skills and Experience let's do,the work.

₹7777 INR trong 3 ngày
(0 Đánh Giá)
0.0