VBA Excel Dynamic Charts

$30-250 USD

完了済み

投稿日:

約4年前

$30-250 USD

完了時にお支払い

I am working on a project scheduling airline flights and delays and I am stuck. I want to add a chart that shows the performance of the day based on how many delays there were during that day. After that, I want another chart that shows the count of delays based on airline for the date you click on in the first chart. So the second chart is based on what you click in the first chart. Please look at the modules "CompareDatePerformance" , "CompareAirlineDelays" modules and FlightDate class module. The data is based on the "Sorted January 3 and 4" worksheet. The charts are in "Analysis". The data to populate the charts is in"Analysis Data". Basically, I want my code to count the amount of "predicted delay bool" for each day divided by the total amount of flights for that day (Performance = delayflights/totalflights). This data can be found in the Sorted Jan 3 and 4 worksheet under the O column. Then I want to populate this on a chart for each date, January 3, 4 and ,5. Then when a user clicks on one of these days in the chart, it populates the second chart with the count of delays for each airline in that day. I tried to start the code in the CompareAirlineDelays module and the CompareDatePerformance module.

Excel

Visual Basic

Visual Basic for Apps

Data Processing

Software Architecture

プロジェクト ID: 24756544

プロジェクトについて

35個の提案

リモートプロジェクト

アクティブ 4年前

お金を稼ぎたいですか？

メールアドレス

Freelancerで入札する利点

予算と期間を設定してください

仕事で報酬を得る

提案をご説明ください

登録して仕事に入札するのは無料です

アワード者:

@Sercho56

Hi, I am an Australian-based software developer with significant experience in developing customised solutions in Excel VBA. I have worked with interactive charts a lot, and use them everyday in my own personal finance management workbook. I can easily create the required interaction, although...it will require a slight re-organisation of your workbook. The chart that shows the performance on the day (the chart you wish to add) will need to be a Chart Sheet, rather than an embedded chart in a normal worksheet. This will enable the VBA interactions that you want available to generate the second chart based on what data point is selected. If you wish to discuss the details of this job, please feel free to reach out via PM.

$60 USD 2日以内

5.0

(40 レビュー)

6.1

この仕事に35人のフリーランサーが、平均$131 USDで入札しています

@schoudhary1553

I can help you with your project - VBA Excel Dynamic Charts 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

$220 USD 4日以内

4.9

(474 レビュー)

8.4

@cgullapalli

HI, I am good at Excel and VBA. I have referred the file. I would like to discuss in detail the specific click on the charts. Looking forward to discussing it further in the chat. If you want to link one chart to another chart, then Power BI may be a better option. -Chandra

$150 USD 2日以内

5.0

(1037 レビュー)

8.2

@elqueabandona

Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 260 projects successfully completed here. I am available to create these 2 charts that you need quickly and efficiently. Contact me to discuss the details. Best regards

$150 USD 1日以内

5.0

(314 レビュー)

7.4

@george1205

Hi there I have enough experience with excel vba macros Let's have a detailed chat about your project I think these modules were not completed yet. CompareAirlineDelays module and the CompareDatePerformance module. Looking forward to your response. Thank you George.

$250 USD 1日以内

4.9

(21 レビュー)

6.9

@periyannas

Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered over hundred and twenty five excel vba projects in couple of years. Read your project description. Will dwelve into it upon your interest in me. Willing and looking forward to working with you. Thank you, Regards.

$200 USD 3日以内

5.0

(166 レビュー)

6.9

@finecodervw

Hi, Keen to work on this project. Let me introduce myself as an expert VBA programmer. I have used VBA extensively for Excel, MS Word, MS PowerPoint, MS Outlook automation. I have done good amount of work in VBA. It includes, extracting information from text files, transferring info in to excel, E-commerce templates, Google maps, sending email through Outlook, Image handling, Userforms, 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. I would be happy to answer any queries that you may have. Looking forward to working with you. Thanks

$135 USD 5日以内

4.9

(223 レビュー)

6.8

@seoguru17

I am good at Excel formula and VBA/Macro, I need to see the data so I can understand your requirement, I have a few question to discuss so I need you to send a message on chat.

$140 USD 7日以内

4.6

(87 レビュー)

6.7

@usmanhassan123

I am MBA accounts and finance, Mphill in computer science and having seven years of experience in Excel (vba & macro's) development. I already done many projects of: • Excel Automation. • Excel Reports system. • KPI Dashboards. • Excel financial models. • Power Bi dashboards. • Data cleaning & filtration. • Excel dashboard designing. • Excel Solver. • Excel Optimization. • Email scraping. • Outlook. • Microsoft Access. • Excel calculators. • Excel vba. • Excel Tracker. • Mail merging. • Excel macro's. • Excel Inventory system. • word macro's. I have ability to do your project within your deadline, I need some discussion to make the things clear. Thanks.

$200 USD 3日以内

4.7

(99 レビュー)

6.6

@younus15

Hello there! I can do your project without using VBA, It works? I can do your project in less than 24 hours according to your description with the highest precision and quality. I would like to complete your project without error and with a full delivery. I have extensive experience in your project.

$200 USD 1日以内

4.9

(157 レビュー)

6.4

@vsprybhanu

Hi, I can develop new module or complete the modules what you have started. I have read your instructions carefully and saw attached file. 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

$250 USD 3日以内

4.8

(116 レビュー)

6.0

@rIbrarahmed

hi, I am very good in Excel vba, macro, chart etc. if you want to see my excel skills i can share with you some of my work on excel. I understand the value of deadline and do not compromise on quality. I feel fit myself for this project. please contact with me. Thanks.

$40 USD 1日以内

4.9

(35 レビュー)

5.3

@Fespinosa17

Hi. I can do this project. I have read proposal and I am ready to start. Please hie me. Regards, Fabian.

$100 USD 2日以内

4.9

(27 レビュー)

5.0

@Jatin77777

Hello, I have gone through the mentioned project details and delivered servals similar projects. I have created multiple dynamic Dashboards with value ads and provide vital insights with graphical representation. I have a good experience in data mining, being a part of Reporting & Analytics team in MNC. I have considered all the micro level aspects before start analysis. Created Dashboards were highly recommended and useful. I have used Advance level Excel functions with VBA coding to make it concise and more informative for our client. I have a good knowledge in Excel, Advance Excel functions and VBA. I know Sumifs, Countifs, Averageifs, Index, Match, Vlookup, Hlookup, Pivot table, Slicers, Developer functions & Conditional formatting etc. Its relevant work and would request you to give me a chance to provide insights on available task. I have created multiple dashboards for my clients. Feel free to contact me for further step. Thanks, Jitender Kumar

$200 USD 2日以内

5.0

(24 レビュー)

4.7

@yadavexpert53

Greetings! I’m highly skilled in MS Excel (data sorting, tables, pivot tables, charts, formulas, scenario analysis, goal seek etc.) & Macros. I think I’m suitable for this project because my skills are matching in this project. Thanks for sharing your requirements here at Freelancer.com. I’m Mohit. I will work for you at reasonable cost with quality work. I’ve extensive expertise in my profession. I am confident I can exceed your expectations. Please don't judge a book by its cover. For more information, please visit my profile. If you have any questions, you can contact me at chat section. Thanks, Mohit Babu Yadav. The Freelancer.com Freelancer

$30 USD 2日以内

4.9

(40 レビュー)

4.8

@nurnga1218

Hi, I think I can make it. But I need to ask some questions for you. I'm waiting for your chat. Thanks

$50 USD 2日以内

5.0

(46 レビュー)

4.8

@KellogITSolution

Hello I am working with MS-Excel and VBA for the past 15 years and have completed successfully many Excel projects. I am ready to do your work and have gone through your project specifications. Give me the job, get it done, satisfy yourself and then make payment. I wont seek any payment from my clients until the job is fully done as per their satisfaction. Customer satisfaction is much more important and our top most priority. No satisfaction no payment. Hope to hear positively from u. Regards John

$140 USD 7日以内

4.9

(23 レビュー)

4.7

@maguirrer

Hello, I can help You with the project and creating/updating the charts, please send me a message with more details and if it's possible with the file attached, so I can check it and Will start working on it immediately

$30 USD 4日以内

5.0

(40 レビュー)

4.4

@hayteekeys

Hi, I'm a professional and expert in Data works or projects..My skills and services include: - Web scraping - Data entry - Data mining - Data processing - Excel - MySQL - Oracle -Financial Analysis -Advanced Excel -MS Office -Python -PowerPointMacros -Automatioin -Automation tools -VBA -Excel and VBA automation - etc. A professional having more than 7 years of experience in financial modeling, VBA macros, MS Office automation with postgraduate degree, Worked in reputed organisations on senior level. I am expert in my field, who knows the value of time, very hard working and always delivers the work on time. I always deliver the work well in advance with continues communication & timely response until satisfactory completion of the project. I only accept the projects which I am sure can be done within the stipulated time frame and budget.. I always deliver 100% Satisfaction to the client. Hope my skill and work can help you with your business. i look forward to have further discussion with you in the chat. Thanks Regards ATEMENU.D

$30 USD 1日以内

4.2

(18 レビュー)

4.8

@RusselExpert

Hello. I have just checked your excel file. As a VBA expert, i am confident with this project. Please contact me. Thanks/

$150 USD 2日以内

5.0

(4 レビュー)

4.2

@cristiangoooo

I would like to help in your project, I have strong expertise in Excel (Dashboards, formulas, functions, graphs, pivot tables and more), I will be waiting for your comments. Regards, Cristian

$200 USD 3日以内