Charting in Excel using VBA
This project was successfully completed by kolosibalint for £100 GBP in 3 days.Get free quotes for a project like this
Project Budget£20 - £250 GBP
Completed In3 days
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.
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online