En cours

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.

Compétences : Saisie de Données, Traitement de Données, Excel, Visual Basic, Visual Basic pour les apps

Voir plus : 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, vba word postmessage excel macro, vba code saving excel range image file, vba code predecessor excel gantt chart, share vba code update excel, excel macro work required job work, vba code insert excel cells access, vba code clock excel sheet, excel macro freelancer

Concernant l'employeur :
( 0 commentaires ) United States

N° du projet : #15815405

Décerné à :

TonmoyRoy111

Dear Client I have previously carried out a number of projects in excel using vba macro and formulas. I can do this task of charts creation. Kindly contact me. Roy

150 $ USD en 2 jours
(227 Commentaires)
6.3

13 freelance ont fait une offre moyenne de 135 $ pour ce travail

schoudhary1553

Greeting, I have understood your VBA code modification task and can do it with your 100% satisfaction. Please ping me for more discussion. Relevant Skills and Experience I have more than 5 years of experience in Dat Plus

150 $ USD en 2 jours
(219 Commentaires)
7.3
dpune

Update VBA macro based on the requirements Relevant Skills and Experience VBA/Macro Proposed Milestones $200 USD - Completed macro

200 $ USD en 7 jours
(180 Commentaires)
6.5
asin1987

Dear Employer, I will write VBA for you in no time. Please gve me a chance. Thanks!! Relevant Skills and Experience VBA MAcro EXcel Proposed Milestones $155 USD - Project

155 $ USD en 3 jours
(26 Commentaires)
5.5
osmemon

I have 7 years of experience in Excel and VBA with 100% client satisfaction history. I can modify and add code as per your requirement. see my profile for client reviews. Relevant Skills and Experience Excel VBA Prop Plus

155 $ USD en 0 jours
(30 Commentaires)
5.5
The24CarrotsInc

Greetings for the day!! We have experience working on this subject. We ensure 100% QUALITY with ON-TIME Deliveries. Please allow us to take this opportunity. Thanks & Regards, Team@The24CarrotsInc Relevant Skills an Plus

100 $ USD en 2 jours
(51 Commentaires)
5.2
insidenetsoft

Hello, I understand the importance of having the parameters for the sizes configurable in order to easily adjust them. I just finished a tool for an architect that was generating 120 graphs automatically based on som Plus

190 $ USD en 5 jours
(21 Commentaires)
4.0
mpunn2007

, Relevant Skills and Experience . Proposed Milestones $98 USD - ms

97 $ USD en 5 jours
(9 Commentaires)
3.1
vmadhavan15

I am not random bidder.. I hope I can do this one... I do not outsource to anyone... Please ping me if you are happy with my proposal and thank you.. Relevant Skills and Experience VBA Proposed Milestones $140 USD - Plus

140 $ USD en 5 jours
(6 Commentaires)
3.3
marieea786

A proposal has not yet been provided

35 $ USD en 1 jour
(4 Commentaires)
2.7
nelumindralal

Hello, I went thru the des. This can be done within 3 days Kindly msg me, I have things to discuss Today can start. Looking forward to hearing from you this is an interesting project Thanks Relevant Skills and Experi Plus

155 $ USD en 3 jours
(3 Commentaires)
1.9
vw6767981vw

Hello I'm [url removed, login to view] of infoSec with good knowledge in excel and macro. I will hope can help you to do your job. I'm ready to begin. Check my portfolio and my reviews. Relevant Skills and Experience Excel Vba Proposed Mil Plus

77 $ USD en 3 jours
(7 Commentaires)
2.2
esvfx

Dear Sir, I read your job description. I would like to apply as your project.I have 5 years experience. If you like to hire me. I am ready to do your project. Thanks Relevant Skills and Experience yes Proposed Mile Plus

155 $ USD en 3 jours
(0 Commentaires)
0.0