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 In
3 days
Total Bids
Project Description

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.

Completed by:
Skills Required

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

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online