Find Jobs
Hire Freelancers

Develop an Excel Macro to print charts to separate sheets from a large data set

$30-250 USD

In Progress
Posted about 4 years ago

$30-250 USD

Paid on delivery
I produce a spreed-sheet each day that contains one tab and withing that tab the data consists of 40 columns and thousands of lines. From this I manually generate a few charts to visualize the data. I would like you to develope a Excel Macro to produce charts for all the useful data in this and all future files. (Part 1) If you deliver the first part then Part 2 will to make some calculations on the data and summarize these in a dashboard. This is a simple task for a experienced Excel user. So please do not over quote on the price Due to the time difference please only apply if you are a resident of the USA or Europe
Project ID: 24058955

About the project

36 proposals
Remote project
Active 4 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
36 freelancers are bidding on average $136 USD for this job
User Avatar
Hello, I can help you with your project - Develop an Excel Macro to print charts to separate sheets from a large data set I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep
$150 USD in 3 days
4.9 (525 reviews)
8.4
8.4
User Avatar
Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have an Excel application that will generate charts from a given set of data. I plan to use a combination of formulas and VBA code to accomplish this. The Excel file will run on PCs. I will charge you $150* and can deliver within five days (we can discuss the milestones, I don't require any payment in front). I'm among the most experienced and skilled Excel and VBA developers on this platform. In particular, I am in the top 2% of the freelancers having completed over 360 projects successfully in less than 7 years, and I feel confident in achieving your task as well. I'm online from 7 am to 9 pm, Athens time (including weekends). I'm looking forward to working with you. Sincerely, Paris Pallas *My quote is indicative and may change after we discuss the tasks needed in detail.
$150 USD in 5 days
5.0 (524 reviews)
8.5
8.5
User Avatar
Hello, I am an Excel/VBA expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
$150 USD in 3 days
5.0 (492 reviews)
8.0
8.0
User Avatar
Hi, Keen to work on this project. I will align my work timings to your timezone so that you do not have any issues with communication. I am well versed with writing macros in Excel, Word etc.. I have used written macros extensively for Excel, MS Word, PowerPoint etc. for automation of various tasks. I have done good amount of work in Excel macro handling. It includes, extracting information from text files, transferring info in to excel, E-commerce templates, sending email through Outlook, Image handling, Shapes variation, Pivot Tables, Data Scrapping from websites, data extraction for multiple Excel sheets and consolidating in a central sheet.etc.I have also handled various Excel tasks. It includes creation of formulas using arrays, Pivot table creation, Creation of graphs, Filtering, Removing duplicates, Data analysis, Data entry works, etc. I have more than 15 years of experience to my credit. would be happy to answer any queries that you may have. Looking forward to working with you. Thanks
$125 USD in 3 days
4.9 (194 reviews)
6.8
6.8
User Avatar
$39 Only ----- In just 5 Hours ----- Sir, i can build your VBA Macro program to analysis the data automatically as chart and graph ----- Excel VBA Macro Coding, Formula Generation and Automation process expert ------ I can work on your time sir, so time difference will not be a problem ----- i can start right now, please message me to discuss more.
$39 USD in 1 day
5.0 (382 reviews)
6.8
6.8
User Avatar
Hi, Would you like to see a quick demo of your Excel macro developed to produce charts and visualize data from a large data set before you award the project? You can consider it professionally done in less than 24 hrs. Rather than fill this proposal with a list of qualifications, I want to complete a part of this project as a proof of concept before you award this project. This is so that you can be confident of the hands you will entrust this task. If you are satisfied with the result, you can go ahead and award the project. I’d love to discuss more on what would make this project a success for you. Can we have a quick chat? Thanks for your time
$150 USD in 5 days
4.9 (68 reviews)
6.9
6.9
User Avatar
Hi, I have understand the project requirement & interested to work for this project. I will start right now and I will do it within your time . Please send a message so we can discuss more & start the project. Thanks
$70 USD in 1 day
4.9 (267 reviews)
6.8
6.8
User Avatar
Hey, Could you share a sample file please and the details of the charts you want to be built? I would then be able to add macros to your file to build the charts as required. If all goes well (and I am sure it will) as per your liking we may then take up the part 2 of the project. Look forward to hear from you. Best Regards, Rishi (Automyze Consulting)
$140 USD in 7 days
4.9 (125 reviews)
6.7
6.7
User Avatar
*** I AM EXPERT IN EXCEL MACRO *** Dear, I checked your project description, and I confirm I can develop your macro. Please give me more details about your project. I will focus on user friendly interface. As you can see I have very good rate, you can be sure I am serious. Regards, Fabrice
$80 USD in 5 days
4.7 (65 reviews)
7.1
7.1
User Avatar
1. I am an expert in Excel, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. I read your project description and I am sure that I can handle your project. 2. Have done many projects in Excel, created many dashboards, and Business intelligence tool for forex markets. Experienced MBA Finance as well. 3. Your project will be delivered on time with high standard 4. Assistance will be provided with number of clarifications until client satisfaction
$150 USD in 3 days
4.7 (87 reviews)
6.2
6.2
User Avatar
Hi, I can develop a macro to print your chart into separate sheet and maintain large data set. I am experienced Data Analyst and Macro Developer and have done many similar projects. So, I can do this job nicely. Ready to start please message me to discuss your project in more details. Thanks, Virendra
$75 USD in 3 days
4.8 (139 reviews)
6.1
6.1
User Avatar
Hi I've read your proposal making auto charts in Excel. If you can use ms access I advise you- better to solve it via ms access. I can detail in private chat. Regards, Zurab- Ms access/excel/vba developer
$250 USD in 7 days
4.8 (46 reviews)
6.2
6.2
User Avatar
Hi, I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. In my approach you'll have an opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. I have great experience in any kind of data manipulation with Excel/VBA. I am a full-time freelancer, I can start working on the project immediately and complete the first part of the job within some hours and the second part within one, maybe two days. If you send me a sample file and a job specification, I'm ready to create a free draft pilot for you. Regards
$70 USD in 3 days
4.9 (64 reviews)
5.7
5.7
User Avatar
Hi Good Day! I did Financial and Metrics Dashboard for my previous project! A serious freelancer here. I can create you a Excel tool that will generate your charts automatically using VBA Macro. Message me to show you sample of my works before. I am from the Philippines by I usually work using US Timezone. I created tool like this before. Please consider my bid. I am a Project Management officer for 8 years in Accenture and Project Manager now in Appen Philippines. I do financial reports and budget forecasting for our Clients. I have all the ability to help you. Please consider my bid. I also done a lot of Reports and Templates using MS Excel. I can use my expertise in VBA Macro do it quickly and accurately. Message me anytime to discuss. With my experience as a VBA Macro developer for 8 years I can give you the high quality tool that can generate accurate result that you wanted using MS Excel. Please message me anytime to discuss more about this project. I am willing to help you out and show you my expertise. Thank you!
$50 USD in 2 days
4.7 (77 reviews)
5.4
5.4
User Avatar
I can do the job And I can start right away! I'm on time zone UTC-3.00. I have a lot of experience in chart automation and very large data set handling. Also, is in the future you wish to add or migrate to python I can do it as well. About me: I'm an engineer with advanced working knowledge and experience (over 15 years) in Microsoft Excel and VBA including interaction between different software (Word, Excel, Powerpoint, Access, Outlook, MS Project,MS Visio, Autocad, pdf, CorelDraw, PhotoShop, etc.). Also on web scraping, Access DB design, management Dashboards, stock and financial worksheets, KPI's, proficient coder in VB.Net, C#, Python, JavaScript (google sheets), VB6, AI (neural networks, genetic algorithms, optimized search, etc).
$200 USD in 6 days
5.0 (47 reviews)
5.4
5.4
User Avatar
Hello I am very interesting to work on your project I can build your dashboard and structure the database file in professional structure by using advance formulas and tools without using macro to be more easy in update and understand by your self and not need to return here to maintenance any macro error or modify in future so I provide you also supported technical and I try to learn you how this excel file work Appreciate your contact and your quick visit on my profile and see a lot of previous projects especially in dashboard and previous clients satisfactions reviews
$250 USD in 7 days
5.0 (24 reviews)
5.0
5.0
User Avatar
Hi there I have very good experience working with XL and creating VBA macros to get the correct results from the spreadsheet. I can get one done for you to create charts from the data you provide in separate sheets. Regards Reuben
$133 USD in 1 day
5.0 (25 reviews)
5.1
5.1
User Avatar
Hello, I am happy to inform you that I have read your current project description and understood all of your required requirements. I'd like to help you with confidence and satisfying results. I have professional working here with 100% results and more creative and innovative ideas for our clients. I've worked on several similar projects before. I'm offering my services for more than five years in the field of Excel, Internet Research, Leads, Research, Web Search. I have a team with eight members. They can get the required data manually from the website. If you need the data to be scrapped then also I can do scrapping and put them into an excel sheet. I am very responsible for my clients and I can complete the task within time with cent percent accuracy. Regards https://www.freelancer.com/u/Servicehour24 Servicehour24
$50 USD in 2 days
4.9 (7 reviews)
4.6
4.6
User Avatar
Hi. nice to meet you. I am expert desktop programming like c++, c#, java, QT. And also I am good at VBA, python, Delphi, etc. Already I have carried out many projects for Clients. I have received Five Stars and Good Reviews. Please award me. I will do my BEST for you. Thanks.
$50 USD in 3 days
5.0 (7 reviews)
3.6
3.6
User Avatar
Greetings, Through the most part of my 35+ years career, I have used Excel extensively to manage the programs / projects / actions and the reporting requirements. Normalized/cleaned up lot of data, collected from various sources and made it easily usable using Excel. Provided numerous solutions using Excel in the area of Budgets, Actuals, Revenue Projection, Billing, Gross margins, Project Estimates / Plan / Monitoring / Reporting, Performance Assessments, Resource Management, Timesheets etc. These required me to use lot of functions & formulas and very innovative Pivot table features. Keen to take up this assignment as I love working with Excel. Please refer to my portfolio "Excel Pivots and Charts". With this Bid Amount, I commit 4 hour of support. If the assignment gets over before that, we can use the remaining time for any other tasks you have. My proposal would be to different: - We create all the required charts as a dashboard - You copy/append the data you generate every day into the this template - Select the day from the Slicer and graphs will get refreshed - With this you can store the data for a period in single place - We can trend analysis using this data I do not suggest macros when better alternates are available if proposed terms are the problem, we can discuss the same. Thank you for taking the time to read my proposal. Warm Regards
$100 USD in 2 days
5.0 (3 reviews)
2.6
2.6

About the client

Flag of UNITED KINGDOM
Lydbury North, United Kingdom
4.6
8
Payment method verified
Member since Dec 29, 2015

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.