Charting in Excel using VBA

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.

Skills: Excel

See more: getting data as400 using excel vba, creating web pages using excel vba, using excel webscraper vba, vba macro scripts using excel, accessing web pages using excel vba https, connect access using excel vba, calculate salary using excel vba, projects using excel vba, accessing web pages using excel vba, web scraping using excel vba, access ftp using excel vba, using excel data google finance vba, data oracle batch using excel vba, download web page using excel vba, generate report word using excel vba

About the Employer:
( 2 reviews ) Tetbury, United Kingdom

Project ID: #13465083

Awarded to:


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 w More

£100 GBP in 3 days
(64 Reviews)

23 freelancers are bidding on average £129 for this job


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 More

£100 GBP in 1 day
(388 Reviews)

Hello TOMGDBROWN, I have read your project description clearly and understood your charts requirement. I have 5 years experience in VBA programming and agree that can complete task with high quality and [url removed, login to view] More

£60 GBP in 2 days
(133 Reviews)

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 ex More

£90 GBP in 1 day
(128 Reviews)

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, whi More

£149 GBP in 3 days
(66 Reviews)
£250 GBP in 7 days
(41 Reviews)

Hello dear, By carefully read through your project description i understood about your requirements.I can perfectly complete your project with 100% accuracy. Let"s [url removed, login to view]

£66 GBP in 1 day
(48 Reviews)

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

£23 GBP in 3 days
(47 Reviews)

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 in 3 days
(55 Reviews)

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 in 2 days
(35 Reviews)

i can send first draft for your test within 2 days please clarify fonts & colors for the graphs .

£166 GBP in 3 days
(6 Reviews)

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 More

£130 GBP in 3 days
(15 Reviews)

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 unders More

£61 GBP in 1 day
(18 Reviews)

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, dat More

£115 GBP in 5 days
(8 Reviews)

A proposal has not yet been provided

£150 GBP in 3 days
(8 Reviews)

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

£277 GBP in 3 days
(14 Reviews)

I have four years of experience in building excel-vba based tool and dashboards.

£50 GBP in 3 days
(8 Reviews)

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 in 5 days
(5 Reviews)

Hello, I have been working with a MNC based company since last ~ 6 years, as an IT BI DWH Professional. The project is a BI DWH project which covers 3 layers of BI (ETL, Data warehouse & Reporting) and helped me in More

£222 GBP in 10 days
(3 Reviews)

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 contac More

£28 GBP in 1 day
(0 Reviews)

Well I will use Excel VBA to display three different sets of data onto a chart, Daily, weekly and monthly. Virtually assisted more than 100+ successful projects along with development team handling and client commun More

£277 GBP in 15 days
(0 Reviews)