Charting in Excel using VBA

£20-250 GBP

Tamamlandı

İlan edilme:

yaklaşık 7 yıl önce

£20-250 GBP

Teslimde ödenir

I would like to use Excel VBA to display three different sets of data onto a chart, Daily, weekly and monthly. A button and macro is assigned to each. Then the button is clicked, a macro will run and display the data from the respective columns. A moving average is to be displayed, with the interval taken from a pre-determined cell within the sheet. Additonally, the macro will also add a horizontal line on the chart, using a value in a separate pre-determined cell, also on the same sheet. Both the MA and the line will be formatted with particular colours. I have created a requirements spreadsheet which clearly explains my requiremement in more detail. It also shows the structure of the three different types of data. The weekly and montly data have multile blank rows between data in cells. The data also grows daily, weekly, monthly, so the vba needs to handle this. I expect to have to click the buttons to refresh each chart view, which should always use all data in each of the columns. Please take the time to review this, and please ask me any clarification questions you wish.

Excel

Proje No: 13465083

Proje hakkında

21 teklif

Uzaktan proje

Son aktiviteden bu yana geçen zaman 7 yıl önce

Biraz para mı kazanmak istiyorsunuz?

E-posta adresi

Freelancer'da teklif vermenin faydaları

Bütçenizi ve zaman çerçevenizi belirleyin

Çalışmanız için ödeme alın

Teklifinizin ana hatlarını belirleyin

Kaydolmak ve işlere teklif vermek ücretsizdir

Seçilen:

@kolosibalint

Dear Sir/Madam, I have 4 years experience in Excel VBA programming working for companies like IBM, MSCI and Ford. I think your requirements are quite clear so I could start working on it immediately and come back with results by this time tomorrow. Regards, Balint Kolosi

£100 GBP 3 gün içinde

5,0

(121 değerlendirme)

7,0

21 freelancer bu proje için ortalama £131 GBP teklif veriyor

@cgullapalli

Hi, I am good at Excel Charts and building useful scripts for my clients. I just checked the description you have provided regarding the project and would be a pleasure to assist you on your project. I will work with full dedication to give you the best output within the desired timeframe. I look forward to hear from you. Looking forward to discuss in the chat and a long term relationship ahead. Wishing you a great day ahead. https://www.freelancer.com/u/cgullapalli.html#/profile-reviews Regards, Chandra

£100 GBP 1 gün içinde

5,0

(919 değerlendirme)

8,1

@schoudhary1553

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of experience of 5 years. b) I work very hard (16+ hours a day and 7 days a week) and also very fast so... it will be done very soon than most of the other providers c) And most important part is my policy: "I will give you (to my client) life time support (as long as you keep relation with me). And fix any bugs/problem without any cost. So, don't ever worry about me” Please sir, leave a reply ASAP, as I am waiting for your kind reply

£90 GBP 1 gün içinde

4,9

(346 değerlendirme)

8,0

@DanielVizcaya91

Hi there. My name is Daniel and I would be glad to help you out with this project. I think I clearly understand what you are looking to achieve. I would just like to clarify if there will be only one chart display, which will be displaying the daily, weekly or monthly data, depending on the button you click? I can guarantee an excellent job and deliver as soon as possible. Hope to hear back from you soon. Thanks

£149 GBP 3 gün içinde

4,8

(92 değerlendirme)

6,8

@younus15

Hi, I have extensive experience in excel and coding, I can do your project with highest quality.

£277 GBP 3 gün içinde

4,9

(136 değerlendirme)

6,2

@sarcscoin

Hi, I am good at Excel programming. I have seen the details provided. I would like to discuss the project in detail. Looking forward to work on.

£60 GBP 2 gün içinde

5,0

(67 değerlendirme)

5,7

@osmemon

I have been developing models using Advance Excel and VBA for past 5 years with 100% client satisfaction history. This project is at my tips as I have automate so many kind of charting models in the past. Kindly contact me.

£28 GBP 1 gün içinde

4,8

(33 değerlendirme)

5,6

@surekash7096

I have the expertise and experience to create a Excel file with VBA based on your requirements. Please clarify, if the charts are dynamic selection or only a refresh of the data. Ready to start work immediately.

£133 GBP 3 gün içinde

4,6

(65 değerlendirme)

5,3

@teeares

I have read your project description and I can meet all your requirements. Please message for a discusion

£23 GBP 3 gün içinde

4,5

(50 değerlendirme)

5,0

@VinayOnTask

Hi there, I’d like to be considered for your bid. I am a software developer with a strong background developing excel, access related applications, including excel functions,active x objects, sql server as backend, data processing. I can design and develop excel, ms access applications in quick time ensuring the final output is as per the precise requirement. Over 10 yrs I've worked in VBA technology and so I am accustomed to working with all sorts of excel, access related development. You can be sure that I will use my best skills to ensure the successful completion of the project. I highly value professionalism and hold myself strictly accountable to represent client's profile. I aim to form a long term working relationship. Please, let me know what is needed to secure this bid! Thank you for your consideration. Vinay

£115 GBP 5 gün içinde

4,7

(9 değerlendirme)

4,1

@Goalaholic

Hello Dear, I have gone through with your requirements. I have understood fully. I ll design a macro that will update charts based on data.. I can also help you with fetching data from other files, if require. I understand all the technical indicators like moving averages, RSI etc... As i have knowledge of both fields, i can perform well than others. I have also develop similar work for currencies as well which I can show you before you award me this project. Looking for your response. Best Regards

£61 GBP 1 gün içinde

5,0

(18 değerlendirme)

3,8

@Gathix444

Dear Client, Thanks for the opportunity to bid on this project. I’ve read your brief on the project and is ready to go for it. I’ve done work on photoshop, data gathering, data analysis, web researching, data entry and translation (English to Mandarin and vice versa) in the past for various clients and I’m also an expert on excel application developing. Please take a look at my profile and reviews, as my clients can prove I provide good services. I believe in my quality of work meets the clients’ expectations and satisfaction. My profile: https://www.freelancer.com/hireme/Gathix444 Can we discuss the project in details if you are available? I look forward to hearing from you. Kind Regards, Chun-Chieh Sung

£130 GBP 3 gün içinde

4,9

(17 değerlendirme)

3,9

@humayoonsheikh4u

A proposal has not yet been provided

£150 GBP 3 gün içinde

4,7

(12 değerlendirme)

4,2

@NataliyaKNA

Hi, it's a really good and not easy project, but I can do this. All questions and desires can be discussed. And it's not decided in two days.

£150 GBP 5 gün içinde

4,6

(9 değerlendirme)

2,7

@Ridabzeyad

Dear sir, I promise to do my best to complete your project with the skills i have to deliver it right om time, please consider my offer and i will not let you down. Thank you.

£166 GBP 3 gün içinde